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

--
I hope this helps,
Steve C. Orr, MCSD
http://Steve.Orr.net

"Ron" <ro*@razorvision.net> wrote in message
news:be********@library1.airnews.net...

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

[Ron]

Thanks a lot Gaston, I appreciate your help.
"GastonQ" <ga************@yahoo.com.ar> wrote in message
news:04****************************@phx.gbl...

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
.