edit in datagridviewcombobox with keyboard

[DominicHelen]

I have used this following:

private void EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)

{

DataGridViewComboBoxEditingControl cbo = e.Control as DataGridViewComboBoxEditingControl;

cbo.DropDownStyle = ComboBoxStyle.DropDown;

}

private void dataGridView1_CellValidating(object sender, DataGridViewCellValidatingEventArgs e)

{

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

{

DataGridViewComboBoxColumn comboBoxColumn = (DataGridViewComboBoxColumn)this.dataGridView1.Col umns[0];

object eFV = e.FormattedValue;

if (!comboBoxColumn.Items.Contains(eFV))

{

comboBoxColumn.Items.Add(eFV);

this.dataGridView1.CurrentCell.Value = e.FormattedValue;

}

}



}

}



make datagridviewcomboboxcolumn 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_EditingControlShowing(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewEditingControlSho wingEventArgs) Handles DataGridView1.EditingControlShowing
Try

If COLUMNINDEX= 2 Then
cbo = CType(e.Control, DataGridViewComboBoxEditingControl)
AddHandler cbo.SelectedIndexChanged, AddressOf cbo_selectchanged
End If

Dim comboBoxColumn As DataGridViewComboBoxColumn = _
DataGridView1.Columns(2)
If (DataGridView1.CurrentCellAddress.X = _
comboBoxColumn.DisplayIndex) Then
Dim cb As ComboBox = e.Control
Dim s As String
If (cb IsNot Nothing) Then
cb.DropDownStyle = ComboBoxStyle.DropDown
End If
End If

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

Try

If columnindex= 2 Then
ada = New OleDbDataAdapter("select DISTINCT prodcode from Table1 where prodname='" + cbo.SelectedItem.ToString() + "' ", con)
Dim dt As New DataTable
ada.Fill(dt)
If dt.Rows.Count > 0 Then
DataGridView1.Item(1, i).Value = dt.Rows(0).ItemArray(0).ToString()
End If
End If
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
End Sub

Private Sub DataGridView1_CellValidating(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellValidatingEve ntArgs) Handles DataGridView1.CellValidating
Dim comboBoxColumn As DataGridViewComboBoxColumn = _
DataGridView1.Columns(2)
If (e.ColumnIndex = comboBoxColumn.DisplayIndex) Then
If (Not comboBoxColumn.Items.Contains( _
e.FormattedValue)) Then
comboBoxColumn.Items.Add(e.FormattedValue)
DataGridView1.Item(2, e.RowIndex).Value = e.FormattedValue
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"NullReferenceException" which i can not catch it. Do you know what cause that? Thanks again!


Helen