Friday, November 11, 2005 5:02 PMHi 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!
Friday, November 11, 2005 5:44 PMModeratoryou 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 & ";"
Friday, November 11, 2005 6:51 PMModeratorMaybe this article will help
Friday, November 11, 2005 7:49 PMThank 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!