How do I tell if a dataset contains any records?

  • Thread starter Thread starter William Gower
  • Start date Start date
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.
__________________________________
 
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
 
Back
Top