Data Connections

Re: SharepointListQueryConnection.SiteUrl

emdc2 — Sat, 28 Nov 2009 03:52:58 GMT

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.

Re: SharepointListQueryConnection.SiteUrl

Patrick Halstead — Sat, 28 Nov 2009 02:04:09 GMT

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).

Re: SharepointListQueryConnection.SiteUrl

emdc2 — Fri, 27 Nov 2009 18:16:29 GMT

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).

Re: SharepointListQueryConnection.SiteUrl

Qazi Anis — Wed, 18 Nov 2009 12:48:35 GMT

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

Re: SharepointListQueryConnection.SiteUrl

Dedek — Wed, 18 Nov 2009 12:18:14 GMT

hi, emdc2

did you find out any solution?

Re: SharepointListQueryConnection.SiteUrl

Shiva — Tue, 30 Jun 2009 18:32:51 GMT

Hello,

Check out this link,

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

SharepointListQueryConnection.SiteUrl

emdc2 — Tue, 30 Jun 2009 16:27:40 GMT

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.