Infopath Submit Dataset containing multiple tables to Web Service

Posted on 2009-12-18
Last Modified: 2012-05-08
I am using a web service to query/update SQL tables from InfoPath.  I put multiple tables in my dataset, and they show up correctly in Infopath.  When I change data in InfoPath, and do Submit, it sends back the DataSet. How does my UpdateCommand function know what info changed? For example, which table.
I had this working correctly when my dataset contained only one table, because the Primary Key was set to point to the modified row.  But how does it work now that I have a dataset with mulitple tables.
Thank you!
Question by:FingPhoto

    Author Comment

    Let me know if this question is not clear.
    LVL 28

    Accepted Solution

    With a primary table and child tables, you must have foreign key relationships to keep the relationships in sync.
    To your more basic question a typical update just resubmits everything, some being changes, other data being identical or unchanged.

    Are you actually having a problem or just want to know?

    Author Comment

    I eventually got this to work.
    I'm new to this and didn't know how the SQLAdapters, tablemapping, etc work, but I've got it figured out now.  I was trying to force a single SQLDataAdapter to work with more than 1 table.
    I also didn't know that when a InfoPath submits a Dataset back to the web service that that Dataset only contains items that need to change. Is that correct?

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    These instructions are based on installing Owncloud on your new raspberry pi connected with a usb HDD. What do you need Part A? A Raspberry Pi, model B. A boot SD card for the Raspberry Pi. A usb HDD An Ethernet cable to connect to the lo…
    New Relic recently released its Synthetics product that allows for the creation of performance monitors that periodically test a site's performance. If you wish to test an interactive workflow New Relic employs Selenium WebDriverJS to run those test…
    The purpose of this video is to demonstrate how to set up the WordPress backend so that each page automatically generates a Mailchimp signup form in the sidebar. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome…
    This video is a brief demonstration on how to use security groups and Network Access Control Lists (ACLs) in Amazon Web Services.  Security groups and Network ACLs are mechanisms you can use in AWS to control network traffic.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now