VB.NET Query Builder

Is there any way I can open the Query Builder (the one which we get when we build CommandText) from code? I need to call up the Query Builder when user clicks a button on my form. Please help.
ndrooAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
naveenkohliConnect With a Mentor Commented:
For run time creation of SQL Queries, you will have to build your component or something or buy a third party control.
The idea is pretty simple. You can call GetSchemaTable on your table. It will return a DataTable containing complete schema. Then you can process this table to build some kind of UI control displaying all the fields. Users can pick and choose the fields that they want to search on.

If your table is simple, then you should be able to come up with some component pretty quickly.

Naveen
0
 
CJ_SCommented:
This form is built into VS.Net and cannot be used outside.

CJ
0
 
ndrooAuthor Commented:
I actually want to create a property which allows creation of SQL command during development time. Just like the CommandText property. However, I need some easier way to create the SQL commands, instead of typing them manually. Any idea?
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
CJ_SCommented:
So, while developing you want an easy way to create SQL queries? Then the Query Builder would do, won't it? I'm confused as to what you want to do.

Do you want the enduser to click a button and create his / her own queries using a form or do you want an easy way during development?

CJ
0
 
joseph_kazziCommented:
You can use Microsoft English Query, which is built-in SQL Server to let your end-user build his/her own query by using plain english, where the english query engine will transfer the english statement to a "SELECT" statement. Be carefull the english query needs lot of knowledge in the english grammer.
0
 
ndrooAuthor Commented:
joseph_kazzi
Sorry I better rephrase my question. I actually want to create a property (eg. SQLSelect) and be able to click (at the property list) a button and activate the query builder during design time. It's not for runtime execution.

0
 
Michel SakrCommented:
And you want it at design time.. naveen proposed a good workaround..
Joseph proposed another one a bit tougher for end user..
0
 
Michel SakrCommented:
And you want it at design time.. naveen proposed a good workaround..
Joseph proposed another one a bit tougher for end user..
0
 
ndrooAuthor Commented:
Well, looks like we're going in circles huh? I do argee that naveen's suggestion is more accurate (though I probably have to crack my head trying to do the UI). So thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.