string Street = TextBoxStreet.Text;

        SqlConnection conn = new SqlConnection(config);
        conn.Open();

        string sql = "SELECT ID, firstName, lastName FROM Customer WHERE street=" + Street;

        SqlCommand comm = new SqlCommand(sql, conn);
        SqlDataReader dr = comm.ExecuteReader(); //Incorrect column name '[whatever's in TextBoxStreet.Text]'

while (dr.Read())
        {
            ListBoxSearchCust.Items.Add(dr[1] + " " + dr[2]);
        }

 string sql = "SELECT ID, firstName, lastName FROM Customer WHERE street='" + Street + "'";

quote:

---

Originally posted by visakh16

make string as

 string sql = "SELECT ID, firstName, lastName FROM Customer WHERE street='" + Street + "'";

and try

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---

quote:

---

Originally posted by KarinElvira

quote:

---

Originally posted by visakh16

make string as

 string sql = "SELECT ID, firstName, lastName FROM Customer WHERE street='" + Street + "'";

and try

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---

Ok, that was the one I hadn't tried yet and of course it works like a charm! *embarrased*
Thank you!

---