in

Dot Net Mafia

Group site for developer blogs dealing with (usually) .NET, SharePoint 2013, SharePoint 2010, Office 365, SharePoint Online, and other Microsoft products, as well as some discussion of general programming related concepts.

This Blog

Syndication

Archives

Corey Roth [MVP]

A SharePoint MVP bringing you the latest time saving tips for SharePoint 2013, Office 365 / SharePoint Online and Visual Studio 2013.

Code samples from my short talk about LINQ to XML

Today, I had the opportunity to give a short introduction on how to do some basic queries on XML documents with LINQ to XML.  In the talk, I talked about how to create anonymous types from your XML document so that you can work with strong types.  I also showed some uses some of the classes, methods, and properties, they would use most when working with LINQ to XML. 

I also discussed how LINQ to XML can be used to make working with repeating tables in InfoPath easier.  Consider the following XML of an InfoPath form.  We have a repeating table called RepeatingTable and in the table there is element called Item.

<?xml version="1.0" encoding="utf-8"?>

<my:myFields xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

             xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2008-12-30T15:48:37"

             xmlns:xd="http://schemas.microsoft.com/office/infopath/2003" xml:lang="en-US">

  <my:RepeatingTable>

    <my:Item>

      <my:Name>Polo Shirt</my:Name>

      <my:Color>26134</my:Color>

      <my:Price>19.99</my:Price>

    </my:Item>

    <my:Item>

      <my:Name>Jeans</my:Name>

      <my:Color>01823</my:Color>

      <my:Price>29.99</my:Price>

    </my:Item>

  </my:RepeatingTable>

  <my:Id>83123</my:Id>

</my:myFields>

If you needed to work with this repeating table when the InfoPath form was loaded again, you could use code like the following.  You could also apply a similar technique to work with this data inside a workflow.

// use the MainDataSource to read the XML of the InfoPath Form

XDocument infoPathDocument = XDocument.Load(new System.IO.StringReader(MainDataSource.CreateNavigator().OuterXml));

// required to access my: namespace

XNamespace myNamespace = "http://schemas.microsoft.com/office/infopath/2003/myXSD/2008-12-30T15:48:37";

// use descendants node to find any element with the name Item in the tree

var items = from item in infoPathDocument.Descendants(myNamespace + "Item")

            select new

            {

                Name = item.Element(myNamespace + "Name").Value,

                Color = item.Element(myNamespace + "Color").Value,

                Price = item.Element(myNamespace + "Price").Value

            };

foreach (var item in items)

{

    // do something

}

In the code above, I use the CreateNavigator method of the MainDataSource as usual when working with an InfoPath form and I use a StringReader to load it into an XDocument.  Since InfoPath form’s always use the my namespace it is necessary to declare it using the XNamespace object and use it before referring to any element or attribute in the document.  In the example above, I create a new anonymous type with the Name, Color, and Price and then I can use a foreach loop to iterate through the items.

I have attached the code for the example above as well as the other examples I mentioned in the talk to this post.  Please, let me know if you have any questions.

Follow me on twitter.

Comments

No Comments

Leave a Comment

(required)  
(optional)
(required)  
Add

About CoreyRoth

Corey Roth is an independent SharePoint consultant specializing in ECM, Apps, and Search.
2015 dotnetmafia.
Powered by Community Server (Non-Commercial Edition), by Telligent Systems