How to test if a DataSet is empty

Question

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

User · Accepted Answer

If I understand correctly  this should work for you  if  ds Tables 0  Rows Count    0

User · Answer

To check dataset is empty or not You have to check null and tables count   DataSet ds   new DataSet    SqlDataAdapter da   new SqlDataAdapter sqlString  sqlConn   da Fill ds   if ds    null  amp  amp  ds Tables Count  gt  0        your code

User · Answer

When returning results from SQL query I find that tables 0  exists  but it has zero rows  So in my situation this worked   if  ds Tables 0  Rows Count    0    empty  This did not work   if  ds Tables Count    0

User · Answer

This should work  DataSet ds   new DataSet    SqlDataAdapter da   new SqlDataAdapter sqlString  sqlConn   da Fill ds    if ds Tables Count  gt  0         enter code here

User · Answer

MySqlDataAdapter adap   new MySqlDataAdapter cmd    DataSet ds   new DataSet     adap Fill ds    if  ds Tables 0  Rows Count    0           MessageBox Show  No result found         query will receive the data in data set and then we will check the data set that is it empty or have some data in it  for that we do      ds tables 0  Rows Count    o  this will count the number of rows that are in data set  If the above condition is true then the data set ie ds is empty

User · Answer

You don t have to test the dataset     The Fill   method returns the   of rows added     See DbDataAdapter Fill Method  DataSet

User · Answer

Don t forget to set table name     da Fill ds  tablename     So you return data using table name instead of 0   if  ds Tables  tablename   Rows Count    0       MessageBox Show  No result found

User · Answer

This code will show an error like  Table 0  can not be found  because there will not be any table in position 0   if  ds Tables 0  Rows Count    0

User · Answer

You should loop through all tables and test if table Rows Count is 0  bool IsEmpty DataSet dataSet        foreach DataTable table in dataSet Tables          if  table Rows Count    0  return false       return true      Update  Since a DataTable could contain deleted rows RowState   Deleted  depending on what you want to achive  it could be a good idea to check the DefaultView instead  which does not contain deleted rows    bool IsEmpty DataSet dataSet        return  dataSet Tables Cast lt DataTable gt    Any x   gt  x DefaultView Count  gt  0

User · Answer

We can check total three ways    if ds    null  if ds Tables Count  gt  0   if ds Tables 0  Rows Count  gt  0

User · Answer

It is not a valid answer as it gives following error     Cannot find table 0    Use the following statement instead  if  ds Tables Count    0           DataSet is empty

User · Answer

If  ds    null    Should do the work for you

User · Answer

Fill is command always return how many records inserted into dataset    DataSet ds   new DataSet    SqlDataAdapter da   new SqlDataAdapter sqlString  sqlConn   var count   da Fill ds   if count  gt  0       Console Write  It is not Empty

[c#] How to test if a DataSet is empty?

Examples related to c#

Examples related to ado.net

Examples related to dataset