Dynamic Data Connections, Query Data Source

Charles the Red — Tue, 01 Nov 2011 17:44:10 GMT

Hello,

I had begun working on a project in InfoPath 2010. Our forms must pull data from libraries that are relative to their current location in the website. Therefore, I cannot hardcode the Connections. In 2010 this was a relatively straight forward process using SharePointListRWQueryConnection and editing the URL and listID, a la:

SharePointListRWQueryConnection sp = (SharePointListRWQueryConnection)this.DataConnections["String"];

sp.SiteURL = "msdn.microsoft.com";

sp.ListID = ID;

Howerver, in 2007 there is only a SharePointListQueryConnection. The SiteURL and subsequent fields are read only, which makes my method impossible to implement. Is there another way to accomplish my task? Note that I would very much prefer to use SharePoint Lists.