Best approach to check dataset has records

Question

I am keen to know the best approach to check if a dataset has records in it or not. I have been using the below code to check if a dataset has some records or not. But I feels there is some better/best approach available to achieve this.

Dataset tableData = New Dataset();
if (_tableData.Tables.Count > 0 && _tableData.Tables[0].Rows.Count > 0)
{ 
}

Please share some knowledge if I am feeling correct.

Thanks

Answer 1

This will return true if there are any rows in any of the tables. It will return false if there are no tables or no rows.

DataSet tableData; // ... instantiate DataSet
bool hasRows = tableData.Tables.Cast<DataTable>()
                               .Any(table => table.Rows.Count != 0);

Answer 2

If there are multiple tables in your DataSet then your logic won't work for some scenarios. This method is more complete:

bool HasRecords(DataSet dataSet)
{
    foreach (DataTable dt in dataSet.Tables) if (dt.Rows.Count > 0) return true;
    return false;
}