OleDbDataReader-Count Property

[TekMem]

I am using OleDbDataReader to access the data and I have following codes to count number of records.

Opendb()
Do While (myReader.Read())
Counter += 1
Loop
closedb()
These steps slows down the process.
I have to use this count somewhere else with opendb function. Is there a count property or some other suggestion? so that I can count number of records or rows.

Thanks in advance.

 

[SHelton]

Use Command.ExecuteScalar to run a SELECT COUNT(*) query rather than looping through a data reader.

 

[TekMem]

Thanks a Lot SHelton! It rocks!

 

[TekMem]

In the above codes While myreader counts the counter is shown in a label in the form...but some how the counter is shown only when the process is finished.
Need a clue?
Thanks.

 

[chrissie1]

not that I would recommend this but add an application.doevents in the loop or me.refresh.

Christiaan Baes
Belgium

I just like this --> [Wiggle] [Wiggle]

 

[TekMem]

Thanks!

 

[PRPhx]

You can also you the count member of the CurrencyManager. Don't know if it would be any faster than an SQL Count(*) query or not. Also with the CurrencyManager, you can obtain the current record's position, etc.

 

[SHelton]

PRPhx, I don't think you can use CurrencyManager - a DataReader is read-only, forward-only and doesn't implement any of the interfaces required by the CurrencyManager (Ilist, IListSource and IBindingList).

CurrencyManager is usually used with DataSet, DataTable or DataView.