Autocomplete TextBox in Windows Form Application using SQL Server

Autocomplete TextBox in Windows Form Application using SQL Server.

In this article we Lear how to create autocompelete textbox on the basis of sql server data.

Step 1:

First open visual Studio ---->File---->New---->Project----->Windows From Application---->Ok

Drag and Drop label and TextBox.

Step 2:

Now Double Click on Windows Form and write the following Code :

        SqlConnection con = new SqlConnection(@"Data Source=IS9;Initial Catalog=practice;User ID=sa;Password=abc");

        public void loadData()

        {

            con.Open();

            AutoCompleteStringCollection namesCollection = new AutoCompleteStringCollection();

            string querry = @"Select distinct [name] from [bio]";

            SqlCommand cmd = new SqlCommand(querry, con);

            SqlDataReader dr = cmd.ExecuteReader();

            if (dr.HasRows == true)

            {

                while (dr.Read())

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

            }

            dr.Close();

            con.Close();

            textBox1.AutoCompleteMode = AutoCompleteMode.Append;

            textBox1.AutoCompleteSource = AutoCompleteSource.CustomSource;

            textBox1.AutoCompleteCustomSource = namesCollection;

        }

        private void textBox1_KeyUp(object sender, KeyEventArgs e)

        {

            loadData();

        }

    }

}

Output:

Press F5