in below code label is not returning value.
so please help me
var ddl_Comp = ddl_comp.SelectedItem.Text;
var Nozzle_price = lbl_nprice.Text;
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Mycon"].ToString());
con.Open();
SqlCommand cmd = new SqlCommand("select nozzle_lph FROM company_sprinkler_data WHERE company_email = @ddl_Comp and nozzle_price = @Nozzle_price",con);
cmd.Parameters.AddWithValue("@ddl_Comp", ddl_Comp);
cmd.Parameters.AddWithValue("@Nozzle_price", Nozzle_price);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read() == true)
{
Label1.Text = dr["nozzle_lph"].ToString();
}
con.Close();