Solved

SQL Query Designer Control for VB .NET

Posted on 2008-10-21
6
2,280 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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

627 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