Query Builder C#/VB.NET component

[Autofreak]

Hello,

I would like to incorporate a query builder component into my application so that I could bulid sql statement dinamicaly (SQL Server, Access). Are there anything in MS or third party tools you can suggest?



Thank you,

serge

[Shuja Ali]

Do you want a graphical tool like we have in access? Or do you just need a text editor where you can write your queries and execute them?

Here is one developed by Neelam K. Iyer and posted on c-sharpcorner.
http://www.c-sharpcorner.com/Database/QueryBuilder100NKI.asp

[Autofreak]

Hey Shuja Ali,
I need a GUI tool in my app that would display the SQL Server DBs with all the metadata that comes with it like table and fileds in a control like TreeView. The user can create queries in a text box and execute them with resulted data displayed in a control like DataGridView on the same form. The idea is to be able to visually design queries and save/reuse them for report building.

Cheers,
Serge

[aniskhan]

there is a graphical query builder in sql server 2000.
In Enterprise Manager -->Data transformation services --> New Package(right click) --> Select the type of Connection (select for sql server) --> In dialog set the connection and select the DB --> Connection created --> Now select Task (Select SQL Execute Task) --> Click QueryBuilder Button -->Done

[Autofreak]

Thanks, it's good to know. But I am running SQL 2005 Express and I need a custom tool that I can integrate in my application for the end users to be able to build reports on their workstations.

Cheers,
Serge

[oneofzil]

i have one developed by myself in C#, sum1972@163.com

[sharonmiller]

Here's a c# generator that also uses stored procedures exclusively:
OxyGen Code
http://www.techinceptions.com/products.html#two

[korzh]

Not sure if it still necessary but we have such component (or better say "component library"): EasyQuery.NET.
It allows to include user-friendly query builder right into your Windows Forms application or ASP.NET web-page.
For more information please take a look at: http://devtools.korzh.com/eq/dotnet/

[joe100]

Hey,

Here is a tool I am suggesting you which I use. Query Generator is a downloads - tool from www.wbcsoftwarelab.com. I am a .net programmer and having many such tiny readymade tools at my desk. I use this tool to insert/update/etc. to-fro master and client databases. Actually after downloading this, I have changed the sourcecode a little according to my requirement.
Hope my suggestion would help you.

[ssmagin]

Have a look at Active Query Builder (http://www.activequerybuilder.com/). Seems to be what you're looked for (may be it's not too late ;).

[PavelDev]

Aspose.Report includes AdHoc.WinForms component which gives ability to generate SQL queries without SQL server installed. It works with multiply tables, can automatically join them and generate SQL query, filter data you provide.

Take a closer look at official page:
http://www.aspose.com/categories/.net-components/aspose.report-for-.net/default.aspx

Download (evaluation version):
http://www.aspose.com/community/files/51/.net-components/aspose.report-for-.net/default.aspx

Aspose.Report also includes Aspose.Report AdHoc.Web component with similar funcitonality for ASP.NET.

I'm one of Aspose team developers.