Category / Section
How to change value of other columns while changing the value in a combobox column in WinForms DataGrid (SfDataGrid)?
1 min read
Change the value of other columns
You can change the value of other columns when changing value in GridComboBoxColumn of a row using the CellComboBoxSelectionChanged event.
C#
this.sfDataGrid1.CellComboBoxSelectionChanged += sfDataGrid1_CellComboBoxSelectionChanged; void sfDataGrid1_CellComboBoxSelectionChanged(object sender, CellComboBoxSelectionChangedEventArgs e) { if (e.GridColumn.MappingName == "ShipCityID" && e.SelectedIndex == 0) (e.Record as OrderInfo).ShipCountry = "Canada"; }
VB
AddHandler Me.sfDataGrid1.CellComboBoxSelectionChanged, AddressOf sfDataGrid1_CellComboBoxSelectionChanged Private Sub sfDataGrid1_CellComboBoxSelectionChanged(ByVal sender As Object, ByVal e As CellComboBoxSelectionChangedEventArgs) If e.GridColumn.MappingName = "ShipCityID" AndAlso e.SelectedIndex = 0 Then TryCast(e.Record, OrderInfo).ShipCountry = "Canada" End If End Sub
Sample: How to change value of other columns while changing the value in a combobox column?