Real-time filtering?

[wbodger]

On any number of sites where you can drill down to get to the specific product that you want, there is often a list of properties on the left side of the screen from which you can choose how you want to filter. I am developing a few intranet apps that would do well having this type of functionality. Is this a shopping cart solution or is it something I could at least roughly mirror using just the classes etc. that are inherent in asp.net 4.5? If so, I am not even sure where to start. I have the data and I know the few fields that I would have as filter parameters (company, type and year) each populated with values from the db or with hardcoded values. As a for instance, I would initially have a list of all credit reports, then the user would choose between Competitor, Customer and Vendor, then they could choose to filter by year or by company if they choose. If you are unclear what I am talking about, places like store.nike.com have this kind of layout.

Thanks,
Willie

 

[gk53]

I did not see a problem...
All your options on droopdown boxes and results on grid.
each dropdown has onSelectedIndexChanged event, with fierd event to apply filter to your grid...
Which specific part you need to help

 

[wbodger]

So, I would apply filters to a gridview?

 

[jbenson001]

You would not apply filters to the gridview directly, you would apply filters to the underlying datasource. I would assume you are calling a stored procedure to get your data and populating your gridview from that.

 

[wbodger]

Sorry for the delay, got sidetracked onto other projects since this data wasn't quite ready for me yet. Yes, I will have a stored procedure to get the data to be filtered. Do you know of any good tutorials with examples that I could pull apart to understand this process?

Thanks,
Willie

 

[jbenson001]

You have to put together what search criteria is mandatory and what is optional. Check this example:

http://stackoverflow.com/questions/...uery-with-multiple-optional-search-parameters

And DO NOT USE DYNAMIC SQL !!!!!

There is rarely a case where you need it.