 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / May 2005Newbie Infopath SQL question.
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 smonczka@hotmail.com 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 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 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 Scott thank you both for you time and effort. Steve |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.