VB.NET inserting xml nodes into an existing XML document

Question

I'm simply trying to merge 2 xml documents (adding nodes from one into the other). I've done some Google searching, and tried a few things, but I always get the same error "The node to be inserted is from a different document context"

I'm sure I'm missing something simple, just seems like this should not be that difficult.

Here's my code:

    Dim xmlDoc482 As XmlDocument = New XmlDocument
    Dim xmlDoc486 As XmlDocument = New XmlDocument
    Dim xmlDoc490 As XmlDocument = New XmlDocument

    xmlDoc482.LoadXml(strSettlement482)
    xmlDoc486.LoadXml(strSettlement486)
    xmlDoc490.LoadXml(strSettlement490)

    Dim xmlSummarysNode490 As XmlNode = xmlDoc486("Summarys")
    Dim xmlSummaryNode482 As XmlNode = xmlDoc482("Summarys").LastChild
    Dim xmlSummaryNode486 As XmlNode = xmlDoc486("Summarys").LastChild

    Dim nodeDest As XmlNode
    nodeDest = xmlDoc490.ImportNode(xmlSummaryNode482, True)
    xmlSummarysNode490.AppendChild(nodeDest)

    nodeDest = xmlDoc490.ImportNode(xmlSummaryNode486, True)
    xmlSummarysNode490.AppendChild(nodeDest)

FWIW at this late stage, the plural of summary is summaries. — Andrew Morton
– Andrew Morton, Commented Jul 4, 2017 at 18:04

Mister Lucky · Accepted Answer · 2009-03-26 19:26:15Z

2

Try appending the imported nodes to the DocumentElement instead of the line Dim xmlSummarysNode490 As XmlNode = xmlDoc486("Summarys").

xmlDoc490.DocumentElement.AppendChild(nodeDest)

You could also try using the CloneNode() instead of ImportNode() before the insertion.

Finally something that helped me in merging in the past was to build a simple container xml then dump the children documents all into it.

xmlMerged.LoadXML("<set></set>")

So it becomes:

<set>
 <Summary>....</Summary>
 <Summary>....</Summary>
 ...
</set>

edited Mar 26, 2009 at 19:26

answered Mar 26, 2009 at 19:19

Mister Lucky

4,0832 gold badges22 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Zach Johnson · Accepted Answer · 2009-03-26 19:40:29Z

2

You could create a helper function (or even better, an extension method) to create a copy of the XML node but changes the node's associated document to the document you want to merge into. You could also try using reflection, but that gets kind of messy...

answered Mar 26, 2009 at 19:40

Zach Johnson

24.3k7 gold badges71 silver badges86 bronze badges

Comments

Jim Counts · Accepted Answer · 2009-04-03 06:27:34Z

2

Here is an easy way to merge 2 xmls with the same schema:

Dim x1 As New Dataset
x1.ReadXml(path1)
Dim x2 As New Dataset
x2.ReadXml(path2)

x1.Merge(x2)
x1.WriteXml(path3)

You can probably adapt it to your own situation.

answered Apr 3, 2009 at 6:27

Jim Counts

12.9k9 gold badges49 silver badges63 bronze badges

Comments

Dan Williams · Accepted Answer · 2009-03-26 19:52:07Z

0

This works great, other then my stupid, stupid typo

This:

Dim xmlSummarysNode490 As XmlNode = xmlDoc486("Summarys")

Should be This:

Dim xmlSummarysNode490 As XmlNode = xmlDoc490("Summarys")

An element/node must be added using the document you're adding it to.

answered Mar 26, 2009 at 19:52

Dan Williams

4,95011 gold badges39 silver badges46 bronze badges

Collectives™ on Stack Overflow

VB.NET inserting xml nodes into an existing XML document

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related