How Do I Display All Names Of Employees By Providing Partial

//Add MySql Library

using MySql.Data.MySqlClient;

private void Form1_Load(object sender, EventArgs e)

{

MySqlConnection con = new MySqlConnection(@"Server=servername;uid=userid;password=password;database=dbname"); con.Open();

AutoCompleteStringCollection namesCollection = new AutoCompleteStringCollection();

string query = @"Select [NAME] from [tablename]";

MySqlCommand cmd = new MySqlCommand(query, con);

MySqlDataReader dr = cmd.ExecuteReader();

if (dr.HasRows == true)

{

while (dr.Read())

namesCollection.Add(dr["name"].ToString());

}

dr.Close();

con.Close();

textBox1.AutoCompleteMode = AutoCompleteMode.Suggest;

textBox1.AutoCompleteSource = AutoCompleteSource.CustomSource; textBox1.AutoCompleteCustomSource = namesCollection;

}