Compare two XML file

Question

Hi,

I have two XML file. One is given by the user say Source.xml and other is given by the application it self means load from the main project.

Like,

Source.xml :

<input>
  <data>001</data>
  <data>002</data>
  <data>005</data>
</input>

Mapping.xml :

<map>
  <default>?-?-?</default>
    <input value="001">RZ</input>
    <input value="002">TH</input>
    <input value="003">SC</input>
</map>

And resultant output I want is :

<output>
  <data>RZ</data>
  <data>TH</data>
  <data>?-?-?</data>
</output>

It means I just want to map two xml file and want the output as shown above.
So, please help me to do so. I am new to asp.net.

Muralidharan Deenathayalan · Answer

You can use the below code. string input = " 001 002 005 "; string mappinginput = " ?-?-? RZ TH SC "; System.Xml.XmlDocument source = new System.Xml.XmlDocument(); source.LoadXml(input); System.Xml.XmlDocument mapping = new System.Xml.XmlDocument(); mapping.LoadXml(mappinginput); string output = ""; foreach(System.Xml.XmlNode node in source.SelectNodes("/input/data")) { System.Xml.XmlNode childNode = mapping.SelectSingleNode("//map/input[@value='" + node.InnerText +"']"); if (childNode != null) { if (node.InnerText == childNode.Attributes["value"].InnerText) { output += " " + childNode.InnerText + " "; } } else { output += " " + mapping.SelectSingleNode("/map/default").InnerText + " "; } } output = " " + output + " "; MessageBox.Show(output); The output will be like.... Hope this helps you.

Compare two XML file

Answers (1)