Newbie Infopath SQL question.

[smonczka]

I am in the process of looking at InfoPath as a solution for our
office. I installed our MSDN copy on a test server and have spent the
last several days fooling around with it. But the one thing i can not
figure out is how to post data entered into a form back to SQL. I have
figured out how to pull data from the database but posting to a
database still eludes me.

From reading the posts and other information I have found on the web I

know it's posible. Could someone give me a breif explination of how
this is done.

Thanks for the help.
Steve Monczka
(e-mail address removed)

 

[Scott L. Heim [MSFT]]

Hi Steve,

The easiest method is to create your InfoPath solution *from* an Access or
SQL Server database. When you design a new form, choose "New From Data
Connection."

Once you complete the wizard, you will see "queryFields" and "dataFields"
in the Data Source Task Pane. You simply need to drag the "data Fields"
section (after you drill-down to the appropriate table(s)) to your InfoPath
View and one or more "queryFields" as well - these allow you to pull back a
subset of data.

Once you have the data in your form, make a change and then from the File
menu, choose Submit - this will send the changes back to SQL.

I hope this helps!

Best Regards,

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[smonczka]

Scott,

Thank you very much for your explanation. This means it's possible for
me to dump data from several forms into a table to analyze at a later
date. It looks as if this application is a perfect fit for several
forms that we have been manually entering data from.

Your explanation makes perfect sense but do you know of an article or
book that explains it in more detail? I am working with several people
on this project and would like to show them an example of a simple form
dump.

Thanks again for your response, it is much appreciated.

Steve

 

[Scott L. Heim [MSFT]]

Hi Steve,

There are a couple of books I have seen on InfoPath SP1 - unfortunately I
don't know the specific ISBN numbers for you. However, here are some
InfoPath links that may be of interest and help:

A beginner's guide to forms and form templates
http://office.microsoft.com/en-us/assistance/HA011559631033.aspx

InfoPath FAQ
http://www.microsoft.com/technet/prodtechnol/office/office2003/plan/inpthfaq
..mspx

InfoPath Developer Site
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnanchor/ht
ml/odc_ancinfo.asp

Understanding Fully Trusted Forms
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ipsdk/html/
ipsdkUnderstandingFullyTrustedForms.asp

InfoPath SDK
http://www.microsoft.com/downloads/details.aspx?FamilyId=351F0616-93AA-4FE8-
9238-D702F1BFBAB4&displaylang=en

InfoPath BLOG Site
http://blogs.msdn.com/infopath/

InfoPath Toolkit for VS.NET
http://www.microsoft.com/downloads/details.aspx?FamilyID=7e9ebc57-e115-4cac-
9986-a712e22879bb&DisplayLang=en

I hope some of this is beneficial for you!

Take care,

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[smonczka]

Scott thank you both for you time and effort.

Steve