how to know the number of records in a table?

[Matthew Louden]

I want to count the number of records in a table, and insert a new record
with ID increment the count by 1.

Heres the code:
sqlStmt = "SELECT COUNT(*) As numRecords FROM TimeSlot;"
cmd = New SqlCommand(sqlS tmt, conn)
dr = cmd.ExecuteRead er

But how to get the value of numRecords? since numRecords is not a field in
table TimeSlot

please help!

[Marina]

You can't until u've read through all of them. The datareader is a forward
only read-only quick way to look at data.

If you need to know the number up front, use a dataset or datatable.

"Matthew Louden" <ma*******@hotm ail.com> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. ..

I want to count the number of records in a table, and insert a new record
with ID increment the count by 1.

Heres the code:
sqlStmt = "SELECT COUNT(*) As numRecords FROM TimeSlot;"
cmd = New SqlCommand(sqlS tmt, conn)
dr = cmd.ExecuteRead er

But how to get the value of numRecords? since numRecords is not a field in
table TimeSlot

please help!

[RA]

This won't work for multiple database connections. The incremeted count
might give you false information. I assume that the ID is unique value? If
yes then change it in the database to be an identity field. If you do that
let me know and I will help you on how to get the new row inserted.

Ronen

"Matthew Louden" <ma*******@hotm ail.com> wrote in message
news:#X******** ******@tk2msftn gp13.phx.gbl...

I want to count the number of records in a table, and insert a new record
with ID increment the count by 1.

Heres the code:
sqlStmt = "SELECT COUNT(*) As numRecords FROM TimeSlot;"
cmd = New SqlCommand(sqlS tmt, conn)
dr = cmd.ExecuteRead er

But how to get the value of numRecords? since numRecords is not a field in
table TimeSlot

please help!