c# combobox autocomplete like method
- by Willem T
Ihave been looking for an LIKE autocompletion mode. can anyone help me with this.
When i enter a text in the combobox, the database should be asked for the data.
all that goes well.
But then i want my combobox to behave like the Suggest mode, but it doesn't work.
I Tried this:
cursorPosition = txtNaam.SelectionStart;
string query = "SELECT bedr_naam FROM tblbedrijf WHERE bedr_naam LIKE '%" + txtNaam.Text + "%'";
DataTable table = Global.db.Select(query);
txtNaam.Items.Clear();
for (int i = 0; i < table.Rows.Count; i++)
{
txtNaam.Items.Add(table.Rows[i][0].ToString());
}
Cursor.Current = Cursors.Default;
txtNaam.Select(cursorPosition, 0);
But the behavior that this function creates is off it doesnt work like the suggest mode its a bit buggy.
Can anyone help me to get it working properly
Thanks
