 |
 | 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 / July 2007Submit Data to Multiple Data sources
Hi, I am using custom code to submit data to a SQL 2005 Db in an Infopath form and it works fine, but I need it to submit data also to the Share Point Library and save the form in the SharePoint library. ( all in one go).Currently I have a Submit and a Save button( for saving to Sharepoint) in the Infopath form on the Sharepoint server. Thanks Hello You can set Rules on the Submit button to submit the form to Sharepoint Library and save the form to the Library along with your coding running to save the data to SQL DB  SignatureKalyan G Reddy - INFOPATH MVP 2007 http://www.ggktech.com > Hi, > [quoted text clipped - 5 lines] > > Thanks Hi Kalyan, Thanks for the quick reply, but when I select the option for Submitting through Roles, the option for submitting through Code is disabled. And I need the code to submit to the Database(SQL 2005) as there are some manipulations required to be done while submitting. PLease let me know If I am missing someting. Thanks > Hello > [quoted text clipped - 11 lines] > > > > Thanks Hello You use the Action as Rules and Custom Code For Submit to SQL use Custom code (Edit Form Code) and for saving or submitting to sharepoint Click on Rules and Add Action -> Submit using a Dataconnection -> Add -> To a Sharepoint Library.... Any Number of rules can be set on the Button. I hope I made it clear -- Kalyan G Reddy - INFOPATH MVP 2007 http://www.ggktech.com > Hi Kalyan, > [quoted text clipped - 21 lines] > > > > > > Thanks Hi, Again Thanks for the quick reply, but we do not have a submit button on the form, we are using the Submit form option and with that we do not get the option to do both. Hope I am not confusing. > Hello > [quoted text clipped - 35 lines] > > > > > > > > Thanks Hello Aah Now I understand. In this case you should write the code to submit to sharepoint also as you did for submitting to SQL, or else Submit button is a best option which allows you to do both. SignatureKalyan G Reddy - INFOPATH MVP 2007 http://www.ggktech.com > Hi, > [quoted text clipped - 41 lines] > > > > > > > > > > Thanks Hi, Thanks for the solution specified but can you specify where can I find a sample/example to implement this or have you implemented this type of code? Also in the Custom button I believe you cannot do validation for the fields before submittin the form. In Early anticipation Thanks > Hello > Aah Now I understand. In this case you should write the code to submit to [quoted text clipped - 46 lines] > > > > > > > > > > > > Thanks Hi, Check out this link, http://msdn2.microsoft.com/en-us/library/bb251026.aspx We can validate the fields in the form before submitting to sharepoint. I hope this will help for you. Signaturek.Ramana Reddy http://www.GGKtech.com > Hi, > [quoted text clipped - 57 lines] > > > > > > > > > > > > > > Thanks Hi, Thanks again for the reply, Where can I add the JScript code since our programming language is VB/C# and the form is web enabled. Am I missing something? Thanks > Hi, > [quoted text clipped - 66 lines] > > > > > > > > > > > > > > > > Thanks Hi, Convert the Jscript code to VB/C# Signaturek.Ramana Reddy http://www.GGKtech.com > Hi, > [quoted text clipped - 74 lines] > > > > > > > > > > > > > > > > > > Thanks |
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.