Solved

SQL Query Designer Control for VB .NET

Posted on 2008-10-21
6
2,223 Views
Last Modified: 2013-11-12
I have a requirement to allow users to create simple views in a SQL database, ideally I would like to do this via my existing application without the use of the SQL Management Studio.

Does anybody know of a SQL query designer control that would allow the creation and saving of views in an MS Access/SQL style designer?
0
Comment
Question by:3Si_pnewman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
6 Comments
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 22765664
0
 
LVL 1

Author Comment

by:3Si_pnewman
ID: 22765746
That the kind of thing i'm looking for but my application is a windows forms application.  Thanks anyway.
0
 
LVL 70

Accepted Solution

by:
Éric Moreau earned 250 total points
ID: 22766207
I think you can get ideas from the link I have provided to reimplement it in a Windows forms.

or you can also try:
http://www.activequerybuilder.com/product_net.html
http://www.aquafold.com/
http://active-query-builder-activex-edition.active-database-software.qarchive.org/
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 51

Expert Comment

by:Mark Wills
ID: 22766542
Well there are a few around - some very good commercial ones such as : http://www.componentsource.com/products/active-query-builder-net/index.html
and http://www.activequerybuilder.com/product.html  or for a different style : http://devtools.korzh.com/eq/

then there are free ones - well worth looking into : http://www.programurl.com/active-query-builder-free-edition.htm   same as the first link...but free version.

some need a fair bit of "tidying up" but the core is there : http://www.codeproject.com/KB/database/SQL_Builder.aspx

and there's a few hundred more (share and free ware) : http://www.freedownloadscenter.com/Search/newsearch.php3?S_S=sql+query+builder

0
 
LVL 1

Author Comment

by:3Si_pnewman
ID: 22767201
They look good, thanks for your help.
0
 
LVL 51

Expert Comment

by:Mark Wills
ID: 22768427
Boo-Hoo, not even an assist - I thought  http://www.programurl.com/active-query-builder-free-edition.htm   was a shoe-in for sure.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
PROPERCASE SCRIPT IN SQL 3 23
tempdb log keep growing 7 44
Enabled trace flag 4135 or 4199 - SQL SERVER 2 23
What Is an Error? 2 24
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question