Display user details in GridView with total count in DashBoard Label using C# in ASP.Net

sid02 says:

Registered User:-

Refer the below sample code for your reference and impliment as per your code logic. created one class file to use to pupulate the dashboard details.

Dashboard.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

public class Dashboard
{
    public int Totalusers;
    public int Pendingquery;
    public int Repliedquery;
}

HTML

<asp:Label ID="lblQueryReplied" runat="server"></asp:Label>&nbsp;<asp:Label ID="lblPendingQuery"
    runat="server"></asp:Label>&nbsp;<asp:Label ID="lblRegisteredUser" runat="server"></asp:Label>
<asp:GridView ID="gvUserDetails" runat="server" AutoGenerateColumns="false">
    <Columns>
        <asp:TemplateField HeaderText="User Id">
            <ItemTemplate>
                <asp:Label ID="lblUserId" runat="server" Text='<%#Eval("Id") %>'> </asp:Label>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="User Name">
            <ItemTemplate>
                <asp:Label ID="lblUserName" runat="server" Text='<%#Eval("Name") %>'></asp:Label>
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>

CS

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        this.PopulateUserDetails();
        this.PopulateDasboardDetails();
    }
}

private void PopulateUserDetails()
{
    /* Call your User Bind code here*/
    DataTable dt = new DataTable();
    dt.Columns.AddRange(new DataColumn[2]{ new DataColumn("Id", typeof(int)),
                                                new DataColumn("Name", typeof(string))});
    dt.Rows.Add(1, "User 1");
    dt.Rows.Add(2, "User 2");
    dt.Rows.Add(3, "User 3");
    dt.Rows.Add(4, "User 4");
    dt.Rows.Add(5, "User 5");
    dt.Rows.Add(6, "User 6");
    dt.Rows.Add(7, "User 7");
    dt.Rows.Add(8, "User 8");
    dt.Rows.Add(9, "User 9");
    dt.Rows.Add(10, "User 10");
    dt.Rows.Add(11, "User 11");
    dt.Rows.Add(12, "User 12");
    dt.Rows.Add(13, "User 13");
    dt.Rows.Add(14, "User 14");
    dt.Rows.Add(15, "User 15");

    this.gvUserDetails.DataSource = dt;
    this.gvUserDetails.DataBind();
}

private void PopulateDasboardDetails()
{
    Dashboard dashboard = PopulateDasboard();
    this.lblRegisteredUser.Text = string.Format("Query replied:-{0}", dashboard.Repliedquery);
    this.lblPendingQuery.Text = string.Format("Pending query:-{0}", dashboard.Pendingquery);
    this.lblQueryReplied.Text = string.Format("Registered User:-{0}", dashboard.Totalusers);
}

private Dashboard PopulateDasboard()
{
    string constring = ConfigurationManager.ConnectionStrings["ConStr"].ConnectionString;
    Dashboard dashboard = new Dashboard();

    using (SqlConnection con = new SqlConnection(constring))
    {
        using (SqlCommand cmd = new SqlCommand("pDashboard", con))
        {
            cmd.CommandType = CommandType.StoredProcedure;
            con.Open();
            using (SqlDataReader sdr = cmd.ExecuteReader())
            {
                sdr.Read();
                dashboard.Totalusers = Convert.ToInt32(sdr["Totalusers"]);
                dashboard.Pendingquery = Convert.ToInt32(sdr["Pendingquery"]);
                dashboard.Repliedquery = Convert.ToInt32(sdr["Repliedquery"]);
            }
        }
    }
    return dashboard;
}

OUTPUT

Registered User:-15 Pending query:-3 Query replied:-7