Determine if Tables[0] Exists

Question

While executing the following statement to bind my database to my datagridview, I get this error:

Cannot find table 0.

How can I determine if Tables[0] exists prior to executing this statement? :

myDataView = myDataSet.Tables[0].DefaultView;

I am using SQL Server 2005 Express.

Answer 1

Try the following

if (myDataSet.Tables.Count > 0 ) { 
  ...
}

Answer 2

Try this:

if (myDataSet.Tables != null && myDataSet.Tables.Count > 0)
{
   // do stuff
}

Answer 3

Does the DataSet have more than one table? If not, then you should be able to just check if the DataSet itself is null. This is generally the syntax that I'll do...

DataSet ds = BLL.GetMyDataSet();

if (ds != null && ds.Tables[0].Rows.Count > 0) {
  // TODO
}