Search code examples
vb.netwinformsdatagridviewdatagridviewcomboboxcell

Get selected index of `DataGridViewComboBox`


When you add a ComboBoxColumn in DataGridView, I do not know how to handle the change event of ComboBox.

'Adding To DGV data on form load
Dim cmbovoce As New DataGridViewComboBoxColumn()
cmbovoce.HeaderText = "Fruit"
cmbovoce.Name = "cmbovoce"
cmbovoce.MaxDropDownItems = 4
cmbovoce.Width = 100
cmbovoce.Items.Add("apple")
cmbovoce.Items.Add("pear")
cmbovoce.Items.Add("cherries")
cmbovoce.Items.Add("plums")
DataGridView1.Columns.Add(cmbovoce)

Solution

  • I strongly recommend you to use Cell events, such as CellValidating, CellValueChanged, ... to detect changes. The combobox that you are trying to handle its SelectedIndexChange event, is a unique instance for all cells.

    Anyway, if you want to know how to handle SelectedIndexChange event of it,you can do it this way:

    Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        Dim c = New DataGridViewComboBoxColumn()
        c.HeaderText = "Fruit"
        c.Name = "c"
        c.MaxDropDownItems = 4
        c.Width = 100
        c.Items.Add("apple")
        c.Items.Add("pear")
        c.Items.Add("cherries")
        c.Items.Add("plums")
        Me.DataGridView1.Columns.Add(c)
    
        For index = 1 To 5
            Me.DataGridView1.Rows.Add()
        Next
    End Sub
    
    Private Sub DataGridView1_EditingControlShowing(sender As Object, e As DataGridViewEditingControlShowingEventArgs) Handles DataGridView1.EditingControlShowing
        If (TypeOf (e.Control) Is ComboBox) Then
            Dim combo = CType(e.Control, ComboBox)
            RemoveHandler combo.SelectedIndexChanged, AddressOf c_SelectedIndexChanged
            AddHandler combo.SelectedIndexChanged, AddressOf c_SelectedIndexChanged
        End If
    End Sub
    
    Private Sub c_SelectedIndexChanged(sender As Object, e As EventArgs)
        If (Me.DataGridView1.Columns(Me.DataGridView1.CurrentCell.ColumnIndex).Name = "c") Then
            Dim combo = CType(sender, ComboBox)
            'Do something with combo
        End If
    End Sub