Learn how to a build a cloud-first strategyRegister Now


How to retrieve and submit using secondary data connections in InfoPath

Posted on 2009-12-16
Medium Priority
Last Modified: 2012-05-08
I'm able to retrieve data into InfoPath from SQL via a Secondary Data Connection web service using a DataSet.  I display the retrieved data in a table, and let the user make updates.  Then I want to Submit the DataSet back to the database via another Secondary (submit) Data Connection.  

Is there an easy, direct way to do that?  I know there are step by step instructions online on how to do this with a Main (retrieve and submit) data connection, but I'm not sure how to do it with Secondary Data Connections.  Any pointers to examples, or an overview on what I need to do?      Thanks!
Question by:FingPhoto
  • 2
LVL 28

Accepted Solution

clayfox earned 1500 total points
ID: 26067125
By default InfoPath can only query and submit with the main data connection, and you need to create the form from scratch as a database form.

Secondary data is only possible to submit using web services.

Author Comment

ID: 26067994
Thanks for the response.  When you say "only the main data connection can query and submit", do you mean querying and then submitting back that same dataset?

My question is whether you can obtain a dataset from a web service, let the user make changes to that data, and then write it back out *easily*, without using the Main datasource for both query and submit?


Author Closing Comment

ID: 31666894
I was hoping there was a way to do this with Secondary connections (and a little more code in my web service) but I guess not. Thanks.

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses

810 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