Windows Form - Runtime Query Builder

Question

Hi All!

I'm pulling out the remaining grey hair I have left trying to figure out how to create a runtime, graphical user interface for building sql queries.  I have Visual Basic .Net 2003 and Infragistics 2005 v2.  Please help!

Answer 1

you need to be very careful of creating a UI that will allow SQL "Injection" attacks,
However without security taken into consideration you could do something like this:


Dim MySqlString = "SELECT " & SelectTextBox.Text & " FROM " & FromTextBox.text & " Where " & WhereTextBox.Text & ";"

Answer 2

Maybe this article will help

http://www.code-magazine.com/article.aspx?quickid=0509041&page=1

Answer 3

Thank you for the responses.  To be more precise, I'm seeking code or component that has graphical capability much like you would find in a report utility such as Crystal Reports.  The application I'm developing is designed to extract transactional data from ERP systems, so I need the ability to:

list files/tables and their fields/columns;
link and multiple files/tables;
enter selection criteria using boolean logic;
and aggregate the results when necessary.

I hope this is explanation helps!  Thanks again for everyone's support!