Start Free Trial

asked on

SQL Query Designer Control for VB .NET

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?

have a look at http://www.codeproject.com/KB/custom-controls/SqlWhereBuilder.aspx

ASKER

That the kind of thing i'm looking for but my application is a windows forms application. Thanks anyway.

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

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

ASKER

They look good, thanks for your help.

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