autocomplete textbox in windows applications? [Resolved]

public partial class AuthenticationForm : Form
{
public string strConnection = ("data source=mars-104;initial catalog=Sudheeptest;integrated security=true");
AutoCompleteStringCollection namesCollection = new AutoCompleteStringCollection();

private void LoginForm_Load(object sender, EventArgs e)
{
txt_username.Focus();
RePaint();
SqlDataReader dReader;
SqlConnection conn = new SqlConnection();
conn.ConnectionString = strConnection;
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "Select distinct [UserName] from [tbl_login] order by [UserName] asc";
conn.Open();
dReader = cmd.ExecuteReader();
if (dReader.HasRows == true)
{
while (dReader.Read())
namesCollection.Add(dReader["UserName"].ToString());
}
else
{
MessageBox.Show("Data Not Found");

}
dReader.Close();
txt_username.AutoCompleteMode = AutoCompleteMode.Suggest;
txt_username.AutoCompleteSource = AutoCompleteSource.CustomSource;
txt_username.AutoCompleteCustomSource = namesCollection;
}
}
 Download source file

Best,
Sudheep.

Harikrishna.veluru, if this helps please login to Mark As Answer. | Alert Moderator