(1, 'Janno', 'Palacios', 'E'), (2, 'John Craig', 'Nillos', 'P');
using MySql.Data.MySqlClient;
MySqlConnection con = new MySqlConnection("server=localhost;user id=root;password=janobe;database=test;sslMode=none"); MySqlCommand cmd; MySqlDataAdapter da; DataTable dt; string sql;
public void autocomplete() { try { sql = "SELECT * FROM tblperson"; con.Open(); cmd.Connection = con; cmd.CommandText = sql; da.SelectCommand = cmd; da.Fill(dt); int maxcolumn = dt.Columns.Count - 1; foreach(DataRow row in dt.Rows) { for (int i = 0; i < maxcolumn; i++) { comboBox1.AutoCompleteCustomSource.Add(row.Field<string>("Fname")); comboBox1.AutoCompleteCustomSource.Add(row.Field<string>("Lname")); comboBox1.AutoCompleteCustomSource.Add(row.Field<string>("Mname")); } } }
private void Form1_Load(object sender, EventArgs e) { autocomplete(); }