How to test if a DataSet is empty?
I'm modifying someone else's code where a query is performed using the following:
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(sqlString, sqlConn);
da.Fill(ds);
How can I tell if the DataSet is empty (i.e. no results were returned)?
If I understand correctly, this should work for you
if (ds.Tables[0].Rows.Count == 0)
{
//
}
You don't have to test the dataset.
The Fill()
method returns the # of rows added.
See DbDataAdapter.Fill Method (DataSet)