SQL Database Integration

Re: Save data from infopath to SQL database

whapakk — Sun, 20 Nov 2005 12:32:40 GMT

quote:

2. When you are submitting the form, change command of your dataconnection to insert values into DB. Now query the dataconnection.
3. Other things you can try is to write a stored proc to insert values to DB and set this as command to the secondary dataconnection and query the dataconnection.

Sorry but can you explain a bit more about the 'command' of the dataconnection. I tried something but I don't know if it's the same.
I added a new dataconnection and on the wizard, I trashed the generated SQL statement and wrote my own. But all it can do is retrieve custom data. For SQL statements with parameters I don't know how I'll be able to pass them when I query the dataconnection.

Re: Save data from infopath to SQL database

Agni Jonnalagadda — Fri, 18 Nov 2005 08:49:46 GMT

Hi,
There one thing that you can try here,
1. Take regular secondary dataconnection, which gets the data.
2. When you are submitting the form, change command of your dataconnection to insert values into DB. Now query the dataconnection.
See if this works!
3. Other things you can try is to write a stored proc to insert values to DB and set this as command to the secondary dataconnection and query the dataconnection.

Try these out and let me know if it works?

Agni
InfoPath Dev India

Re: Save data from infopath to SQL database

whapakk — Fri, 18 Nov 2005 05:30:52 GMT

Hi Agni,
I have already deployed my form. It takes the filled out form and saves the document to a sharepoint site, simple. I didnt use dataconnections except for the secondary sql datasources for dropdownlists. Now they added a new requirement that it has to be able to save the form data to SQL. Is there any easy way of doing this without changing the primary datasource because form has lots of rules that will need to be rewritten. I can use the 3rd option in your list but I don't think I can make my form fully trusted. Any ideas? Thanks.

btw, I used managed C#

quote:
Practice makes perfect, but then, nobody's perfect. So, why practice?

Re: Save data from infopath to SQL database

Agni Jonnalagadda — Wed, 28 Sep 2005 13:58:55 GMT

Hi,
There are three option here,
1. Take primary dataconnection to the database table. With this connection you can insert rows into the table, modify rows in the table and delete rows in the table.

2. Write a Webservice method which takes your data as input and saves back to database.

3. Write .net code to connect to Database using SQLConnection and save values to DB. But this connection needs full trust to your form.

Agni
InfoPath Dev India

Save data from infopath to SQL database

lfadoidao — Mon, 26 Sep 2005 18:48:54 GMT

How I make to send the inserted data in the Form for my connection of data base (SQL)?