SqlDataReader RowCount?

[Johnny Jörgensen]

Is there any way of finding out how many rows that are returned in an
System.Data.SqlClient.DataReader by a SELECT clause BEFORE you start reading
the data?

The SqlDataReader object doesn't seem to have any properties that tell that
like Rows.Count etc...

The RowsAffected property always returns -1 when it's a SELECT clause. It
only works with UPDATE, INSERT and DELETE.

Cheers,
Johnny J.

 

[Guest]

You can have 2 select statements in your SQL or stored proc. The first one
will return the count, and the second one will return the actual rows of data.
Then you can use the NextResultset method on the reader after getting the
count, to get the actual data.
-- Peter
Recursion: see Recursion
site: http://www.eggheadcafe.com
unBlog: http://petesbloggerama.blogspot.com
BlogMetaFinder: http://www.blogmetafinder.com

 

[Johnny Jörgensen]

Have you got a small code sample?

Cheers,
Johnny J.

 

[fred.simons]

It is something like this:

int rcds=0;

sqlcmd.CommandText="Select count(*) from myfavoritetable where
recdid='Active'";
rcds = sqlcmd.ExecuteScalar();

if(rcds>0)
{
sqlcmd.CommandText="Select Info1, Infor2, Info3 from myfavoritetable
where recdid='Active'";
myrdr = sqlcmd.ExecuteDataReader();
while(myrdr.Read())
{
//Reads and process records
}
}
else
{
errmsg = "No Records Found.";
}