c# - Sort XmlNodeList with a specific Node value -


i searched web this, not able find related solution.

i have following xml

  <table>     <entity>employee</entity>     <entityid>2786</entityid>     <goal>       <goalid>31931</goalid>       <filterdata>lastmodifiedon¥2014-03-20t18:11:01.0000000+05:30Æactivetaskcount¥0</filterdata>     </goal>     <goal>       <goalid>31932</goalid>       <filterdata>lastmodifiedon¥2014-03-22t15:26:09.0000000+05:30Æactivetaskcount¥0</filterdata>     </goal>     <goal>       <goalid>31932</goalid>       <filterdata>lastmodifiedon¥2014-03-22t09:25:00.0000000+05:30Æactivetaskcount¥0</filterdata>     </goal>   </table>  

from above xml when read data got 2 separate datatables; 1 employees , 1 related goals.

what needed want sort goals related employee respect lastmodifiedon filterdata node.

note: getting lastmodifiedon value split node value this

nodevalue.split('Æ')[0].split('¥')[1] 

right using system.xml namespace doing operations. looked @ linq xml unable make work.

i getting xmlnodelist following code

xmlnodelist goalnodeslist = doc.documentelement.selectnodes("/newdataset/table[entity='employee' , entityid='" + entityid + "']/goal");

here want sorted goals (with respect lastmodifiedon).

i looked @ useful links didn't idea far

  1. sorting xml nodes based on datetime attribute c#, xpath
  2. xmldocument sort

i ready convert code linq xml needed brief example.

one thing try creating collection of key value pairs key goal , value date. override compareto method comparing dates , use [collection name].sort(). hope helps


Comments

Popular posts from this blog

java - WrongTypeOfReturnValue exception thrown when unit testing using mockito -

php - Magento - Deleted Base url key -

android - How to disable Button if EditText is empty ? -