I'm using Visual Web Developer, SQL Server management Studio Express, and VB.NET backcoding.
Q: I have an SQL database with about 500 records and 100 fields. I want to filter post-databind results in a gridview using drop-down lists. Example: 'age' has 5 categories, 'gender' has 2 categories, 'income' has 5 categories. How can i do this? Other solutions I have seen don't seem to be what I'm looking for...
I have a successful method that uses checkboxes where the user can select any combination of fields, then click a button to populate the gridview, and then click another button to send gridview results to Excel and then use the autofilter in Excel. THIS METHOD WORKS GREAT AND IS REALLY SIMPLE. However, the boss wants gridview results filtered after the intitial databind and would rather not send the preliminary results to Excel for subfiltering like I suggested we do......management prefers I do a whole bunch more coding rather than use Excel to do something it does really well. Any help is appreciated.