How to insert an XML File into Another XML File at Specific Node C#

Question

I have two XML Files ,the first one is and Named as XMLTemplate

<DataSources>
<DataSource Name="XXXX">
</DataSource>
<DataSource Name="ABC">
</DataSource>
</DataSources>
<DataSets>
<DataSet Name="abc">
<Query> 
</Query>
<ReportSections>
</ReportSections>

and the second xml file is named as XMLGenrated,

<Fields>
<Field >
</Field>
</Fields>

and I need the Output as,

<DataSource Name="XXXX">
    </DataSource>
    <DataSource Name="ABC">
    </DataSource>
    </DataSources>
    <DataSets>
    <DataSet Name="abc">
    <Query> 
    <Fields>
    <Field >
    </Field>
    </Fields>
    </Query>
    <ReportSections>
    </ReportSections>

Both the Files are in .XML Extension and I dont know how to find the node by its Name Can anyone help me out.

I tried this,

XElement xFileRoot = XElement.Load(XMLTemplate.xml);
XElement xFileChild = XElement.Load(XMLGenerated.xml);
xFileRoot.Add(xFileChild);
xFileRoot.Save(file1.xml);

but the XML adds below the XMLTemplate I dont know how to insert at particular node.

.NET offers many classes for working with XML. There are different ways to do the same job depending on the library you use, whether you have an XSD or not, etc. Did you try anything? — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Mar 26, 2018 at 12:07
@Maxime I tried but i could not achieve it so only posted here . i wanted everyone to completely understand .If you cant help out then its not a problem.Those who have time to read it will post the answer or help me out. — Srinivasan Rajasekaran
– Srinivasan Rajasekaran, Commented Mar 26, 2018 at 12:48
There are multiple root elements in your XmlTemplate. Fix it. — Alexander Petrov
– Alexander Petrov, Commented Mar 26, 2018 at 13:09

Mauricio Gracia Gutierrez · Accepted Answer · 2018-03-26 13:43:25Z

1

Find the node using Linq to XML and Replace its contents

XElement xFileRoot = XElement.Load(XMLTemplate.xml);
XElement xFileChild = XElement.Load(XMLGenerated.xml);


var queryNode = xFileRoot.Element("Query");

queryNode.ReplaceWith(xFileChild) ;

Based on on this answer - How can I update/replace an element of an XElement from a string?

Be aware that you sample XML files contain multiple root nodes, and that if you need to keep the <Query> node you need to change this.

edited Mar 26, 2018 at 13:43

answered Mar 26, 2018 at 13:35

Mauricio Gracia Gutierrez

11k7 gold badges81 silver badges115 bronze badges

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

1 Comment

Chetan Mehra Over a year ago

You just beat me by a second :)

Collectives™ on Stack Overflow

How to insert an XML File into Another XML File at Specific Node C#

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related