Finding the number of records (count) of a recordset

microsoft.public.dotnet.languages.vb

17 Aug 2006 8:16 PM

reidarT

Dim con2 As New SqlClient.SqlConnection("Data Source=RE....
Dim Tall as Integer
Dim cmdCount As New SqlClient.SqlCommand( _
            "SELECT Count(tblToDo.ToDoID) AS AntallMeldinger " & _
            "FROM tblToDo WHERE Bruker = '" & Bruker & "'", con2)
        con2.Open()
        cmdCount.ExecuteNonQuery()
        con2.Close()

How do I get get Tall to be the AntallMeldinger ?

reidarT

17 Aug 2006 10:06 PM

Kerry Moorman

reidarT,

I think you can use ExecuteScalar instead of ExecuteNonQuery:

Tall = cmdCount.ExecuteScalar()

Kerry Moorman

Show quoteHide quote

"reidarT" wrote:

> Dim con2 As New SqlClient.SqlConnection("Data Source=RE....
> Dim Tall as Integer
> Dim cmdCount As New SqlClient.SqlCommand( _
>             "SELECT Count(tblToDo.ToDoID) AS AntallMeldinger " & _
>             "FROM tblToDo WHERE Bruker = '" & Bruker & "'", con2)
>         con2.Open()
>         cmdCount.ExecuteNonQuery()
>         con2.Close()
>
> How do I get get Tall to be the AntallMeldinger ?
>
> reidarT
>
>
>