I have an unbound datagridview with three comboboxes (e.g. A, B, C) All three comboboxes share the same datasource and use the same valuemember. If I change the value of say combobox A, then B and C change also.
My problem is that B and C do not show the update until after I click off of combobox A. I want B and C to update as soon as I make the selection on A. How do I do this
Here is my code associated with the datagridview, it works fine:
Private Sub DataGridView1_CellValueChanged(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellValueChanged If Me.Visible = True Then Dim ColumnIndex
ColumnIndex = DataGridView1.CurrentCell.ColumnIndex
If ColumnIndex = 2 ThenIndexValue = DataGridView1.CurrentRow.Cells(2).Value
DataGridView1.CurrentRow.Cells(3).Value = IndexValue
DataGridView1.CurrentRow.Cells(4).Value = IndexValue
End If If ColumnIndex = 3 ThenIndexValue = DataGridView1.CurrentRow.Cells(3).Value
DataGridView1.CurrentRow.Cells(2).Value = IndexValue
DataGridView1.CurrentRow.Cells(4).Value = IndexValue
End If If ColumnIndex = 4 ThenIndexValue = DataGridView1.CurrentRow.Cells(4).Value
DataGridView1.CurrentRow.Cells(2).Value = IndexValue
DataGridView1.CurrentRow.Cells(3).Value = IndexValue
End If Else Exit Sub End If End Sub
How would I set focus onto another combobox on the datagridview
Ellis,
I tried your suggestion both with the datagridview.focus and textbox.focus, netiher worked. It appears that nothing happens when I make a selection (e.g. the value is changed). The update happens after I click off of the combobox. I need the update to happen as soon as the selected value in combobox A is changed.
Thanks,
Trey
You should handle the CurrentCellDirtyStateChanged event as well, since when you're selecting in the ComboBox, the cell is still in edit mode, the changes is not committed, hence the CellValueChanged event would not fire, so you have to force the commition. Moreover, see what I do in the CellValueChanged event handler function: void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e) { int rIndex = this.dataGridView1.CurrentRow.Index; object obj = this.dataGridView1.CurrentCell.Value; this.dataGridView1[0, rIndex].Value = obj; this.dataGridView1[1, rIndex].Value = obj; this.dataGridView1[2, rIndex].Value = obj; } void dataGridView1_CurrentCellDirtyStateChanged(object sender, EventArgs e) { this.dataGridView1.CommitEdit(DataGridViewDataErrorContexts.Commit); }
Code Block
Zhi-Xin-Ye
Thank you! The CurrentCellDirtyStateChanged event did the trick.
Here is my code that now works:
Private
Sub DataGridView1_CellValueChanged(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellValueChanged If Me.Visible = True Then Dim ColumnIndexColumnIndex = DataGridView1.CurrentCell.ColumnIndex
If ColumnIndex = 2 ThenIndexValue = DataGridView1.CurrentRow.Cells(2).Value
DataGridView1.CurrentRow.Cells(3).Value = IndexValue
DataGridView1.CurrentRow.Cells(4).Value = IndexValue
End If If ColumnIndex = 3 ThenIndexValue = DataGridView1.CurrentRow.Cells(3).Value
DataGridView1.CurrentRow.Cells(2).Value = IndexValue
DataGridView1.CurrentRow.Cells(4).Value = IndexValue
End If If ColumnIndex = 4 ThenIndexValue = DataGridView1.CurrentRow.Cells(4).Value
DataGridView1.CurrentRow.Cells(2).Value = IndexValue
DataGridView1.CurrentRow.Cells(3).Value = IndexValue
End If Else Exit Sub End If End Sub
Private Sub DataGridView1_CurrentCellDirtyStateChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DataGridView1.CurrentCellDirtyStateChanged
DataGridView1.CommitEdit(DataGridViewDataErrorContexts.Commit)
End Sub