Microsoft Knowledge Base Email Alertz

(867434) - Explains why a DataSet is not updated as you expect when you submit a filled-out form in InfoPath 2003. This problem occurs when the form is created from a Web service and is configured to only submit data. A workaround is provided.

Search KbAlertz

Advanced Search

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.

Click here to create a
FREE account
Already have an account?
[Click here to Login]











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

On This Page

SYMPTOMS

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.

APPLIES TO
  • Microsoft Office InfoPath 2007
Keywords: 
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