In this article I will explain you how to implement autocomplete textbox from database in windows forms Application in asp.net.
first we need to create database for implement autocomplete textbox in windows application.
Here, we create database in sql server, database name is :AutoComplete
Create a Table in Database, Table name is : UserMst
Design table with 1 column named UserName.
UserName as nvarchar(50) datatype Allow null = Yes
After completion of design table enter some values in table manually for our example.
Now, design a windows for with one TextBox control ID = txtName
First set two main TextBox control property for autocomplete.
AutoCompleteMode = Suggest , Append or SuggestAppend
Set anyone from three of above for autocomplete textbox
AutoComlateSource = CustomSource
After doing this write below code at Form_Load event of windows form
private void Form1_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source='.\\SQLEXPRESS';Integrated Security='true';Initial Catalog='AutoComplete'");
SqlCommand cmd = new SqlCommand("SELECT UserName FROM UserMst", con);
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
AutoCompleteStringCollection SCollection = new AutoCompleteStringCollection();
while (reader.Read())
{
SCollection.Add(reader.GetString(0));
}
txtName.AutoCompleteCustomSource = SCollection;
con.Close();
}
After write above code in load event just run your windows form and enjoy autocomplete textbox from database in windows application.