Reading Repeating Table Values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kb at donovanhill - 31 Aug 2007 03:42 GMT

Hi,

I am using InfoPath 2007 with VB.net and would like to write all the field
values entered within a forms repeating table to a sharepoint list. Submit to
sharepoint is fine, I just need some sample code that loops through table
values, any help would be greatly appreciated.

Thanks

Signature

Reply to this Message

K.Ramana Reddy(GGK Tech) - 31 Aug 2007 04:54 GMT

Hi,

Use below code.

//To get all nodes in a repeating table.
Dim NodeList = thisXDocument.DOM.selectNodes("Xpath of your repeating table
parent node")

    //iterate through all nodes in repeating table.
    for(var i = 0; i< NodeList.length; i++)
    {
        //if you want to do any thing here, you can write code        }

Signature

k.Ramana Reddy
http://www.GGKtech.com

> Hi,
>
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

kb at donovanhill - 04 Sep 2007 00:52 GMT

Hi,

Thanks for your reply, unfortunately 'thisXDocument.DOM.selectnodes' is now
legacy in InfoPath2007, so I could not get this to work, although your
suggestion prompted me to try other solutions, the vb.net code below works,
but may not be the best solution.

Public Sub CTRL5_5_Clicked(ByVal sender As Object, ByVal e As
ClickedEventArgs)

Dim navigator As XPathNavigator = Me.CreateNavigator()
Dim nodes As XPathNodeIterator =
navigator.Select("/my:myFields/my:group1/my:group2", NamespaceManager)
Dim nodesNavigator As XPathNavigator = nodes.Current
Dim NodeValue As String

Dim nodestext As XPathNodeIterator =
nodesNavigator.SelectDescendants(XPathNodeType.Text, False)

While nodestext.MoveNext()
NodeValue = nodestext.Current.Value
MessageBox.Show(nodestext.Current.Value)
End While

End Sub

Signature

> Hi,
>
[quoted text clipped - 17 lines]
> >
> > Thanks

Reply to this Message