how to get number of rows returned by a SqlDataReader?

[Juan]

how to get number of rows returned by a SqlDataReader without having to
scroll it?

 

[Lateralus [MCAD]]

Juan,
I don't think you can. If you want that type of information you'll have
to use a DataSet instead. The performance of a SqlDataReader is better, but
if you need that type of information before you loop through the results, I
think you'll have to use a DataSet.

HTH

 

[Juan]

Thanks, needed a confirmation...

Juan,
I don't think you can. If you want that type of information you'll have
to use a DataSet instead. The performance of a SqlDataReader is better, but
if you need that type of information before you loop through the results, I
think you'll have to use a DataSet.

HTH

--
Lateralus [MCAD]

how to get number of rows returned by a SqlDataReader without having to
scroll it?

 

[morgal]

Well, even the recordset doesn't know how many rows it
has in it until it reads the entire set, you just get a '-
1' returned until you go to the end of the dataset
forcing the entire dataset to be read.