Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void loadAutoCompleteValues()
- {
- autoCompleteCombo.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
- autoCompleteCombo.AutoCompleteSource = AutoCompleteSource.CustomSource;
- DataTable products;
- con.MysqlQuery("select * from products");
- products = con.QueryEx();
- Dictionary<string, string> comboSource = new Dictionary<string, string>();
- for (int i = 0; i < products.Rows.Count; i++)
- {
- DataRow dr = products.Rows[i];
- comboSource.Add(dr["id"].ToString(), dr["name"].ToString());
- }
- autoCompleteCombo.DataSource = new BindingSource(comboSource, null);
- autoCompleteCombo.DisplayMember = "Value";
- autoCompleteCombo.ValueMember = "Key";
- }
- private void autoCompleteCombo_SelectedIndexChanged(object sender, EventArgs e)
- {
- string key = ((KeyValuePair<string, string>)autoCompleteCombo.SelectedItem).Key;
- string value = ((KeyValuePair<string, string>)autoCompleteCombo.SelectedItem).Value;
- MessageBox.Show(key + " " + value);
- }
- autoCompleateCombo.DataSource = new BindingSource(comboSource, null);
- autoCompleateCombo.DisplayMember = "Value";
- autoCompleateCombo.ValueMember = "Key";
- autoCompleateCombo.AutoCompleteSource = AutoCompleteSource.ListItems; //<-- Added this line
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement