How to use Count function using C# in ASP.Net

Hi varun3752,

Refer the below code. You can get in multiple ways. Below are two ways.

C#

string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
string query = @"SELECT COUNT(sno) FROM customer_sa";
using (SqlConnection con = new SqlConnection(constr))
{
    con.Open();
    using (SqlCommand cmd = new SqlCommand(query))
    {
        cmd.Connection = con;
        object obj = cmd.ExecuteScalar();
        if (obj != null)
        {
            lblregistrationcount.Text = obj.ToString();
        }
    }
    con.Close();
}

Or

string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
string query = @"SELECT COUNT(sno) FROM customer_sa";
using (SqlConnection con = new SqlConnection(constr))
{
    using (SqlCommand cmd = new SqlCommand(query))
    {
        using (SqlDataAdapter sda = new SqlDataAdapter())
        {
            cmd.Connection = con;
            sda.SelectCommand = cmd;
            using (DataSet ds = new DataSet())
            {
                sda.Fill(ds);
                lblregistrationcount.Text = ds.Tables[0].Rows[0][0].ToString();
            }
        }
    }
}