Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 867434 - Last Review: September 22, 2011 - Revision: 4.0
BUG: 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.
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.
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:
- Start InfoPath.
- In the Data Connection Wizard, click Web service, and then click Next.
- Click Receive and submit data, and then click Next.
- 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.
- 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. - Click the Web service that you want to submit the data to, and then click Next.
- Click the Web service method that you want to submit data to, and then click Next.
- Map the parameters of the Web service method to the fields that InfoPath automatically generates from the Receive Web service method.
- Click Next. Click Finish.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
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
- Start InfoPath 2003 Service Pack 1.
- On the Fill Out a Form screen, click File, click Fill Out a Form, and then click Design a Form.
- Under Design a new form, click New from Data Connection.
- Click Web service, and then click Next.
- Click Submit data, and then click Next.
- Click a Web service with a method that takes a DataSet with the System.Data.DataSet object parameter, and then click Next.
- Click the Web service method that you want to submit the data to.
- Click Next. Click Finish.
- Open the form, fill out the required fields, and then submit the form.
- Verify that the data in the ADO.NET DataSet that resides on the server is not updated as you expect.
APPLIES TO
- Microsoft Office InfoPath 2007
| kbdev kbbug kbtshoot kbprb KB867434 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate