Number of Rows?

[Richard Funaki]

Hello,

I've been searching around for some time now for something that seems like a simple request, but I can't come across a solution. I am trying to get the number of returned rows from a DataReader object without using an aggregate like "COUNT()" and then running the Scaler query to return the value. Is there a simple way of doing this with Connector/NET? For those familiar with PHP, something similar to the mysql_num_rows() function. I see the DataReader has a RecordsAffected member, but it does not return the number of read rows, nor do I understand why this member is on the DataReader class as it is a forward only reader that isn't necessarily used for updating,deleting, etc.

Any help would be greatly appreciated.

Thanks,
- Rick F