Thread: Cell Level Dynamic ComboBox Fill in DataGridView Cell

Hi,

I want to add a ComboBox at Cell Level in DataGrid. i. e. There is one Static ComboBox(Suppose A) in a Cell of DataGrid, upon Selecting a value of that Combo Box, there on Next cell a ComboBox(Suppose B) will generate dynamically. My Problem is that, on first Row of Grid B ComboBox Value Changes to The value Of Current Row(When Adding a Differrent Value on 2nd Row). My Dynamic ComboBox Generation Code is Following:

Code:

    Private Sub dgvValue_CellEndEdit(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles dgvValue.CellEndEdit


        Select Case e.ColumnIndex

            Case A
                Dim dgvCboB As New DataGridViewComboBoxCell
                DT_B = FetchDatatable(dgvValue(A, e.RowIndex).EditedFormattedValue)
                dgvCboB.DataSource = DT_B
                dgvCboB.DisplayMember = "Value Name"
                dgvCboB.ValueMember = "GUID"
                dgvCboB.AutoComplete = True
                dgvValue(B, e.RowIndex) = dgvCboB
        End Select
     End Sub

Why exactly are you creating combo boxes one by one?

Like First is For Country and Second is for State

That doesn't answer the question. That doesn't require you to create DataGridViewComboBoxCells on demand. You can just add two DataGridViewComboBoxColumns to your grid as you normally would. The only difference would be that you would either rebind or filter the data source of the cell in the State column when the cell in the Country column of the same row had its Value set.

How to rebind the data of State when the Country value is set? that should take effect only in that row.

Handle the CellValueChanged event of the grid. Test e.ColumnIndex to see if the change was in the Country column. If it was, use e.RowIndex to get the row. Get the Value from the cell in the Country column and use that to get the appropriate state data and assign that to the DataSource of the cell in the State column.

In CellValueChanged event still cells are modified for other rows except the selected row for State column.

I don't really understand what you just posted but I assume that you're saying that it doesn't work. In that case you're doing it wrong. As we can't see what you're doing, we can't see what's wrong with it.