The IListSource does not contain any data sources. <-- ?

[KK]

Hi

When I execute an SQL steatement, I retreive a
Dataset. For some queries which does not
return any data, If I assign it to the
datagrid.datasource and bind, it throws the following
exception

>The IListSource does not contain any data sources.

However, dataset doesn't say its NULL. So that Ican
check for null and if its null, I don't bind it to grid.

Jist, as to test, I did a

>System.Diagnostics.Debug.WriteLine(results.GetXml ());

and if there are no data it just outputs a "<NewDataSet />"
which says no data. Everytime, when this happens if I
assign to grid it throws the above exception.

There should be a nice way to check this isn't it?

How can I avoid this error?
rgds
KK

[Srimathi]

Hi,

I think you can check for the tables count and if the tables
(Dataset.Tables.Count) count is greater than 0, then you can bind it to the
datagrid.

Srimathi.

"KK" wrote:

> Hi
>
> When I execute an SQL steatement, I retreive a
> Dataset. For some queries which does not
> return any data, If I assign it to the
> datagrid.datasource and bind, it throws the following
> exception
>

> >The IListSource does not contain any data sources.

>
> However, dataset doesn't say its NULL. So that Ican
> check for null and if its null, I don't bind it to grid.
>
> Jist, as to test, I did a
>

> >System.Diagnostics.Debug.WriteLine(results.GetXml ());

> and if there are no data it just outputs a "<NewDataSet />"
> which says no data. Everytime, when this happens if I
> assign to grid it throws the above exception.
>
> There should be a nice way to check this isn't it?
>
> How can I avoid this error?
> rgds
> KK
>
>
>