Can I get the number of records in a DataReader?

[qwert231]

I would like to do this before I start reading the records. The RecordsAffected property is not set until all rows are read and you close the OleDbDataReader.

So, what can I do? Is there a way to do it?

 

[Alcar]

The datareader has a property called RecordsAffected.
That is equal of the row count in a select sql statement.

hth Daren J. Lahey
Just another computer guy...

 

[qwert231]

I would like to do this before I start reading the records.

The RecordsAffected property is not set until all rows are read and you close the OleDbDataReader.

So, what can I do? Is there a way to do it?

 

[Alcar]

Before you execute the command to the DataReader, you can have this code:

int iRecordsAffected;
iRecordsAffected = command1.ExecuteNonQuery();

will give you the number of rows of a select sql statement


Daren J. Lahey
Just another computer guy...

 

[Zarcom]

Not that I know of. I think this has to do with the fact that the reader to my knowledge doesn't get anything till the .read command. At which point it retrieves the data in a stream like format. This is what I have gotten out of the documentation anyway. That'l do donkey, that'l do
Mark