getting rowcount

[=?Utf-8?B?c2VndWU=?=]

The below code doesn't give me the last record count.
Feedback very appreciated. Thanks for all that you do.

qstring = "SELECT COUNT(*) FROM CustomerInformation "

Dim newSql As New SqlConnection(connectionstr)
newSql.Open()
Dim catCMD As SqlCommand = newSql.CreateCommand()
catCMD.CommandText = qstring
Dim intRecordsAffected = catCMD.ExecuteNonQuery()
newSql.Close()

[Kelly Herald]

Change the ExecuteNonQuery to ExecuteScalar and casting it to an Int32.
"segue" <se***@discussions.microsoft.comwrote in message
news:1D**********************************@microsof t.com...

>
The below code doesn't give me the last record count.
Feedback very appreciated. Thanks for all that you do.

qstring = "SELECT COUNT(*) FROM CustomerInformation "

Dim newSql As New SqlConnection(connectionstr)
newSql.Open()
Dim catCMD As SqlCommand = newSql.CreateCommand()
catCMD.CommandText = qstring
Dim intRecordsAffected = catCMD.ExecuteNonQuery()
newSql.Close()

[=?Utf-8?B?c2VndWU=?=]

Thanks for the quick response.

I made the ExecuteScalar change and still didn't get the highest number.
My query stopped at 114,278, row 114,279 is empty yet 114,300 isn't.

"Kelly Herald" wrote:

Change the ExecuteNonQuery to ExecuteScalar and casting it to an Int32.
"segue" <se***@discussions.microsoft.comwrote in message
news:1D**********************************@microsof t.com...

The below code doesn't give me the last record count.
Feedback very appreciated. Thanks for all that you do.

qstring = "SELECT COUNT(*) FROM CustomerInformation "

Dim newSql As New SqlConnection(connectionstr)
newSql.Open()
Dim catCMD As SqlCommand = newSql.CreateCommand()
catCMD.CommandText = qstring
Dim intRecordsAffected = catCMD.ExecuteNonQuery()
newSql.Close()

[=?Utf-8?B?UGV0ZXIgQnJvbWJlcmcgW0MjIE1WUF0=?=]

There is a big difference between count(*) which returns a count of the
number of rows in the table, and MAX(ID) which returns the highest value
present in the ID column.
-- Peter
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
MetaFinder: http://www.blogmetafinder.com
"segue" wrote:

>
Thanks for the quick response.

I made the ExecuteScalar change and still didn't get the highest number.
My query stopped at 114,278, row 114,279 is empty yet 114,300 isn't.

"Kelly Herald" wrote:

Change the ExecuteNonQuery to ExecuteScalar and casting it to an Int32.
"segue" <se***@discussions.microsoft.comwrote in message
news:1D**********************************@microsof t.com...

>
The below code doesn't give me the last record count.
Feedback very appreciated. Thanks for all that you do.
>
qstring = "SELECT COUNT(*) FROM CustomerInformation "
>
Dim newSql As New SqlConnection(connectionstr)
newSql.Open()
Dim catCMD As SqlCommand = newSql.CreateCommand()
catCMD.CommandText = qstring
Dim intRecordsAffected = catCMD.ExecuteNonQuery()
newSql.Close()
>
>