<div>
Let me know if this question is not clear.
</div>


Let me know if this question is not clear.

<div>
I eventually got this to work.<br />
I'm new to this and didn't know how the SQLAdapters, tablemapping, etc work, but I've got it figured out now. &nbsp;I was trying to force a single SQLDataAdapter to work with more than 1 table.<br />
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?
</div>


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?

<div>
<div class="content wysiwyg-content">
Hello,<br />
I am using a web service to query/update SQL tables from InfoPath. &nbsp;I put multiple tables in my dataset, and they show up correctly in Infopath. &nbsp;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. <br />
I had this working correctly when my dataset contained only one table, because the Primary Key was set to point to the modified row. &nbsp;But how does it work now that I have a dataset with mulitple tables.<br />
Thank you!<br />
Dave<br />

</div>
</div>


Hello,
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!
Dave


Infopath Submit Dataset containing multiple tables to Web Service

Microsoft InfoPath is a software application for designing, distributing, filling and submitting electronic forms containing structured data. The product features a WYSIWYG form designer in which the various controls (e.g. textbox, radio button, checkbox) are bound to data, represented separately as a hierarchical tree view of folders and data fields. All the data stored in InfoPath forms are stored in an XML format. Secondary data sources can be built into the form or they can be accessed through an external data connection to SharePoint or a Web service.

InfoPath

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

A Web service is a method of communication between two electronic devices over a network. It is a software function provided at a network address over the Web with the service always on as in the concept of utility computing. A web service has an interface described in Web Services Description Language (WSDL). Other systems interact with the Web service in a manner prescribed by its description using SOAP (Simple Object Access Protocol) messages. There are two major classes of Web services: REST-compliant web services, and Arbitrary web services.