This is a migrated thread and some comments may be shown as answers.

Using "visible content" dropdowns to filter grid

0 Answers 19 Views
DropDownList
This is a migrated thread and some comments may be shown as answers.
Steven
Top achievements
Rank 1
Steven asked on 31 Jul 2012, 04:33 AM
I have a grid that returns a large amount of records that I would like to create some drop downs that filter the contents of the grid, but the contents of the drop downs are based on what is visible in the grid.   Kind of like the way Excel does a data filter.

Example:

Assume I have 5 columns, three of them are product, customer and vendor.  When the grid is populated there are three dropdowns that  list all of the visible products, customers and vendors respectively.  

If you pick a customer, the vendor and product dropdowns should only show those relevant to the chosen customer.  
If a vendor is then chosen, only those products that are within that vendor and customer are displayed in the dropdowns.

Does anyone have some suggestions/sample code as to how this can be accomplished?

No answers yet. Maybe you can help?

Tags
DropDownList
Asked by
Steven
Top achievements
Rank 1
Share this question
or