Code

Re: Save data in a database using custom code in InfoPath 2007

alexia_net — Wed, 14 Apr 2010 15:04:10 GMT

Thank you cery much!

Re: Save data in a database using custom code in InfoPath 2007

Qazi Anis — Wed, 14 Apr 2010 12:31:25 GMT

what are you trying to achieve by

XPathNavigator(xnFormName = null)

i think you should try

xnFormName= Xndoc.SelectSingleNode("XPATH",this.NamespaceManager);

if (xnFormName == null)

{

//your code

}

Re: Save data in a database using custom code in InfoPath 2007

alexia_net — Wed, 14 Apr 2010 12:12:55 GMT

There is one more thing. When I am using

XPathNavigator(xnFormName = null)

i get this error

Error 1 'XPathNavigator' is a type and cannot be used as an expression.

I have commented the line and the program works, but why the error?

Thank you!

Re: Save data in a database using custom code in InfoPath 2007

alexia_net — Wed, 14 Apr 2010 11:57:50 GMT

Thank you so much Qazi Anis. I did the job!

:-bd

Re: Save data in a database using custom code in InfoPath 2007

Qazi Anis — Wed, 14 Apr 2010 11:31:23 GMT

XPathNavigator xnFormName = null;

XPathNavigator xnDoc = null;

xnDoc = this.MainDataSource.CreateNavigator();

xnFormName = xnDoc.SelectSingleNode("Field_Xpath_Path", this.NamespaceManager);

variable_string= xnFormName.Value;

//To get field xpath -> in design task -> Data source -> right click on the field and click Copy XPath

Save data in a database using custom code in InfoPath 2007

alexia_net — Wed, 14 Apr 2010 11:14:12 GMT

Hi. I am trying to save data in a sql database using InforPath 2007 with my own code in Visual studio tools fro applications. I do not know how to connect the field i have on the template (form) with the code. For example in Visua Studio C# you write:

variable_string = txtBoxTex.text.

How do i Write the same in Visual studio tools fro applications, how do i connect the textbox from the template(form) with the value i define in the code? Thank you!

P.S. I am new with InfoPath.