Experts whats the best way to deal with this problem. Do I write a query form that builds up a select statement or is there some webbased query tool that I can just hand over to the client? Let me explain;
I have an asp.net webpage with about 30 textboxes.
The client wants another screen that allows them to run a query on any combination of these fields.
(In reality I expect that they wont ever query for more than a combination of 5 of the fields though)
So for example they want something that would allow them to choose zipcode,startdate,enddate,value and address1 and filter like this -
ZIPCODE => 94122 AND ZIPCODE < 94126
STARTDATE > '01/04/2009'
ENDDATE < '22/04/2009'
VALUE < 10000
ADDRESS1 BEGINS '27'
If you think I should build up the select statement then an example would be great if you could find one.
Im using Visual Studio 2008 (VB Code), sql server express 2008,