Vb.net - Datagridview Combobox column

Question

5.00/5 (1 vote)

See more:

, +

Hello ,

I am unable to load a Datagridview combobox column on a Keypress event. When the user enters a character , I'll fetch all the entries starting from that character (From the Database). During the same event i need to Suggest append all the list items. It works only when i move out of the cell and then come back.This is because the data is yet to be loaded on keypress event .

I have set the Auto Complete properties. I am working on VB2005 Express edition.

One more observation - It's works for a Normal combo box but not for a Datagridview Combobox column.

Is there any solution where i can load the Datagridview combobox column and suggest append after user presses a single character ?

Regards,
Rohit

Posted 4-Oct-12 0:28am

rohitpg

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

rohitpg · Answer 1 · 2012-10-07T21:19:00

Finally got what i wanted.Here is the Working Code in VB.net
Add a Datagridview with the first column as DatagridviewComboboxColumn
Paste the code and then Type 'a' to get all the list items in SuggestAppend format.

Public class Form1
Dim ComboMedType As ComboBox

Private Sub DataGridView1_EditingControlShowing(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewEditingControlShowingEventArgs) Handles DataGridView1.EditingControlShowing
If DataGridView1.CurrentCellAddress.X > 0 Then Exit Sub

ComboMedType = CType(e.Control, ComboBox)

If (ComboMedType IsNot Nothing) Then
'Change Style To DropDown, To Allow For Data Entry
ComboMedType.DropDownStyle = ComboBoxStyle.DropDown
ComboMedType.AutoCompleteMode = AutoCompleteMode.SuggestAppend
ComboMedType.AutoCompleteSource = AutoCompleteSource.ListItems
End If

AddHandler ComboMedType.KeyDown, AddressOf ComboMedType_KeyDown
End Sub

'In this event, 10 items are added into the combobox(A0,A1 etc)
Private Sub ComboMedType_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs)

'Load only when characters are Pressed
If e.KeyValue >= 65 And e.KeyValue <= 90 Then

Dim I As Short

While I < 10

Dim stDrugName As String = "A" & I

ComboMedType.Items.Add(Trim(stDrugName))
I += 1
End While

End If
End Sub

End class