Code

Re: Button to do both, save and submit

Anuma — Thu, 04 Dec 2008 13:43:30 GMT

Hi,

Read this link:

http://support.microsoft.com/kb/826993

Re: Button to do both, save and submit

madhuri — Thu, 04 Dec 2008 13:04:22 GMT

Hello

Write the below code on onclick event

Code for Submitting to DataBase

try

{

string empName = thisXDocument.DOM.selectSingleNode("/my:myFields/my:EmpName").text;

string empID = thisXDocument.DOM.selectSingleNode("/my:myFields/my:EmpID").text;

SqlConnection dbConn = new SqlConnection("Server=Server22;Database=Training_Madhuri;Integrated Security = SSPI");

SqlCommand nonQueryCommand = dbConn.CreateCommand();

dbConn.Open();

nonQueryCommand.CommandText = string.Format("insert into Emp (id,EmpName,Department)values (" + id + "','" + EmpName + "','" + Depatment + ");

nonQueryCommand.ExecuteNonQuery();

}

catch (Exception ex)

{

thisXDocument.UI.Alert(ex.Message);

}

Code For Submitting to SharePoint:

DAVAdapter SharePoint = (DAVAdapter)thisXDocument.DataAdapters["SharePoint Library Submit"];
SharePoint.FileName = fileName;

SharePoint.FolderURL = SharePointURL;

SharePoint.Submit();

Re: Button to do both, save and submit

pablavo — Thu, 04 Dec 2008 11:22:24 GMT

Thanks for getting back to me.

I understand that I will have to use code to submit and then save, my problem is that I don't know how to. Do you know of an article or code that could help me do this?

Thanks.

Re: Button to do both, save and submit

Shiva — Thu, 04 Dec 2008 10:40:47 GMT

Hello,

If you want to submit the form to database and SharePoint using one button then you should write the code for both submissions code in one button. Whenever user clicks on that button it will submits to SharePoint and Database.

Button to do both, save and submit

pablavo — Thu, 04 Dec 2008 10:10:30 GMT

Hi folks,

This is probably quite simple though i'm still new to InfoPath forms.

The Infopath forms are filled in by users and first the submit button is pressed and then the form is saved to a sharepoint library. The forms information sometimes go out of synch with the values in the database because a user might forget to save a form when updating and when they reopen and update, they will get an error.

I would like to find a way to have one button that will do both, submit the values go the database and save it to the form library as well.

Does anyone know how I could achieve this? Thanks for any help I receive.