How do I tell if a dataset contains any records?

[William Gower]

I used to be able to do

if rs.EOF and rs.EOF then
do something
end if

 

[William \(Bill\) Vaughn]

Check
myDataSet.Tables("TheTableInQuestion").Rows > 0 :: there are rows
otherwise, EOF.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

 

[William Ryan eMVP]

With a DataReader under the 1.1 framework you can check the .HasRows
property. For a DataSet. use DataSet.Tables[0].Rows.Count //where 0 is the
index of the table in question