InfoPath Dev

I have created an InfoPath 2010 web form that uses a Web Service to submit values to a SQL database. What is the best way to incorporate the Web Service into the InfoPath form so that the form can be uploaded to SharePoint?

Hi DBaker,

I would convert the form to a Universal Data Connection and then your form will work in the browser.

The Web service itself will have to be installed on one of the IIS servers in your domain and it will have to be set up to access your SQL database.

Good luck!

Hi Patrick,

Thank you for your reply. I've converted all of my data connections to Universal Data Connections. I also have the Web Service up and running. The form works fine in InfoPath. I can upload it to SharePoint as an administrator approved form template. However, the form won't load if I try to open it through SharePoint. I keep getting the following error:

Type: ArgumentException, Exception Message: Item has already been added. Key in dictionary: 'siteid' Key being added: 'siteid')

Any ideas what this error means?

Thank you,

db

 Oh - you are right, in VSTA you can't seem to do this. Yuck. I guess I'd try manually modifying the .proj file and reloading it....maybe see if you can add the TargetFrameworkVersion to the PropertyGroup?

I probably didn't do a very good job of explaining the problem I was having.

In any case, I was able to resolve it by doing two things:

1. I reviewed all of my data connections in InfoPath until I found the one that was returning two fields with the same name of 'siteid.' I had included a table's primary key, siteid, in my SQL select statement. However, it appears that InfoPath likes to include primary keys in select statements automatically, which is what caused the error. I removed the 'siteid' field from the SQL select statement that I had manually included and just used InfoPath's automatic primary key.

2. I followed S.Y.M. Wong-A-Ton's recipe #85 from Cookbook #3 for using the Execute() method of the WebServiceConnection class. This book is the most useful resource I have found on developing InfoPath forms anywhere--online or in print.

Thanks,

db