Sort Xml using XpathExpression Addsort()

[viditmittal]

hi,

i have a xml file

<root>
<Type />
<Description />
<Category />
<employee >
<id>3</id>
</employee>
<employee>
<id>1</id>
</employee>
<employee>
<id>5</id>
</employee>
</root>

and i want output xml as
<root>
<Type />
<Description />
<Category />
<employee >
<id>1</id>
</employee>
<employee>
<id>3</id>
</employee>
<employee>
<id>5</id>
</employee>
</root>

that is i want updated xml to retain all the nodes(type,Description..)
and employee nodes sorted by their ids.

i am doing this with XpathExpression but with not with much suceess.
the XpathExpression Addsort() method isnt able to sort this.

Can anybody provide me the code on how to do this?
thanx
Vidit

[Pascal Schmitt]

Hello!

that is i want updated xml to retain all the nodes(type,Description..)
and employee nodes sorted by their ids.

i am doing this with XpathExpression but with not with much suceess.
the XpathExpression Addsort() method isnt able to sort this.

AddSort sorts only the output, not the input.

You can't "edit" XML-Documents with XPath (I believe there will be an
editable XPathDocument in .NET 2.0 though).

As Martin Honnen said: use XSLT, it's the easiest way.

(untested)

....
<x:template match="/">
<root>
<x:for-each select="/root/employee">
<x:sort select="id" type="number" />
<x:copy-of select="node()" />
</x:for-each>
</root>
</x:template>
--
Pascal Schmitt

[viditmittal]

thanx for the reply

but i dont to use XSLT , i want to sort it through XpathExpression
AddSort()

[Oleg Tkachenko [MVP]]

vi*********@gmail.com wrote:

but i dont to use XSLT , i want to sort it through XpathExpression
AddSort()

XPath is a query language for selecting parts of XML document. You
cannot modify document using XPath. What you can whne using XmlDocument
is to select nodes with AddSort, insert them into document and then
remove existing ones.

--
Oleg Tkachenko [XML MVP, MCAD]
http://www.xmllab.net
http://blog.tkachenko.com

[Pascal Schmitt]

Hello!

but i dont to use XSLT , i want to sort it through XpathExpression
AddSort()

Well, that's not possible...

You can, as Oleg said, use the Expression to get a sorted List of Nodes.
Then you loop through that list, delete the contained nodes from the
Document and add them again - they will be in the correct order.
--
Pascal Schmitt