Display total number records based on user in Label using C# in ASP.Net

George616 says:

 private void display1()

    {

        SqlConnection con = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\\Dataregister.mdf;Integrated Security=True");

        con.Open();

        SqlCommand cmd = new SqlCommand("SELECT COUNT(*) FROM Table1 where CreatedBy =@CreatedBy", con);

        cmd.Parameters.AddWithValue("@CreatedBy", createby.Text.Trim());

        cmd.ExecuteScalar();

 

        sda.Fill(ds);

        label1.Text = ds.Tables[0].Rows.Count.ToString();

        con.Close();

    }

    private void display2()

    {

        SqlConnection con = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\\Dataregister.mdf;Integrated Security=True");

        con.Open();

        SqlCommand cmd = new SqlCommand("SELECT COUNT(*) FROM Table2 where CreatedBy =@CreatedBy", con);

        cmd.Parameters.AddWithValue("@CreatedBy", createby.Text.Trim());

        cmd.ExecuteScalar();

        

        sda.Fill(ds);

        label2.Text = ds.Tables[0].Rows.Count.ToString();

        con.Close();

    }

Change above with below code.

    private void display1()
    {
        SqlConnection con = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\\Dataregister.mdf;Integrated Security=True");
        con.Open();
        SqlCommand cmd = new SqlCommand("SELECT COUNT(*) FROM Table1 where CreatedBy =@CreatedBy", con);
        cmd.Parameters.AddWithValue("@CreatedBy", createby.Text.Trim());
        label1.Text = Convert.ToString(cmd.ExecuteScalar());
        con.Close();
    }
    private void display2()
    {
        SqlConnection con = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\\Dataregister.mdf;Integrated Security=True");
        con.Open();
        SqlCommand cmd = new SqlCommand("SELECT COUNT(*) FROM Table2 where CreatedBy =@CreatedBy", con);
        cmd.Parameters.AddWithValue("@CreatedBy", createby.Text.Trim());
        label2.Text = Convert.ToString(cmd.ExecuteScalar());
        con.Close();
    }

I think I got the answer; I changed the code to this.

and its working fine

    private void displaycert()
    {
        int count = 0;
        SqlConnection con = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\\Dataregister.mdf;Integrated Security=True");
        con.Open();
        SqlCommand cmd = new SqlCommand("SELECT COUNT(*) FROM CertTbl where CreatedBy =@CreatedBy", con);
        cmd.Parameters.AddWithValue("@CreatedBy", createby.Text.Trim());
        count = Convert.ToInt32(cmd.ExecuteScalar());
        lblTotal.Text = count.ToString();
        con.Close();
    }
    private void displayinvoice()
    {
        int count = 0;
        SqlConnection con = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\\Dataregister.mdf;Integrated Security=True");
        con.Open();
        SqlCommand cmd = new SqlCommand("SELECT COUNT(*) FROM InvoiceTable where CreatedBy =@CreatedBy", con);
        cmd.Parameters.AddWithValue("@CreatedBy", createby.Text.Trim());
        count = Convert.ToInt32(cmd.ExecuteScalar());
        labelinv.Text = count.ToString();
        con.Close();
    }