Count number of rows in a table using C# and VB.Net in ASP.Net

Hi edaadura,

Refer the below sample code.

HTML

 <asp:Label ID="lblRows" runat="server" />

C#

protected void Page_Load(object sender, EventArgs e)
{
    string constring = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(constring))
    {
        using (SqlCommand cmd = new SqlCommand("SELECT COUNT(*) As Count FROM Customers", con))
        {
            cmd.CommandType = CommandType.Text;
            con.Open();
            object o = cmd.ExecuteScalar();
            if (o != null)
            {
                lblRows.Text = "Total No of Rows: " + o.ToString();
            }
            con.Close();
        }
    }
}

VB.Net

Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load
    Dim constring As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
    Using con As New SqlConnection(constring)
        Using cmd As New SqlCommand("SELECT COUNT(*) As Count FROM Customers", con)
            cmd.CommandType = CommandType.Text
            con.Open()
            Dim o As Object = cmd.ExecuteScalar()
            If o IsNot Nothing Then
                lblRows.Text = "Total No of Rows: " + o.ToString()
            End If
            con.Close()
        End Using
    End Using
End Sub

Output

Total No of Rows: 6