Dynamically load secondary data source

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

emailmygroup@gmail.com - 07 Sep 2007 16:51 GMT

I have secondary data source xml file and I would like to load it when
necessary. For this, I have unchecked the checkbox "Automatically
retrieve data when form is open" at the time of creating data source.
Now how can I load this xml and use it? Is there any function which
will open the connection and load xml into
XDocument.DataObjects("SecondSource").DOM?

Thanks

Reply to this Message

Nick Dallett [MSFT] - 08 Sep 2007 18:54 GMT

>I have secondary data source xml file and I would like to load it when
> necessary. For this, I have unchecked the checkbox "Automatically
> retrieve data when form is open" at the time of creating data source.
> Now how can I load this xml and use it? Is there any function which
> will open the connection and load xml into
> XDocument.DataObjects("SecondSource").DOM?

There are several ways to do this:

1. Add a button to your form, and set its action to "Refresh". You can
choose to refresh one secondary data source or all of them
2. Add a rule whose action is "query using a data connection" - set the data
connection to SecondSource
3. Add code which calls the query (in script) or execute (in IP2007 managed
code) method on the data adapter.

-N

Reply to this Message