I want to know how many rows I get with this query : 

```
Using ConLoad As SqlConnection = New SqlConnection(constring)
     Dim Query As String = "SELECT @@ROWCOUNT AS ROWnum, *  FROM Specifications")

     ConLoad.Open()
     Using cmd As SqlCommand = New SqlCommand(Query, ConLoad)
         Response.Write(cmd.ExecuteScalar)
     End Using
End Using

```

This query executed in SQL Server Management Studio returns 38, but in my webform it's returning 0.

I improve to launch it twice:

```
Using ConLoad As SqlConnection = New SqlConnection(constring)
    Dim Query As String = "SELECT @@ROWCOUNT AS ROWnum, *  FROM Specifications")

    ConLoad.Open()
    Using cmd As SqlCommand = New SqlCommand(Query, ConLoad)
        Response.Write(cmd.ExecuteScalar)
    End Using
    Using cmd2 As SqlCommand = New SqlCommand(Query, ConLoad)
        Response.Write(cmd2.ExecuteScalar)
    End Using
End Using

```

And the result on `cmd2.ExecuteScalar` is 38.

How I have to do to have the good result at the first time?