InfoPath Dev

I am using VB.NET and would like to write all the field values enter within a repeating table to SQL. If anyone has a quick sample loop I would greatly appr. it.

Thanks

Hi,

To loop through your repeating table, you can use (group2 is the repeating group):
Dim oNodeList As IXMLDOMNodeList
Dim oNode As IXMLDOMNode
Dim oField As IXMLDOMNode
oNodeList = thisXDocument.DOM.selectNodes("my:myFields/my:group1/my:group2")
If (oNodeList.length > 0) Then
For Each oNode In oNodeList
If (oNode.nodeType = DOMNodeType.NODE_ELEMENT) Then
oField = oNode.selectSingleNode("my:field1")
thisXDocument.UI.Alert(oField.text)
End If
Next
End If

Regards,

Franck Dauché
InfoPathDev