Interesting tech stuff I come across day-to-day. Mainly around Biztalk and .NET 3.0

Code Snippet: Sort nodes in an Xml Document

Friday, July 13, 2007

Scenario: Need to produce a new xml document with particular node list sorted in ascending/descending order

Code:

XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(@"Input.xml");

XmlDocument xmlDocCopy = new XmlDocument();
xmlDocCopy.LoadXml(xmlDoc.OuterXml);
xmlDocCopy.SelectSingleNode("//Links").RemoveAll();

XmlNode node = xmlDoc.SelectSingleNode("//Links");
XPathNavigator navigator = node.CreateNavigator();
XPathExpression selectExpression = navigator.Compile("Link/Title");
selectExpression.AddSort(".", XmlSortOrder.Ascending, XmlCaseOrder.None, "", XmlDataType.Text);
XPathNodeIterator nodeIterator = navigator.Select(selectExpression);
while (nodeIterator.MoveNext())
{
    XmlNode linkNode = xmlDoc.SelectSingleNode("//Link[Title=\"" + nodeIterator.Current.Value + "\"]");
    XmlNode importedLinkNode = xmlDocCopy.ImportNode(linkNode, true);
    xmlDocCopy.SelectSingleNode("//Links").AppendChild(importedLinkNode);
}

xmlDocCopy.Save(@"Output.xml");

Input:

<Section>
    <Links>
        <Link Id="1">
            <Title>Jupiter Line</Title>
            <AddedDate>27/05/2007</AddedDate>
        </Link>
        <Link Id="2">
            <Title>Alfa Line</Title>
            <AddedDate>27/05/2007</AddedDate>
        </Link>
        <Link Id="3">
            <Title>Zebra Line</Title>
            <AddedDate>27/05/2007</AddedDate>
        </Link>
        <Link Id="4">
            <Title>Copper Line</Title>
            <AddedDate>27/05/2007</AddedDate>
        </Link>
    </Links>
</Section>

Output:

<Section>
  <Links>
    <Link Id="2">
      <Title>Alfa Line</Title>
      <AddedDate>27/05/2007</AddedDate>
    </Link>
    <Link Id="4">
      <Title>Copper Line</Title>
      <AddedDate>27/05/2007</AddedDate>
    </Link>
    <Link Id="1">
      <Title>Jupiter Line</Title>
      <AddedDate>27/05/2007</AddedDate>
    </Link>
    <Link Id="3">
      <Title>Zebra Line</Title>
      <AddedDate>27/05/2007</AddedDate>
    </Link>
  </Links>
</Section>

  1. Blogger elgoYa said:

    For order by attribute using @nameattribute.

    Example:

    selectExpression.AddSort("@order", XmlSortOrder.Ascending, XmlCaseOrder.None, "", XmlDataType.Number);

  1. Anonymous Anonymous said:

    Good approach. But this may fail if you have two nodes with Same title. The above method works only for nodes with distinct Titles.

    -Sai

  1. Anonymous Anonymous said:

    while (myNodeIterator.MoveNext())
    {
    XmlNode newNode = ((IHasXmlNode)myNodeIterator.Current).GetNode().ParentNode ;
    myXmlNode.AppendChild(newNode);
    }
    myXmlDoc.Save("filename.xml");


    Another way to sort and update xml file.

  1. Blogger AsWaM said:

    Nice but a bit complicated in my opinion ;-)
    What about a mapping with inline XSLT script?

    (xsl:for-each select="Order")
    (xsl:sort select="Date" data-type="text" order="ascending"/)
    (xsl:copy-of select="." /)
    (/xsl:for-each)


    I use it often and it is fine.

    Of course replace brackets with greater than sign....

Leave a comment