I have a Search.aspx that has 7 textboxes.
I have a DisplayResults.aspx where I will display my results.
This is what I'm doing and wonder if there's a better way of doing this:
1. Gathering textbox values in Search.aspx (7 textboxes)
2. I pass the string to DisplayResults.aspx using response.redirect and querystring
3. In DisplayResults.aspx, I will grab the query string.
4. In displayResults.aspx, I pass the 7 textboxes from querystring. Pass it to BLL class to build the "where" clause based on the 7 textboxes. Ex: I look at which field is filled, build a where clause using if-else.
5. BLL calls DAL and DAL runs Stored Proc using the "where" clause built in #4
6. Get results back and bind it Dataview or whatever in DisplayResults.aspx
Note I want to keep a 3 tier design. Too many steps? better way of doing this?
Start Free Trial
