asked on

Help with reordering ID data element using VB.NET

Hi,

How do you reorder the ID data element using VB.NET? For example if my xml file contains

<Root>
<Table>
<ID>4<ID>
<Item></Item>
</Table>
<Table>
<ID>2<ID>
<Item></Item>
</Table>
<Table>
<ID>1<ID>
<Item></Item>
</Table>
<Table>
<ID>3<ID>
<Item></Item>
</Table>
</Root>

How do I obtain the following xml file?

<Root>
<Table>
<ID>1<ID>
<Item></Item>
</Table>
<Table>
<ID>2<ID>
<Item></Item>
</Table>
<Table>
<ID>3<ID>
<Item></Item>
</Table>
<Table>
<ID>4<ID>
<Item></Item>
</Table>
</Root>

Thanks,

Victor

ASKER CERTIFIED SOLUTION

Fernando Soto

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Victor Charles

ASKER

Thank you, will get back to you after I test the code.

Fernando Soto

Hi Victor, how are you doing with this question?

Victor Charles

ASKER

Thank You.

Fernando Soto

Not a problem Victor, glad to help.

Victor Charles

ASKER

Hi Fernando,

How do I modify the code to enter numeric values in a data element (i.e ID) that is empty in squential order?

Thanks,

Victor

Fernando Soto

Hi Victor;

Well you will need to determine what values, number's, will replace the empty nodes values for, <ID>, then sort then. The difficult part is to figure out what ID's to give these nodes.

Victor Charles

ASKER

Hi Fernando,
I would like to add numbers sequentially starting with 0 in the first record.

Victor