How Do I Get A RecordCount

[Silv3rSurf3r_20]

Hey All,

 

I have a quick question... how do i get a count of how many records are selected when i execute a SELECT query...

like when it was in ADO with the use of .recordcount

 

How do i do this in ADO.net

 

Thanks

~John~

[wyrd]

Doesn't the xxxDataReader class have a Count property? If not then doing an xxxCommand.ExecuteScalar on SELECT COUNT(*) FROM table is the only thing I can think of.

[Mehyar]

The datareader doesnot have a count property.

 

What you can do is that use a dataadapter and fill the results in a table by using the Fill method, and then count the rows of that table.

 

'sample code

Dim da as new dataadapter("Select ....","Connection string")

dim dt as new datatable()

da.fill(dt)

dim recordcount as integer = dt.rows.count

Hope this helps...

[ashrobo]

While MyReader.Read
   Count += 1
End While
Msgbox(Count)

i am using the abovementioned code..

 

-ashrobo

[wyrd]

Ah, DataTable. I knew there was something that had the Count property.

[quwiltw]

ashrobo, if that's all you're doing with the data is looping through to count it you'd likely do well by taking wyrd's recommendation and letting the db do the count for you.