Update SQL data source - InfoPath Dev
in

InfoPath Dev

Update SQL data source

Last post 03-16-2005 07:42 AM by antoipepper. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 03-14-2005 09:48 AM

    Update SQL data source

    HELP!!! I've queried an sql data source and made changes to the data on the form. How do i update the sql database?
  • 03-14-2005 12:22 PM In reply to

    Hello,
    Infopath does not have built-in functionality for you to submit to the DB from a secondary datasource. But you can do it if your Main datasource is a dataconnection to the DB. There are a few times when submit is not allowed in the Main datasource also and the reasons for this are mentioned in the last screen of that data connection.

    One other way of submitting is to do it entirely in c# code using SQL Client connections. One important thing is that to submit to a Database a form needs to have full trust otherwise you cannot submit to a DB.

    Hope this information helps!

    Shanthi
    InfoPathDev India
    Shanthi Reddy
  • 03-16-2005 07:42 AM In reply to

    Hello,
    For a second there i wasn't sure where the C# code was meant to go since the editor that ships with infopath accepts only jscript and vbscript. Then it hit me... There must be an infopath project template in .NET!

    Thanks for the info. I'm more comfortable with .NET and I'm looking foward to working with it.

    Antoine
    Nigeria.
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.