How to change value of other columns while changing the value in a combobox column in WinForms DataGrid (SfDataGrid)

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