Dataset question

Hi,

I have a question related to the datasets.

I am using XML data source.
I am having a dataset 'A' which is being used to create a joint data-set.
The data set 'A' may not have data always.
Is it possible to check if a dataset is empty, and if empty create a scripted data set with the same name - as it is being used to create a joint data-set.

Thanks,
Vash

Find more posts tagged with

Comments

bhanley

I am not sure what you are looking to do is possible. Programatically changing out the dataset with a secondary data set of a different type seems to me to be quite complex. What I would consider doing is creating two joint data sets; one with the XML and another using the scripted data source. You can then choose which one to use at run time based on whatever criteria you want.

vash

Thanks for your reply.
I will try doing that.

-Vash

johnw

Brians idea was what I was going to suggest. You can do it programatically, but it requires quite a bit of knowledge about the design engine API to do it.

Your best bet is to have the two joined data sets, and put a counter in the OnFetch method for your table in DataSetA. Then use a Visibility expression that if the counter is greater than 0, show table A. If counter is 0, show Table B with your scripted data source.