Display Active Inactive user count in ASP.Net GridView using C# and VB.Net

Hi sagark,

Refer Below Sample.

SQL

CREATE TABLE Register(IsActive INT)
INSERT INTO Register VALUES(1)
INSERT INTO Register VALUES(0)
INSERT INTO Register VALUES(0)
INSERT INTO Register VALUES(1)
INSERT INTO Register VALUES(0)
INSERT INTO Register VALUES(0)

CREATE PROCEDURE TestRegister
AS
BEGIN
	SELECT (SELECT COUNT(IsActive) FROM Register WHERE IsActive=1) 'Active',
			(SELECT COUNT(IsActive) FROM Register WHERE IsActive=0)'InActive'
END

HTML

<asp:GridView ID="gvStatus" runat="server" AutoGenerateColumns="false">
    <Columns>
        <asp:BoundField DataField="Active" HeaderText="Active" />
        <asp:BoundField DataField="InActive" HeaderText="InActive" />
    </Columns>
</asp:GridView>

Namespace

C#

using System.Data;
using System.Data.SqlClient;
using System.Configuration;

VB.Net

Imports System.Data.SqlClient
Imports System.Data

Code

C#

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
        using (SqlConnection con = new SqlConnection(constr))
        {
            using (SqlCommand cmd = new SqlCommand("TestRegister", con))
            {
                cmd.CommandType = CommandType.StoredProcedure;
                using (SqlDataAdapter da = new SqlDataAdapter(cmd))
                {
                    DataTable dt = new DataTable();
                    da.Fill(dt);
                    this.gvStatus.DataSource = dt;
                    this.gvStatus.DataBind();
                }
            }
        }
    }
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    If Not Me.IsPostBack Then
        Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
        Using con As SqlConnection = New SqlConnection(constr)
            Using cmd As SqlCommand = New SqlCommand("TestRegister", con)
                cmd.CommandType = CommandType.StoredProcedure
                Using da As SqlDataAdapter = New SqlDataAdapter(cmd)
                    Dim dt As DataTable = New DataTable()
                    da.Fill(dt)
                    Me.gvStatus.DataSource = dt
                    Me.gvStatus.DataBind()
                End Using
            End Using
        End Using
    End If
End Sub

Screenshot