I have a couple of grids that I need to do this on, each grid has 3 or 4 GridDropDownColumns - i'm not sure the best way to implement this.
I understand that each GridDropDownColumn will receive it's items list from (in my case) an ObjectDataSource, so as I move from the 1st dropdown to the 2nd, the 2nd dropdown needs to be passed the value of he 1st dropdown so it can re-evaluate it's list and rebind .. and so the pattern flows along the columns.
My ObjectDataSource will have a custom SelectMethod, so I guess my questions are:
- How do I pass into the SelectMethod of the 2nd columns ObjectDataSource the value that was selected from the 1st columns DropDown?
- Once i'm in the SelectMethod of the 2nd column and i've received the value of the 1st columns dropdown, how do I force the 2nd column to re-evaluate it's ObjectDataSource -- from what I can tell the data is bound upfront as the grid item goes into edit mode; so I would need to trigger on value change of the 1st drop down that the 2nd drop-down needs to re-evaluate it's selection list.
- Do you have any simple examples of this cascading effect inside a grid? I've seen examples of cascading behavour but not inside a grid.
Thankyou
Brian.