protected void ButtonSearch_Click(object sender, EventArgs e)
    {
        ListBoxSearchCust.Items.Clear();
        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(); 

        ListBoxSearchCust.Items.Add("Result, customer:");

        while (dr.Read())
        {   
            ListBoxSearchCust.Items.Add(dr[0] + " " + dr[2] + ", " + dr[1]); //Error - nothing is displayed
        }
        dr.Close();
        conn.Close();
    }

        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);
        comm.Parameters.Add("@Street", SqlDbType.VarChar);
        comm.Parameters["@Street"].Value = Convert.ToString(TextBoxStreet.Text);
        SqlDataReader dr = comm.ExecuteReader(); //Error: "Incorrect syntax near '='".

DataTable dt =new DataTable();
SqlDataAdapter da = New SqlDataAdapter(command)
da.Fill(dt)

quote:

---

Originally posted by KarinElvira

I've tried using an adapter, and now it seems that the sql statement just doesn't find the record "street" even though it does exist.
This is what the code looks like now:

protected void ButtonSearch_Click(object sender, EventArgs e)
{
ListBoxSearchCust.Items.Clear();
string Street = TextBoxStreet.Text; --You are assiging value to variable. Ex: The value can be King too.
if (TextBoxStreet.Text != null)
{
SqlConnection cn = new SqlConnection(config);
DataSet ds = new DataSet("ds");
SqlDataAdapter da = new SqlDataAdapter("SELECT ID, firstname, lastname, street FROM Customer WHERE street='" + Street + "'", cn);
da.Fill(ds);
ListBoxSearchCust.DataSource = ds;
if (TextBoxStreet.Text != "street") --Here you are checking with Hardcoded value street and not King (as per example)
Secondly I don't see where you are chaging the value of textboxstreet.
{
LabelNoMatch.Visible = true; //this error message is showing
}
else
{
ListBoxSearchCust.DataTextField = "ID" + " " + "lastname" + ", " + "firstname";
ListBoxSearchCust.DataBind();
}
}
else
{
LabelNoStreet.Visible = true;
}
}

---

quote:

---

Originally posted by Sachin.Nand

What does ds.Tables[0].Rows.Count return ?

PBUH

---

quote:

---

Originally posted by Sachin.Nand

If it is a windows application just add MessageBox.Show(ds.Tables[0].Rows.Count)after u fill the dataset
or
if it is a web application add a label with id as lblcount to the page & set add this code after u fill the dataset lblcount.text=ds.Tables[0].Rows.Count.ToString()

PBUH

---

string sql = "SELECT ID, firstname, lastname FROM Customer WHERE street='" + @Street+ "'";

quote:

---

Originally posted by KarinElvira

Thanks, I know newbies are a pain in everybodys *ss*s ;)

---