Dynamically load secondary data source

[emailmygroup]

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

 

[Nick Dallett [MSFT]]

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