I have a grid (see attached image) which has a number of columns that have a relationship to each other.
My question is how and where do I control the values shown in the combo boxes -- the data for each combo should be fetched from individual Stored Procedures, e.g.
DimensionAlias = just calls a stored procedure to get all the aliases
DimensionLevel = calls a stored procedure to get the Levels for the selected Dimension Alias
DimensionMember = calls a stored procedure to get the Members at the selected Level for the selected Alias
and so on...
Oh also the QueryChildLevel checkbox, should enable/disable the ChildLevel combo if it's checked/unchecked
I've looked at using the Grid_ItemDataBound handler, but this just allows me to initialise the combos at their initial state, however, if a user changes the DimensionAlias, then the DimensionLevel needs to be reset, and the values shown at the DimensionLevel combo should be reloaded from the Stored Procedure -- it's this i'm struggling to see how it can be achieved.
Thanks