Dynamic change creat a retrieve connection

Jakster — Thu, 26 Aug 2010 10:19:24 GMT

Good day,

I am looking everywhere for a code solution to this problem.

I have a projects Portal where each project will create a new subsite from a template.
This template contains a few Infopath forms and some other stuff.
The problem is that some of the Infopath documents need to retrieve info from the top site (no issues as all subsites will connect correctly) and some need to connect to an Infopath library RELATIVE to the current site.

Example

Site Structure

Top Lvl
---Proj A (Template site including Form A and B)
---Proj B (Template site including Form A and B)

The Template site has connections in to the top level site and submits relative via code

Form A (in Porj A) - All connections are working as defined in Infopath to the top level site and submits "relative" to Proj A (via code)

Form B (In Proj B) - Few connections to top level lists and Form libraries BUT needs to connect to Form A relative (current connection is set top level in the site template)

So I need to in code change the connection to the relative path (seems to be impossible but the preferred solution)
OR
I need to create a relative UDC connection library in the template site (Should work but changes in the connections would require changing ALL Proj sites manually, looking at a lot of projects)
OR
using code to a webservice but getting the form library GUID to the relative subsite will be an issue (force me to code on the server when adding Sharepoint dll)

Any ideas or suggestions?

Code

Dynamic change creat a retrieve connection