XML, XSLT and XPATH

XML, XSLT and XPATH RSS

XML help with tags

Please support our XML, XSLT and XPATH advertiser: Intel Parallel Studio Home

•

Join Date: Mar 2008

Posts: 6

Reputation: smithsf22 is an unknown quantity at this point

Solved Threads: 0

smithsf22

Offline

Newbie Poster

XML help with tags

Jul 23rd, 2009

Hello,
I am having a problem adding a node properly. It does add but it duplicates the Test node I know why it is doing it (I create the Test node in the root as well as in the dataset) but I don’t know how to prevent it. Any suggestions would be welcome as I have never used XML before. Thanks

 Help with Code Tags 
 XML, XSLT and XPATH Syntax (Toggle Plain Text) 
<?xml version="1.0" ?> 
  <MyTest XMLVersion="1.3" Stamp="7/22/2009 11:55:59 PM">
  <Test>
    <Test>
      <MyTestID>bfc7941d-70a8-48c0-a535-561a73393457</MyTestID> 
      <MyTestID2>ccf2757f-63s5-57h9-d437-185s63285942</MyTestID2> 
      <SomeText>Some Text Here</SomeText>  
    </Test>
  </Test>  </OtherNode>
<?xml version="1.0" ?> 
  <MyTest XMLVersion="1.3" Stamp="7/22/2009 11:55:59 PM">
  <Test>
    <Test>
      <MyTestID>bfc7941d-70a8-48c0-a535-561a73393457</MyTestID> 
      <MyTestID2>ccf2757f-63s5-57h9-d437-185s63285942</MyTestID2> 
      <SomeText>Some Text Here</SomeText>  
    </Test>
  </Test>  </OtherNode>

I want it to be (notice only one Test tag)

 Help with Code Tags 
 XML, XSLT and XPATH Syntax (Toggle Plain Text) 
<?xml version="1.0" ?> 
  <MyTest XMLVersion="1.3" Stamp="7/22/2009 11:55:59 PM">
  <Test>
    <MyTestID>bfc7941d-70a8-48c0-a535-561a73393457</MyTestID> 
    <MyTestID2>ccf2757f-63s5-57h9-d437-185s63285942</MyTestID2> 
    <SomeText>Some Text Here</SomeText>  
  < /Test>  </OtherNode>
<?xml version="1.0" ?> 
  <MyTest XMLVersion="1.3" Stamp="7/22/2009 11:55:59 PM">
  <Test>
    <MyTestID>bfc7941d-70a8-48c0-a535-561a73393457</MyTestID> 
    <MyTestID2>ccf2757f-63s5-57h9-d437-185s63285942</MyTestID2> 
    <SomeText>Some Text Here</SomeText>  
  < /Test>  </OtherNode>

Here is the code I use to generate it:

 Help with Code Tags 
 XML, XSLT and XPATH Syntax (Toggle Plain Text) 
string xml = "<?xml version=\"1.0\"?><MyTest XMLVersion=\"1.3\" Stamp=\"" + DateTime.Now.ToString() + "\"><Test></Test><OtherNode></OtherNode></MyTest>";
doc.LoadXml(xml);//start the xml 
GetTestData(); //gets dataset loads it into an XMLDocument called doc
TempNode = doc.SelectSingleNode("//MyTest");//get the 
myNode = m_myTest.SelectSingleNode("//Test");//get the node
myNode = m_MenuOnline.ImportNode(m_MyNode, true);
TempNode.AppendChild(myNode);//add the node
string xml = "<?xml version=\"1.0\"?><MyTest XMLVersion=\"1.3\" Stamp=\"" + DateTime.Now.ToString() + "\"><Test></Test><OtherNode></OtherNode></MyTest>";
doc.LoadXml(xml);//start the xml 
GetTestData(); //gets dataset loads it into an XMLDocument called doc
TempNode = doc.SelectSingleNode("//MyTest");//get the 
myNode = m_myTest.SelectSingleNode("//Test");//get the node
myNode = m_MenuOnline.ImportNode(m_MyNode, true);
TempNode.AppendChild(myNode);//add the node

Thanks

•

Join Date: Apr 2008

Posts: 45

Reputation: bcasp is an unknown quantity at this point

Solved Threads: 10

bcasp

Offline

Light Poster

Re: XML help with tags

Jul 23rd, 2009

Rather than adding the Temp node from the dataset as a child of the Temp node from doc, you could loop through the children of myNode and add them as children of TempNode.

 Help with Code Tags 
 C# Syntax (Toggle Plain Text) 
string xml = "<?xml version=\"1.0\"?><MyTest XMLVersion=\"1.3\" Stamp=\"" + DateTime.Now.ToString() + "\"><Test></Test><OtherNode></OtherNode></MyTest>";
doc.LoadXml(xml);//start the xml 
GetTestData(); //gets dataset loads it into an XMLDocument called doc
TempNode = doc.SelectSingleNode("//MyTest");//get the 
myNode = m_myTest.SelectSingleNode("//Test");//get the node
myNode = m_MenuOnline.ImportNode(m_MyNode, true);
for(XmlNode child in myNode.ChildNodes)
    TempNode.AppendChild(child);//add the node
string xml = "<?xml version=\"1.0\"?><MyTest XMLVersion=\"1.3\" Stamp=\"" + DateTime.Now.ToString() + "\"><Test></Test><OtherNode></OtherNode></MyTest>";
doc.LoadXml(xml);//start the xml 
GetTestData(); //gets dataset loads it into an XMLDocument called doc
TempNode = doc.SelectSingleNode("//MyTest");//get the 
myNode = m_myTest.SelectSingleNode("//Test");//get the node
myNode = m_MenuOnline.ImportNode(m_MyNode, true);
for(XmlNode child in myNode.ChildNodes)
    TempNode.AppendChild(child);//add the node