Server data is not updated as you expect when you submit an InfoPath form

You can design a form in Microsoft Office InfoPath 2007 or in Microsoft Office InfoPath 2003 that submits the data of the form to a Web service method. The Web service method has the System.Data.DataSet object as a parameter. When you fill out the form and then click Submit, the ADO.NET DataSet on the server is not updated as you expect.

This problem occurs although you receive a message that the form is submitted successfully.

CAUSE

This problem occurs if all the following conditions are true:

The InfoPath form is created from a Web service.
The InfoPath form is configured to only submit data to the Web service.
The Web service method uses the System.Data.DataSet object as a parameter.

WORKAROUND

To work around this problem, configure the form data connection to send data and to receive data when you design the form. To do this, follow these steps:

1. Start InfoPath.
2. In the Data Connection Wizard, click Web service, and then click Next.
3. Click Receive and submit data, and then click Next.
4. Click a Web service with a method that returns a DataSet with the same schema as the DataSet that you want to submit, and then click Next.
5. Click the Web service that you want to receive the data from, and then click Next.Note You do not have to actually receive data from the Web service. This option changes the way that InfoPath serializes data. This is described in the “More Information” section.
6. Click the Web service that you want to submit the data to, and then click Next.
7. Click the Web service method that you want to submit data to, and then click Next.
8. Map the parameters of the Web service method to the fields that InfoPath automatically generates from the Receive Web service method.
9. Click Next. Click Finish.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the “Applies to” section.

MORE INFORMATION

When a form is configured to only submit data to a Web service, the data is serialized as XML. Because the data is not serialized as an ADO.NET DataSet, the data is not updated as you expect.

Steps to reproduce the problem

1. Start InfoPath 2003 Service Pack 1.
2. On the Fill Out a Form screen, click File, click Fill Out a Form, and then click Design a Form.
3. Under Design a new form, click New from Data Connection.
4. Click Web service, and then click Next.
5. Click Submit data, and then click Next.
6. Click a Web service with a method that takes a DataSet with the System.Data.DataSet object parameter, and then click Next.
7. Click the Web service method that you want to submit the data to.
8. Click Next. Click Finish.
9. Open the form, fill out the required fields, and then submit the form.
10. Verify that the data in the ADO.NET DataSet that resides on the server is not updated as you expect.

——————————————–

Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
Microsoft Corporation. All rights reserved. Terms of Use | Trademarks

 


You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

AddThis Social Bookmark Button

Leave a Reply

*
To prove that you're not a bot, enter this code
Anti-Spam Image