SqlDataReader how to retrieve data

Question

I am trying to retrieve just CompanyName associated with CustomerID. But nothing is displayed inside the TextBox when the ComboBox item is changed. I don't get any exceptions.

private void Form1_Load(object sender, EventArgs e)
{
    SqlConnection connection = new SqlConnection(cnn);
    SqlCommand cmd = new SqlCommand("select CustomerID FROM Customers", connection);
    connection.Open();
    SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
    while (dr.Read()) {
        comboBox1.Items.Add(dr["CustomerID"]);
    }
}

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
    SqlConnection connection = new SqlConnection(cnn);
    string query = "select * from Customers where CustomerID='" + comboBox1.SelectedIndex + "'";
    SqlCommand cmd = new SqlCommand(query, connection);
    connection.Open();
    SqlDataReader dr = cmd.ExecuteReader();
    while (dr.Read()) {
        textBox1.Text = dr["CompanyName"].ToString();
    }
}

Raghubar · Accepted Answer · 2013-08-09 15:59:50Z

1

There is problem in your sql query.Chenge comboBox1.SelectedIndex to comboBox1.SelectedItem.Text.ToString(). Correct it as below.

string query = "select * from Customers where CustomerID='" + comboBox1.SelectedItem.Text.ToString() + "'";

answered Aug 9, 2013 at 15:59

Raghubar

2,7981 gold badge23 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ajay · Accepted Answer · 2013-08-10 16:26:15Z

0

You Can also change the query like...

string query = "select * from Customers where CustomerID='" + comboBox1.SelectedItem.Text + "'";

answered Aug 10, 2013 at 16:26

Ajay

2,08020 silver badges35 bronze badges

Collectives™ on Stack Overflow

SqlDataReader how to retrieve data

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related