Hello guys,

I am trying to merge two xml documents in VB.NET

I have one xmldocument which has the following xml:

<Allocations>
   <Item />
   <Item />
   <Item />
   <Item />
   <Item />
   <Item />
</Allocations>

I have another xml Document which has the following:
<Allocations>
   <Item />
   <Item />
   <Item />
</Allocations>

I want to merge the second xmldocument into the first one.

So I want the following:
<Allocations>
   <Item />
   <Item />
   <Item />
   <Item />
   <Item />
   <Item />
   <Item />
   <Item />
   <Item />
</Allocations>


The way I approaced it is as follows:

The first xmldocument is called: xdoc

The second xmldocument is called: xdoc_Selected

Dim xnodeList As XmlNodeList = xdoc_Selected.SelectNodes("//Allocations/Item")
For Each xnode In xnodeList
  xdoc.AppendChild(xnode)
Next

But this was giving me an error. so I tried this method:

xtempnode = xdoc.ImportNode(xdoc_Selected.DocumentElement, True)
xdoc.DocumentElement.AppendChild(xtempnode)

But this results in the following xml:

<Allocations>
   <Item />
   <Item />
   <Item />
   <Item />
   <Item />
   <Item />
   <Allocations>
       <Item />
       <Item />
       <Item />
   </Allocations>
</Allocations>

By the way, I DO NOT want to load the two xml's into a DataSet and then merge them. I want to do it without DataSet. Please advice me on what I am doing wrong. Thank you.

Sanch

The simple algorithm that can be used to do this is . Get the oot element of the First document . Remove the corresponding ending element from the first document . Now get the Second document and remove the root element ( I assume that the root element of both the first and the second document are the same , if not than this procedure may not be followed and the two files can be appended one after the other ) , now appened the second file directly to the first file . Now u have both the XML files in one single doc . U can further process this file in whichever way u want .