I have a db which a 5-6 data for a pair of data that is, if I select x and y from combo boxes I get time distance and etc.

See more:

C#3.5

C#5.0

C#6.0

My problem is when i select Bangalore and mumbai From 2 different combobox i get the output as individual data / single data from db, while i have given serveral data in data base and it gives only one. for example i have several flights from bangalore to mumbai with different timings so i need help to display all the timings.

What I have tried:

private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
{

    SqlConnection con = new SqlConnection("Data Source=.;AttachDbFilename=C:\\Program Files\\Microsoft SQL Server\\MSSQL12.MSSQLSERVER\\MSSQL\\DATA\\enq.mdf;Integrated Security=True;Connect Timeout=30");
    con.Open();
    String str = "select * from Air where Air_To = '" + comboBox2.Text + "'and Air_From = '" + comboBox1.Text + "'";
    SqlCommand cmd = new SqlCommand(str, con);
    SqlDataReader dr = cmd.ExecuteReader();
    if (dr.Read())
    {
        textBox1.Text = dr["Air_dist"].ToString();
        richTextBox1.Text = dr["Air_departure"].ToString();

    }