getting rowcount

[segue]

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]

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.

 

[Peter Bromberg [C# MVP]]

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]

Thanks again for the response. I tried below and get the intRecords = 100,000.

qstring = "SELECT MAX(CustomerID) FROM CustomerInformation "
' ORDER BY RowNumber"

Dim newSql As New SqlConnection(connectionstr)
newSql.Open()
Dim catCMD As SqlCommand = newSql.CreateCommand()
catCMD.CommandText = qstring
Dim intRecordsAffected As Int32 =
CType(catCMD.ExecuteScalar(), Int32)
intRecordsAffected = intRecordsAffected + 1
newSql.Close()