InfoPath Dev

I'm currently working on a large InfoPath project and need to write code to programatically modify receive data connections. I have successfully modified the FileQueryConnection.FileLocation but the SharepointListQueryConnection.SiteUrl is set to read-only. Very frustrating.

 Does anyone know a way around this? Or, is there a way to programmatically create the entire SharepointListQueryConnection on the fly in code?

 Thanks.

Hello,

Check out this link,

http://office.microsoft.com/en-us/sharepointdesigner/HA101174371033.aspx#4

hi, emdc2

did you find out any solution?

hi emdc2,

why dont you just use sharepoint object model to retrieve data, instead of creating data connections through UI, create them in code using object model.

NOTE: they will work only for browser enabled forms

We did not find a solution to this. We hope Microsoft modifies this in the next version.

We could not use the Sharepoint object model to retrieve the data because the forms are Infopath client forms - not browser enabled (the forms must work in a disconnected state).

You can use UDC files in the rich client. UDC files normally have to be stored on SharePoint site, but I believe that you can work around that limitation. Or, if you have SharePoint, just convert the data connections to UDC files. The UDC file format is XML and you could use that schema to build an InfoPath form which you submit to the library (programmatically, updating the UDC to point to a new site).

You are correct. You can use UDC Connections with the rich client. As a matter of fact, we are currently using them in our solution. The problem with UDC connections is that they take a while to load and if you have a bunch of different connection the user has to wait for each one to load. We were trying to find a way around this performance issue.