In certain cases, changing the dataSource of one dropdown on selecting a value from other dropdown is known as the cascading effect. This effect can be applied to two dropdown controls within Grid upon editing that is explained in detail in this document. The following discussion
Render the Grid control in the Batch edit mode and events such as load, cellEdit, and beforeBatchSave.
In the load event of the of the Grid, update the editParams of the first dropdown column with the change event and define the change event with the required functionalities such as data collection from server-end and setting the value to the respective cell.
Later in the cellEdit event, next dropdown will be set to the dataSource and value. isrowEdited variable maintains the edited row which will be cleared before saving all the records in the beforeBatchSave event.
Figure: Grid Dropdown and Cascaded column in edited state.
This page will automatically be redirected to the sign-in page in 10 seconds.