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

--
Lateralus [MCAD]
"Juan" <ju*****************@ANTISPAMhotmail.com> wrote in message
news:u1**************@TK2MSFTNGP10.phx.gbl...

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

[Juan]

Thanks, needed a confirmation...

"Lateralus [MCAD]" <dnorm252_at_yahoo.com> escribió en el mensaje
news:ud**************@TK2MSFTNGP11.phx.gbl...

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]
"Juan" <ju*****************@ANTISPAMhotmail.com> wrote in message
news:u1**************@TK2MSFTNGP10.phx.gbl...

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.

-----Original Message-----
how to get number of rows returned by a SqlDataReader without having toscroll it?