Devexpress MVC GridView ComboBox Column Type DataSource

Question

How to alternate DataSource in ComboBox Column inside Devexpress GridView by selecting value in other ComboBox column in same row.

It is something like cascading comboboxes but in Grid view (but in grid comboboxses don't have CallbackRouteValues property)

Grid has two comboboxes and if user selects one value in frst the second combobox must change datasource by function that takes id as parameter from first selected combobox

Answer 1

You want to use a LookUpEdit instead of ComboBox when you are using a datasource, then you can use the QueryPopUp event to set a filter to, or change your datasource.

Note that when you change the datasource for the LookUpEdit, the result in the grid might not look what you expected. To remedy that, you want to clear your filter in the QueryCloseUp event.