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

Last Reply 4 months ago By AnkitPal

Posted 4 months ago

here is my code,

This code is not in correct form, this code display record, but only 1,

why this code is not displaying my all existing recods

//connectionstring
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();
}

 

You are viewing reply posted by: AnkitPal 4 months ago.
Posted 4 months ago

Thanks Buddy,

It was perfect answer.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html?aff_id=108