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
[url]http://Steve.Orr.net[/url]



"Ron" <ron@razorvision.net> wrote in message
news:bekevp$1i5@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" <gastonq_nospam@yahoo.com.ar> wrote in message
news:04ba01c3471c$dca7d9b0$a101280a@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
> >
> >
> >.
> >