SharePoint Integration

Re: Not able to pass values from VB.NET to InfoPatch

kerberos — Wed, 15 Feb 2012 01:02:53 GMT

Thanks Hilary,

That was it, it worked perfectly.

I was able to pass the value to the form.
Now, how can I get the value from the form? :)

Im doing this

Private Sub InternalStartup(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Startup
Dim weekoftheyear As String
weekoftheyear = DatePart("ww", Today)
MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:Time_sheet/my:weekoftheyear", NamespaceManager).SetValue(weekoftheyear)

'read from form date picker
Dim dateselected As XPathNavigator = Me.CreateNavigator.SelectSingleNode("/my:myFields/my:Time_sheet/my:week_of", NamespaceManager)
'write to form another date picker or text field
MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:Time_sheet/my:newdatecheck", NamespaceManager).SetValue(dateselected)

I want to replace the Today with my dateselected fiedl from the form and do the calculations based on the inserted date.

again thank you,

Kerb,

Re: Not able to pass values from VB.NET to InfoPatch

Hilary Stoupa — Mon, 13 Feb 2012 17:37:45 GMT

You need to include a NamespaceManager:

MainDataSource.CreateNavigator().SelectSingleNode("/myFields/my:weekdays", NamespaceManager)

Not able to pass values from VB.NET to InfoPatch

kerberos — Sun, 12 Feb 2012 05:59:21 GMT

Hi all,

I have a single field on the form that I want to calculate in VB.NET and pass the value into the form.
Im using infopath compatilble with 2007 code.
the field on the form is weekdays and its defined as string.

My code in VB is the following:

Private Sub InternalStartup(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Startup

Dim weekdays As String

MainDataSource.CreateNavigator().SelectSingleNode("/myFields/my:weekdays")

weekdays = DatePart("ww", Today)

End Sub

Wwhen I run it I get the following error:

Namespace Manager or XsltContext needed. This query has a prefix, variable, or user-defined function.

Any ideas?

thanks,