Change the XML elements sequence

[Thu]

I export some database data to an XML file. How do I
change the sequence of the elements (fields) appear in
the XML document?

For example, my XML output from TableA is:

<TableA>
<Field(0)>
<Field(1)>
<Field(2)>
<Field(3)>
</TableA>

If I want to change the sequence of the fields to:

<TableA>
<Field(0)>
<Field(3)>
<Field(1)>
<Field(2)>
</TableA>

Does anyone know what is the easiest way to do this
without using "select" statement? (Because this example
has been simplified for easier illustration, original
problem involves multiple tables and DataRelations, which
cannot be solved using "Select" statement.)
Can XML schema control the sequence of the elements
appear in XML document? Thanks.

[Chris Lovett]

If the documents are not too big then you could use XSLT to transform the
first document into the second.

"Thu" <th***********@hotmail.com> wrote in message
news:08****************************@phx.gbl...

I export some database data to an XML file. How do I
change the sequence of the elements (fields) appear in
the XML document?

For example, my XML output from TableA is:

<TableA>
<Field(0)>
<Field(1)>
<Field(2)>
<Field(3)>
</TableA>

If I want to change the sequence of the fields to:

<TableA>
<Field(0)>
<Field(3)>
<Field(1)>
<Field(2)>
</TableA>

Does anyone know what is the easiest way to do this
without using "select" statement? (Because this example
has been simplified for easier illustration, original
problem involves multiple tables and DataRelations, which
cannot be solved using "Select" statement.)
Can XML schema control the sequence of the elements
appear in XML document? Thanks.