Re: Insert data from GetListItems web service into repeating table

Matt Faus — Fri, 15 Jun 2007 19:00:18 GMT

Hi Shaun,

I'm not too great at VB, but I can give you the general idea:

Create an XmlNodeList object, and initialize it from the result of a GetNodes() function call
Use the VB equivalent to a For Each to iterate over all the XmlNode objects in the XmlNodeList

I don't know if this will help, but it's my best try with VB!

Insert data from GetListItems web service into repeating table

shaun.nieves — Fri, 15 Jun 2007 00:32:25 GMT

I'm trying to put data I've retrieved from a getlistitems web service into a repeating table but I don't know how to iterate through the data to enter it in. Here is my code so far. Any help would be greatly apprecitated. Thanks!

Dim xmlDoc As New System.Xml.XmlDocument

            Dim listName As String = "{9D39C54C-ABBB-4E79-A3DA-A781ADB09DF3}"
            Dim viewName As String = ""
            Dim rowLimit As String = ""
            Dim Unit As String = thisXDocument.DOM.selectSingleNode("/my:myFields/my:Unit").text
            Dim i As Integer

            Dim query As System.Xml.XmlElement = xmlDoc.CreateElement("Query")
            Dim viewFields As System.Xml.XmlElement = xmlDoc.CreateElement("ViewFields")
            Dim queryOptions As System.Xml.XmlElement = xmlDoc.CreateElement("QueryOptions")

            query.InnerXml = "<Where><And><Eq><FieldRef Name=""ContainerType"" />" + "<Value Type=""Text"">CM</Value></Eq><Eq><FieldRef Name=""Unit"" />" + _
            "<Value Type=""Text"">" + Unit + "</Value></Eq></And></Where>"
            'query.InnerXml = ""
            viewFields.InnerXml = "<FieldRef Name=""TrackingNumber"" /><FieldRef Name=""Unit"" /><FieldRef Name=""ContainerType"" /><FieldRef Name=""Active"" />"
            queryOptions.InnerXml = ""

Dim nodeListItems As System.Xml.XmlNode = listService.GetListItems(listName, viewName, query, viewFields, rowLimit, queryOptions)
MsgBox(nodeListItems.OuterXml, MsgBoxStyle.Critical)

Web Services

Re: Insert data from GetListItems web service into repeating table

Insert data from GetListItems web service into repeating table