Hello,
I am looking for a special control which allows the visitors of my ASP.NET page to build simple queries to underlaying database. Such control should provide the following abilities:
1. Initially user see a one row with two combo boxes and one text box. First combo box contains the list of all columns from some table, second - the list of operators (such as =, <>, >, <). The text box just allows to enter some value.
2. User select a column an operator and enter the value.
3. There must be an ability to add another one row with such controls (or second row should appear automatically when the first one is filled by some values).
4. All rows are combined by AND operator.
5. When all necessary rows are filled - user clicks on some button (e.g. "Build") and the control generates a correct SQL statement, executes it and show the result. Actually the last two steps are not necessary because my page could do it itself.
...
Go to the complete details ...