Checking for Empty Dataset -- Simple Question

[Ron]

Can anyone tell me how to check and see if a dataset is empty?

I am writing a search function that returns a dataset and binds it to a
datagrid. If no data is found, I would like to make the grid invisible and
have a label appear stating that no data was found.

Any suggestions?

Thanks,

Ron Rodenberg

 

[Steve C. Orr, MCSD]

If MyDataSet.Tables.Count = 0 Then 'it's empty

 

[Ron]

Thanks a lot Gaston, I appreciate your help.

Hi Ron, to check an empty DataSet you must verify the Rows
of the DataTable object that contains the database query
result.

For example:
DataSet ds = new DataSet( "MyTable" );
...
if( ds.Tables[ "MyTable" ].Rows.Count == 0 )
// No records
else
// Do something...

Regards
Gaston Quirque
Microsoft MVP

-----Original Message-----
Can anyone tell me how to check and see if a dataset is empty?

I am writing a search function that returns a dataset and binds it to a
datagrid. If no data is found, I would like to make the grid invisible and
have a label appear stating that no data was found.

Any suggestions?

Thanks,

Ron Rodenberg


.