I am getting no nodes from the following code:
'Put user code to initialize the page here
Dim listService As New com.domain.my.Lists
listService.Credentials =
System.Net.CredentialCache.DefaultCredentials
Dim xmlDoc = New System.Xml.XmlDocument
Dim ndQuery As XmlNode = xmlDoc.CreateNode(XmlNodeType.Element,
"Query", "")
Dim ndViewFields As XmlNode = xmlDoc.CreateNode(XmlNodeType.Element,
"ViewFields", "")
Dim ndQueryOptions As XmlNode =
xmlDoc.CreateNode(XmlNodeType.Element, "QueryOptions", "")
ndQueryOptions.InnerXml =
"<IncludeMandatoryColumns>FALSE</IncludeMandatoryColumns>" + _
"<DateInUtc>TRUE</DateInUtc>"
ndViewFields.InnerXml = "<FieldRef Name='Title'/><FieldRef
Name='URL'/><FieldRef Name='Category'/>"
ndQuery.InnerXml = ""
Try
Dim ndListItems As XmlNode = listService.GetListItems("Toolbar",
Nothing, ndQuery, ndViewFields, Nothing, ndQueryOptions)
Dim doc As XmlDocument = New XmlDocument
doc.LoadXml(Replace(ndListItems.InnerXml, ControlChars.Lf &
ControlChars.Lf, ""))
Dim nsmgr As XmlNamespaceManager = New
XmlNamespaceManager(doc.NameTable)
nsmgr.AddNamespace("z", "#RowsetSchema")
nsmgr.AddNamespace("rs", "urn:schemas-microsoft.com:rowset")
Dim node As XmlNode
Dim xl As XmlNodeList = doc.SelectNodes("/rs:data/z:row", nsmgr)
For Each node In xl
Debug.WriteLine(node.Attributes("ows_Title"))
Next
Debug.WriteLine(ndListItems.InnerXml)
Catch ex As System.Web.Services.Protocols.SoapException
Debug.WriteLine("Message:" & vbCrLf & ex.Message + vbCrLf +
"Detail:" + vbCrLf + ex.Detail.InnerText + ControlChars.Lf + "StackTrace:" +
ControlChars.Lf + ex.StackTrace)
End Try
The following is the Outer XML that I am receiving back, which clearly has
records.
<listitems xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882"
xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"
xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema"
xmlns="http://schemas.microsoft.com/sharepoint/soap/">
<rs:data ItemCount="3">
<z:row ows_Title="Yahoo" ows_URL="http://www.yahoo.com"
ows_Category="Sites" ows_ID="1" ows_owshiddenversion="1" />
<z:row ows_Title="Google" ows_URL="http://www.google.com"
ows_Category="Tools" ows_ID="2" ows_owshiddenversion="1" />
<z:row ows_Title="SharePoint Help"
ows_URL="/_vti_bin/help/1033/sps/html/SharePointHelp.htm" ows_Category="Help"
ows_ID="3" ows_owshiddenversion="3" />
</rs:data>
</listitems>
Am I missing something?
Thanks!