Autocomplete textbox From Database in windows forms

Based on the article that you referred to, I would run two queries

    using (SqlConnection con = new SqlConnection(ConString))
    {
        SqlCommand cmd = new SqlCommand("SELECT FirstName FROM Employees", con);
        con.Open();
        SqlDataReader reader = cmd.ExecuteReader();
        AutoCompleteStringCollection MyCollection = new AutoCompleteStringCollection();
        while (reader.Read())
        {
            MyCollection.Add(reader.GetString(0));
        }

        cmd = new SqlCommand("SELECT LastName FROM Employees", con);
        reader = cmd.ExecuteReader();
        while (reader.Read())
        {
            MyCollection.Add(reader.GetString(0));
        }

        txtFirstName.AutoCompleteCustomSource = MyCollection;
        con.Close();
    }

Not tested, just copied and modified.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Wim Sturkenboom12y ago
Based on the article that you referred to, I would run two queries

    using (SqlConnection con = new SqlConnection(ConString))
    {
        SqlCommand cmd = new SqlCommand("SELECT FirstName FROM Employees", con);
        con.Open();
        SqlDataReader reader = cmd.ExecuteReader();
        AutoCompleteStringCollection MyCollection = new AutoCompleteStringCollection();
        while (reader.Read())
        {
            MyCollection.Add(reader.GetString(0));
        }

        cmd = new SqlCommand("SELECT LastName FROM Employees", con);
        reader = cmd.ExecuteReader();
        while (reader.Read())
        {
            MyCollection.Add(reader.GetString(0));
        }

        txtFirstName.AutoCompleteCustomSource = MyCollection;
        con.Close();
    }

Not tested, just copied and modified.