title: how to retrieve all value from table data from database in asp.net & display in string/label
body: <pre><code>con.Open();
  string query = "select Calf_ID,Plant,date1,Event from Holiday_Master ";
  cmd = new SqlCommand(query, con);
  cmd.CommandType = CommandType.Text;
  dr = cmd.ExecuteReader();
  
  while (dr.Read())
  {
      Label1.Text = dr["Calf_ID"].ToString();
      Label2.Text = dr["Plant"].ToString();
      Label3.Text = dr["date1"].ToString();
      Label4.Text = dr["Event"].ToString();
  }
  
  con.Close();
  </code></pre>
  
  <p>I am using this code but it retrieves only one row from table I want all data from Table.</p>