assign data from table to labels using c#
<p>I'm using c# in a ASP.Net web application.I have the following query:</p>

<pre><code>SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["chestionar"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("select * from personal,Intrebari where personal.cod_numeric_personal=@cnp AND Intrebari.id_intrebare=14 AND Intrebari.id_intrebare=15 ", con);
cmd.Parameters.AddWithValue("@cnp", Session["sesiune_cnp"]);
SqlDataReader rdr;

rdr = cmd.ExecuteReader();

while (rdr.Read())
{

    lbl1.Text = rdr["Nume"].ToString();
    intrebare6.Text = rdr["Intrebari"].ToString();
    intrebare7.Text = rdr["Intrebari"].ToString();

}
</code></pre>

<p>I want those two values for id_intrebare=14 and 15 to assign it to those 2 labels.How can i refer to those?</p>
