Display number of Records in Label using C# in ASP.Net

AnkitPal says:

SqlCommand cmd = new SqlCommand("SELECT COUNT(*) column_name FROM table_name", cnn);

            {

                cnn.Open();

                SqlDataReader rdr = cmd.ExecuteReader();

                int count = 0;

                while (rdr.Read())

                {

                    count++;

                }

                label1.Text = "(" +count.ToString() + ") " + "records";

                cnn.Close();

            }

 replace above code with below

SqlCommand cmd = new SqlCommand("SELECT COUNT(*) Total_Count FROM table_name", cnn);
{
    cnn.Open();
    SqlDataReader rdr = cmd.ExecuteReader();
    while (rdr.Read())
    {
        label1.Text = "(" + rdr["Total_Count"].ToString() + ") " + "records";
    }
            
    cnn.Close();
}