SQL Database Integration

Re: Update SQL data source

antoipepper — Wed, 16 Mar 2005 14:42:32 GMT

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.

Re: Update SQL data source

Shanthi Reddy — Mon, 14 Mar 2005 19:22:06 GMT

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

Update SQL data source

antoipepper — Mon, 14 Mar 2005 16:48:10 GMT

HELP!!! I've queried an sql data source and made changes to the data on the form. How do i update the sql database?