I have a dropdown list with the values "Any State","New York","New Jersey","California" etc and have a grid with columns(Product Name, Available,Entry Date,Features
etc) with following entries
Product Name Available Entry Date Feature
Product1 All States
Product2 New york,Richmond
Product4 All States
Product5 All States
Initially the current logon user state should be selected in the dropdown and this was already achieved here
.But there is a change in the requriment and now I have a new value in the dropdonw ie."Any State" .User will change dropdown selection to "Any State" or "New York","New Jersey" etc and should display Products that are available in that state.
For example :If current logon user belongs to "New York" then in the dropdown "New york" should be selected and should display all the records that are available in
New york state. The result grid would be (Product1,Product2,product
).That means I need to filter the data in the Grid based on dropdown selection with "Available" column data.
In the above Grid "Available" column data we will have either "All States" or individual State names.
so my logic should be something like this
USER STATE / Dropdown Selection Available (column)
-> Should display records [All States + New York] = Product1,Product2,Product4
->Should display records [All States + California]=Product1,Produ
t4 and Product5
->Shoud display all records [All states +Individual states(New york,Richmond,Michigan,cal
ifornia etc) ]
and Product5 (basically all the records in the Grid)
Any sample code would be highly appreciated