I need some input as to how the cleanest way to code the following. I
have a aspx search page with a datalist displaying the results. Above
the datalist are 2 textboxes and 2 dropdownlists.
The idea is that the end user can choose any combination of the 2
textboxes and 2 dropdownlists to narrow down the search critera.
Should I write one stored procedure for each of the possible
combinations (16 combinations) and call them depending on what the
user selects? Should I write a massive stored procedure with 16
combinations?
There must be a leaner way of doing this?
Any help is highly appreciated.
Thanks