Advertisement
Guest User

Untitled

a guest
Jan 19th, 2017
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.24 KB | None | 0 0
  1. private void loadAutoCompleteValues()
  2. {
  3. autoCompleteCombo.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
  4. autoCompleteCombo.AutoCompleteSource = AutoCompleteSource.CustomSource;
  5.  
  6. DataTable products;
  7. con.MysqlQuery("select * from products");
  8. products = con.QueryEx();
  9. Dictionary<string, string> comboSource = new Dictionary<string, string>();
  10.  
  11. for (int i = 0; i < products.Rows.Count; i++)
  12. {
  13. DataRow dr = products.Rows[i];
  14. comboSource.Add(dr["id"].ToString(), dr["name"].ToString());
  15. }
  16.  
  17. autoCompleteCombo.DataSource = new BindingSource(comboSource, null);
  18. autoCompleteCombo.DisplayMember = "Value";
  19. autoCompleteCombo.ValueMember = "Key";
  20. }
  21.  
  22. private void autoCompleteCombo_SelectedIndexChanged(object sender, EventArgs e)
  23. {
  24. string key = ((KeyValuePair<string, string>)autoCompleteCombo.SelectedItem).Key;
  25. string value = ((KeyValuePair<string, string>)autoCompleteCombo.SelectedItem).Value;
  26.  
  27. MessageBox.Show(key + " " + value);
  28. }
  29.  
  30. autoCompleateCombo.DataSource = new BindingSource(comboSource, null);
  31. autoCompleateCombo.DisplayMember = "Value";
  32. autoCompleateCombo.ValueMember = "Key";
  33. autoCompleateCombo.AutoCompleteSource = AutoCompleteSource.ListItems; //<-- Added this line
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement