DataReader - How to check for no records returned?

[LindaH]

How can I determine whether or not the datareader returned any records?

 

[jfrost10]

Hey Linda,

I don't use a datareader much (usually datasets/datatables), but is it possible to check the datareaders.length to see how many items are returned, and then handle the datareader from there?

Jack

 

[ja2000]

great... i suggest everyone to use datareader if they just want to view the recordsets return... because datasets could drop your system performances very very amazing ^-^

this is how to know whether the datareader return any record

SqlDataReader objDataReader = blablabla;
if (objDataReader.Read() == false){
// it means no recordsets returned
}

hope this can be of help