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

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); } }

http://stackoverflow.com/questions/9494275/sorting-of-xml-file-by-xmlelements-innertext http://www.dotnetcurry.com/ShowArticle.aspx?ID=479

Answers

Sorting Xml Elements in C#.Net

surendra ka

11y

6.8k

Hi i'm having an xml document below like this

<Table>
<bankname>Canara</bankname>
<accountid>1</accountid>
<balance>56789</balance>
</Table>
<Table>
<accountid>0</accountid>
<bankname>Canara</bankname>
<balance>56789</balance>
</Table>
<Table>
<accountid>302</accountid>
<bankname>Canara</bankname>
<balance>56789</balance>
</Table>
<Table>
<accountid>309</accountid>
<bankname>Canara</bankname>
<balance>56789</balance>
</Table>
<Table>
<accountid>310</accountid>
<bankname>Canara</bankname>
<balance>56789</balance>
</Table>
<Table>
<accountid>0</accountid>
<bankname>Canara</bankname>
<balance>56789</balance>
</Table>
<Table>
<bankname>Canara</bankname>
<accountid>1</accountid>
<balance>56789</balance>
</Table>
<Table>
<accountid>302</accountid>
<bankname>Canara</bankname>
<balance>56789</balance>
</Table>
<Table>
<accountid>309</accountid>
<bankname>Canara</bankname>
<balance>56789</balance>
</Table>
<Table>
<accountid>310</accountid>
<bankname>Canara</bankname>
<balance>56789</balance>
</Table>

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