XmlDocument to DataSet only returning 1 Row



I have an problematic piece of code and it's something really peculiar and nothing I've ever experienced before!


I'm calling a Sharepoint SOAP function and the results are being returned absolutely fine., many XML records of data are being retruned.


Now I have tried to convert the results into an XmlDocument, which I then use to load into a DataSet.


However when it gets inserted into the DataSet it's only inserting 1 record, which happens to be the very first record of the Xml.


The problematic code is the below:



Lists list = new Lists();
list.Url = URL + "_vti_bin/Lists.asmx";
list.UseDefaultCredentials = true;

//Gets the entire Lists attached to the Sharepoint Site
XmlNode Results = list.GetListCollection();

//Writes the entire results into an XmlDocument.
doc.AppendChild(doc.ImportNode(Results, true));


using (StringReader xmlSR = new StringReader(doc.InnerXml))
{
ds.ReadXml(xmlSR, XmlReadMode.Auto);
}


The Xml from 'doc.InnerXml' is all valid and is pastable into Xml Notepad 2007, so i'm a bit at a lost.


I hope someone can shed some light onto this, be much appreciated


No comments:

Post a Comment