Code

Re: SecondaryDataSource - How to access ?

ccarns — Tue, 14 Jul 2009 18:48:48 GMT

Be forwarned that this technique does not work on a web enabled form. So if your end goal is to have people fill it out who do not have infopath then you will need to use a workaround.

Re: SecondaryDataSource - How to access ?

The_Holy_One — Tue, 14 Jul 2009 11:56:24 GMT

Thanks a lot Jimmy, works perfect, fast and was really easy to implement in the current form.

Its good to know that there is a place where you can get answers around InfoPath if there are Problems/Questions.

Re: SecondaryDataSource - How to access ?

Jimmy — Tue, 14 Jul 2009 11:14:15 GMT

Hello again,

It looks like you can accomplish what you want to do with some code like the following:

            FileQueryConnection q = DataSources["dataSourceName"].QueryConnection as FileQueryConnection;
            q.FileLocation = "address to XML file";
            q.Execute();

Then that data source should have the contents of the XML file you indicated. You still have to do this on an existing data connection (that is, you can't create a new one at runtime, but you can switch out the XML file).

Re: SecondaryDataSource - How to access ?

The_Holy_One — Tue, 14 Jul 2009 08:57:38 GMT

Hi danirrivas,

thanks also for your answer, but i have still one question which confuse me a lot. You are selecting within your SecondaryDataConnection a Field with the XPATH:

("/dfs:myFields/dfs:queryFields/ns1:GetItem/ns1:WhereCondition",)

sure, this is only a example... but in my own SecondaryDataConnection i dont have any field which would fit a "where" condition , or even the String i must enter into InfoPath for the XML. So this wont work, or is there a way to "always" set a Where Field in every XML Query? i will keep searching, and try to find a possible way to modifiy the xml shema that there will be a working "where" condition. Maybe there is one.

My Current XML Recieving DataConnection is: http://servername/sites/germansite/Docs/_vti_bin/owssvr.dll?Cmd=Display&List={LISTID}&View={VIEWID}&XMLDATA=TRUE&FilterField1=InternalFieldName&FilterValue1=FieldValueToFilter

If possible i would edit this string in real time, but good to know that there is also a way to work directly in the XML DataSource.

Re: SecondaryDataSource - How to access ?

danirrivas — Mon, 13 Jul 2009 12:32:56 GMT

You can refresh a secondary data connection from code using the command Execute, something like this:

XPathNavigator documentWhere = this.DataSources["yourSecondaryDataSource"].CreateNavigator();

XPathNavigator fieldWhere = documentWhere.SelectSingleNode("/dfs:myFields/dfs:queryFields/ns1:GetItem/ns1:WhereCondition", this.NamespaceManager);

fieldWhere.SetValue("Here goes the query");

this.DataSources["yourSecondaryDataSource"].QueryConnection.Execute();

Hope it helps :-)

Re: SecondaryDataSource - How to access ?

The_Holy_One — Mon, 13 Jul 2009 08:34:37 GMT

Thanks for your fast answer, about the second question.

I think about if there is a way to create in real time (while the InfoPath form is open) new Secondary Connection, or even better, refresh a existing one. (XML retrieving DataSource, - only the URL had to be refreshed).

Re: SecondaryDataSource - How to access ?

Jimmy — Mon, 13 Jul 2009 08:25:16 GMT

You can access the secondary data sources by using the DataSources collection, like this:

DataSources["nameOfSource"]

So if I wanted to create an XPathNavigator to a data source called Weevils, I would use:

DataSources["Weevils"].CreateNavigator()

I'm not sure what to say for your second question. I don't fully understand it and I have a feeling that there may not be a way to do what you want.

SecondaryDataSource - How to access ?

The_Holy_One — Mon, 13 Jul 2009 08:12:05 GMT

Well, i know how to access within my 'CodeBehind' to the MainDataSources of the InfoPath Formular...

MainDataSource. xyz ...

But how to access the SecondaryDataSources ?

SecondaryDataSource as Class or Object doesnt exist.

And if i am already bother you with my question, i would be pleased if someone could explain to me how to create a SecondaryDataSource with CodeBehind. For example, you push a Button and a XML File will be connected which will perform as DataSource. The Fields wont change, only the Data itself.