First write a function for Autocomplete, given below,
public void AutocompTXT(TextBox CtrlName, string Strsql, string FldName)
{
try
{
AutoCompleteStringCollection namesCollection = new AutoCompleteStringCollection();
cn.Connopen();
cmd = new SqlCommand(Strsql, cn.con);
dr = cmd.ExecuteReader();
if (dr.HasRows == true)
{
while (dr.Read())
{
namesCollection.Add(dr[FldName].ToString());
}
}
else
{
dr.Close();
}
CtrlName.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
CtrlName.AutoCompleteSource = AutoCompleteSource.CustomSource;
CtrlName.AutoCompleteCustomSource = namesCollection;
cn.Connclose();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}Use this function on form load like,
private void Frm_emp_info_details_Load(object sender, EventArgs e)
{
AutocompTXT(txtempname, "Select emp_name from emp_info", "emp_name");
}