Loading

Sorting Xml Elements in C#.Net

surendra ka

Hi i'm having an xml document below like this

Canara
1
56789

0
Canara
56789

302
Canara
56789

309
Canara
56789

310
Canara
56789

0
Canara
56789

Canara
1
56789

302
Canara
56789

309
Canara
56789

310
Canara
56789

I want to order by the document by accountid, and save back

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes13y ago
Try this:

using System;
using System.Linq;
using System.Xml.Linq;

class Test
{
static void Main()
{
XElement root = XElement.Load("surendra.xml");
XElement[] sortedTables = root.Elements("Table").OrderBy(t => (int)t.Element("accountid")).ToArray();
root.ReplaceAll(sortedTables);
root.Save("surendra.xml");
}
}
Satyapriya Nayak13y ago
http://stackoverflow.com/questions/9494275/sorting-of-xml-file-by-xmlelements-innertext
http://www.dotnetcurry.com/ShowArticle.aspx?ID=479