Merge two xml elements [Answered]RSS

• • Reply
  

  maheshvishnu

  Member

  175 Points

  341 Posts

  Merge two xml elements

  Jun 22, 2016 01:13 PM|maheshvishnu|LINK

  What is the best way to merge the below two elements

  <NewDataSet>
  <Table1 Email="admin@domain.com" Application="SKREPO" />
  <Table1 Email="Test@domain.com" Application="SKREPO" />
  </NewDataSet>

  
  <OutParamDataSet>
  <OutputParameters Result1="Test12" />
  </OutParamDataSet>

  My output should be like

  <NewDataSet>
  <Table1 Email="admin@domain.com" Application="SKREPO" />
  <Table1 Email="Test@domain.com" Application="SKREPO" />

  <OutputParameters Result1="Test12" />

  </NewDataSet>
  
  

• • Reply
  

  Yohann Lu

  Star

  9954 Points

  1788 Posts

  Microsoft

  Re: Merge two xml elements

  Jun 23, 2016 08:03 AM|Yohann Lu|LINK

  Hi maheshvishnu,

  You can try the following code.

             string xml1 = @"<NewDataSet><Table1 Email=""admin @domain.com"" Application=""SKREPO"" /> <Table1 Email = ""Test@domain.com"" Application = ""SKREPO"" /></NewDataSet>";
  
              XDocument xdoc1 = new XDocument();
              xdoc1 = XDocument.Parse(xml1);// load xml string
  
  
              string xml2 = @"<OutParamDataSet><OutputParameters Result1=""Test12"" /> </OutParamDataSet> ";
              XDocument xdoc2 = new XDocument();
              xdoc2 = XDocument.Parse(xml2);// load xml string
  
  
              foreach (XElement element in xdoc2.Descendants("OutParamDataSet"))
              {
                  if (element.Name.LocalName.ToString() == "OutParamDataSet")
                  {
                      foreach (XElement elementn in element.Nodes())
                      {
                          if (elementn.Name.LocalName.ToString() == "OutputParameters")
                          {
                              XElement nxel = new XElement("OutputParameters",
                                         new XAttribute("Result1", elementn.Attributes("Result1").First().Value));
                              XElement root = xdoc1.Element("NewDataSet");
                              root.Add(nxel);
                          }
                      }
                  }
  
                  TextBox3.Text = xdoc1.ToString();
              }
  
  

  
  
  

  Best Regards,

  Yohann Lu

  
  MSDN Community Support
  Please remember to "Mark as Answer" the responses that resolved your issue.
  
• • Reply
  

  maheshvishnu

  Member

  175 Points

  341 Posts

  Re: Merge two xml elements

  Jun 24, 2016 04:42 AM|maheshvishnu|LINK

  XDocument spRecordSet = XDocument.Parse('<OutParamDataSet><OutputParameters Result1="Test12" /></OutParamDataSet>');
  XDocument outParamsData = XDocument.Parse('<NewDataSet><Table1 Email="admin@domain.com" Application="SKREPO" /><Table1 Email="Test@domain.com" Application="SKREPO" /></NewDataSet>');
  outParamsData.Element("NewDataSet").Add(spRecordSet.Element("OutParamDataSet").DescendantNodes());
  result = outParamsData.ToString();