h1

Count records using ExecuteScalar in ASP.NET

April 15, 2008

After much research, it was incredibly annoying to try and find a decent script on how to count records from a database using ASP.NET (via VB). I gathered from different resources and wrote a simple script to get the job done. I decided to post it in case anyone is going through the same headache I just went through.

You can put this in a function and return the record count easily. The following is a simple example of how to count records using ExcuteScalar in ASP.NET.

Dim SQLString As String = “SELECT Count(columnName) FROM tableName
Dim
yourDBConnection As New SqlConnection()
yourDBConnection.ConnectionString = yourConnectionString

Dim
cmd As New SqlCommand()
Dim recCount As Integer

yourDBConnection.Open()

cmd.Connection = yourDBConnection
cmd.CommandText = SQLString
recCount = Integer.Parse(cmd.ExecuteScalar().ToString)

yourDBConnection.Close()

‘Return recCount

Happy programming!

6 comments

  1. Thx ..was a real help.:)


  2. I also had a real headache trying to figure this out. There’s another easy way of doing it at http://www.dinowebs.net/?p=42

    This uses the Data Source control’s Data.DataView property.


  3. Thanks! You just help me achieve what I wanted.


  4. THIS COMMAND HELPED ME VERY LOT……THANKS….
    jose


  5. Thanks a lot……………..


  6. tnx very much no more heartache



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.