sorting xml file in ascending or descending order RSS

• • Reply
  

  kiranmoolya

  Member

  10 Points

  12 Posts

  sorting xml file in ascending or descending order

  Feb 23, 2012 09:49 AM|LINK

  Hi Guys,

             How can i sort the xml in ascending or descending order while creating and updating xml file without using xslt and xpath.

  please help.

  • Edited by kiranmoolya on Feb 23, 2012 09:51 AM
• • Reply
  

  DarrellNorto...

  All-Star

  86805 Points

  9644 Posts

  Moderator

  MVP

  Re: sorting xml file in ascending or descending order

  Feb 23, 2012 01:13 PM|LINK

  Use LINQ-to-XML and the sort method:

  http://msdn.microsoft.com/en-us/vstudio/bb738051

  Darrell Norton, MVP
  Darrell Norton's Blog
  Please click "Mark as Answer" if this helped you.
• • Reply
  

  kuber.manral

  Contributor

  3051 Points

  714 Posts

  Re: sorting xml file in ascending or descending order

  Feb 24, 2012 10:03 AM|LINK

  Hi,

    try below Code for Sorting using LINQ to XML..

  XDocument data = XDocument.Load(HttpContext.Current.Server.MapPath("~/Data/Customers.xml"));
  
      return Convert.ToInt32(
  		(from c in data.Descendants("Customer")
  		orderby Convert.ToInt32(c.Attribute("ID").Value) descending
  		select c.Attribute("ID").Value).FirstOrDefault()
  		) + 1;

  Please "Mark As Answer;", if this Post helps you.
  Visit My Blog
  • Edited by kuber.manral on Feb 24, 2012 10:04 AM
  • Marked as answer by decker dong - msft on Feb 29, 2012 12:39 AM