Sign in
 
HomeOnline20132010Other VersionsRelated ProductsLibraryForumsGallery
TechCenter >
> 
> 
How to load xml document content from a SP list/library?

Answered How to load xml document content from a SP list/library?

  • Tuesday, May 01, 2012 8:23 PM
     
     
    Sign In to Vote
    0

    I have a form list/library in SharePoint, which consists of InfoPath forms, they are all in xml format.

    Now, I need to go through all the xml files and retrieve some of its content. But I have no idea what code I have to write in order to get the xml document loaded onto. I have something like this, what should I do in the bolded section below?

    PList formLibrary =   newSite.AllWebs[strServerURL].Lists[libraryName];
    SPListItemCollection collListItems = formLibrary.Items;
    foreach (SPListItem oListItem in collListItems)
    {
        {
    ??? what should I do here ??? Where formXML will be the text of the file.

      XmlDocument doc = new XmlDocument();
                            doc.InnerXml = formXML;
                            XmlNamespaceManager xNameSpace = InitNamespaceManager(doc);
                            XPathNavigator xNavMain = doc.CreateNavigator();

    Thanks in advance, your help would be greatly appreciated.

     

All Replies

  • Tuesday, May 01, 2012 8:31 PM
     
     
    Sign In to Vote
    0

    You can use XmlDocument.Load(formXML). After this you can use xpath queries to get child nodes. You can also use Xml.Linq and the XElement and XDocument classes.

    http://msdn.microsoft.com/en-us/library/ms256086.aspx

    http://msdn.microsoft.com/en-us/library/bb387098.aspx

    Blog | SharePoint Field Notes Dev Tool | ClassMaster

     
  • Tuesday, May 01, 2012 10:08 PM
     
     
    Sign In to Vote
    0

    Hi,

    Actually, I would like to know how I can get the value of "formXML" out of the SP list, that is how can I load the string value to this  variable formXML from a SP list/file,

    formXML = loadString(SPlistitem.file.url) <-- something like this, what will be the method?

    Thanks.

     
  • Wednesday, May 02, 2012 1:50 PM
     
     Answered
    Sign In to Vote
    0

    I was able to get this working with the following code.

    Stream fStream = oListItem.File.OpenBinaryStream() ;

    byte[] MyData = new byte[fStream.Length];
    fStream.Read(MyData, 0, (int)fStream.Length);
    string formXML = Encoding.Unicode.GetString(MyData);
    formXML = Encoding.UTF8.GetString(MyData);

    • Marked As Answer by wkpli Wednesday, May 02, 2012 1:50 PM
    •