Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL Query Designer Control for VB .NET

Posted on 2008-10-21
6
Medium Priority
?
2,372 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
  • 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 1000 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
Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

 
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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Loops Section Overview

885 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