edit in datagridviewcom bobox with keyboard

[DominicHelen]

I have used this following:

private void EditingControlS howing(object sender, DataGridViewEdi tingControlShow ingEventArgs e)

{

DataGridViewCom boBoxEditingCon trol cbo = e.Control as DataGridViewCom boBoxEditingCon trol;

cbo.DropDownSty le = ComboBoxStyle.D ropDown;

}

private void dataGridView1_C ellValidating(o bject sender, DataGridViewCel lValidatingEven tArgs e)

{

if (e.ColumnIndex == this.dataGridVi ew1.Columns[0].Index)

{

DataGridViewCom boBoxColumn comboBoxColumn = (DataGridViewCo mboBoxColumn)th is.dataGridView 1.Columns[0];

object eFV = e.FormattedValu e;

if (!comboBoxColum n.Items.Contain s(eFV))

{

comboBoxColumn. Items.Add(eFV);

this.dataGridVi ew1.CurrentCell .Value = e.FormattedValu e;

}

}



}

}



make datagridviewcom boboxcolumn working for type new text which is not in the drop down list.


However, after that, if i want to type a text in the list, it ignore it. It just accept opening the arrow and selecting a item with a mouse or up down key. And my user want it badly, they prefer to type everything, no matter whether it is or not in the drop down list. Any help?





Thanks

Helen

[vidhyapriya]

Private Sub DataGridView1_E ditingControlSh owing(ByVal sender As System.Object, ByVal e As System.Windows. Forms.DataGridV iewEditingContr olShowingEventA rgs) Handles DataGridView1.E ditingControlSh owing
Try

If COLUMNINDEX= 2 Then
cbo = CType(e.Control , DataGridViewCom boBoxEditingCon trol)
AddHandler cbo.SelectedInd exChanged, AddressOf cbo_selectchang ed
End If

Dim comboBoxColumn As DataGridViewCom boBoxColumn = _
DataGridView1.C olumns(2)
If (DataGridView1. CurrentCellAddr ess.X = _
comboBoxColumn. DisplayIndex) Then
Dim cb As ComboBox = e.Control
Dim s As String
If (cb IsNot Nothing) Then
cb.DropDownStyl e = ComboBoxStyle.D ropDown
End If
End If

Catch ex As Exception
MessageBox.Show (ex.Message)
End Try
End Sub
Private Sub cbo_selectchang ed(ByVal sender As Object, ByVal e As EventArgs)

Try

If columnindex= 2 Then
ada = New OleDbDataAdapte r("select DISTINCT prodcode from Table1 where prodname='" + cbo.SelectedIte m.ToString() + "' ", con)
Dim dt As New DataTable
ada.Fill(dt)
If dt.Rows.Count > 0 Then
DataGridView1.I tem(1, i).Value = dt.Rows(0).Item Array(0).ToStri ng()
End If
End If
Catch ex As Exception
MessageBox.Show (ex.Message)
End Try
End Sub

Private Sub DataGridView1_C ellValidating(B yVal sender As System.Object, ByVal e As System.Windows. Forms.DataGridV iewCellValidati ngEventArgs) Handles DataGridView1.C ellValidating
Dim comboBoxColumn As DataGridViewCom boBoxColumn = _
DataGridView1.C olumns(2)
If (e.ColumnIndex = comboBoxColumn. DisplayIndex) Then
If (Not comboBoxColumn. Items.Contains( _
e.FormattedValu e)) Then
comboBoxColumn. Items.Add(e.For mattedValue)
DataGridView1.I tem(2, e.RowIndex).Val ue = e.FormattedValu e
End If
End If
End Sub

try this...

thanks
vidhya

[DominicHelen]

Thanks for the help! It really helps!!

[DominicHelen]

Now I found a problem with it, it works with keyboard very well now. But when one user happened to use mouse click to select a a value, then it pop up an error exception"NullR eferenceExcepti on" which i can not catch it. Do you know what cause that? Thanks again!


Helen