How to retrieve and submit using secondary data connections in InfoPath

Posted on 2009-12-16
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
    LVL 28

    Accepted Solution

    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

    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

    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

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    745 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

    15 Experts available now in Live!

    Get 1:1 Help Now