D
Daniel
Hi All!
I'm new to InfoPath 2007, just started a few days ago.
I have created a form with simple controls on it and I have some code behind
written in C# VS2005.
I would like to query a SQL database and populate some of the fields and
publish this form to a network drive but I have encountered a few problems:
1: My Office doesn't seem to have the required permissions to connect to the
SQL. I can connect to it in any other way but not from my form code.
2: I can not set the value of a non-string-typed field.
I have a NumberOfItems field which has a type of integer.
The code:
XPathNavigator NumberOfItems =
MainDataSource.CreateNavigator().SelectSingleNode("my:myFields/my:NumberOfItems", NamespaceManager);
NumberOfItems.SetValue("123");
The error message:
Schema validation found non-data type errors.
If I try with the SetTypedVale then it says:
The method or operation is not implemented.
3: I publish my form with the Publish Wizard and the summary says that the
permission level is domain. But when I want to open the template from the
published location it says the form has restricted permission level and it
should have domain and suggests to open it from the published location.
Any idea to these problems?
Daniel
I'm new to InfoPath 2007, just started a few days ago.
I have created a form with simple controls on it and I have some code behind
written in C# VS2005.
I would like to query a SQL database and populate some of the fields and
publish this form to a network drive but I have encountered a few problems:
1: My Office doesn't seem to have the required permissions to connect to the
SQL. I can connect to it in any other way but not from my form code.
2: I can not set the value of a non-string-typed field.
I have a NumberOfItems field which has a type of integer.
The code:
XPathNavigator NumberOfItems =
MainDataSource.CreateNavigator().SelectSingleNode("my:myFields/my:NumberOfItems", NamespaceManager);
NumberOfItems.SetValue("123");
The error message:
Schema validation found non-data type errors.
If I try with the SetTypedVale then it says:
The method or operation is not implemented.
3: I publish my form with the Publish Wizard and the summary says that the
permission level is domain. But when I want to open the template from the
published location it says the form has restricted permission level and it
should have domain and suggests to open it from the published location.
Any idea to these problems?
Daniel