remove xml node in xml document

[Que]

hi
i have the following xml document
<root>
<item>
<key>
<scode></scode>
</key>
<scode></scode>
<desc></desc>
<pc></pc>
</item>
<item>
<key>
<scode></scode>
</key>
<scode></scode>
<desc></desc>
<pc></pc>
</item>
<item>
<key>
<scode></scode>
</key>
<scode></scode>
<desc></desc>
<pc></pc>
</item>
</root>

how do i remove , the second scode node so that the document looks as
follows

<root>
<item>
<key>
<scode></scode>
</key>
<desc></desc>
<pc></pc>
</item>
<item>
<key>
<scode></scode>
</key>
<desc></desc>
<pc></pc>
</item>
<item>
<key>
<scode></scode>
</key>
<desc></desc>
<pc></pc>
</item>
</root>

thanks
Que

[ronchese]

Re: remove xml node in xml document

Have you used the xmldocument? Put your xml in a file and test with the following code:


Dim xmldoc As New Xml.XmlDocument ()
Dim nodRoot As Xml.XmlNode

xmldoc.Load("c: \test.xml")
nodRoot = xmldoc.ChildNod es(0)

'write debug info
Debug.WriteLine ("ChildNodes count: " & nodRoot.ChildNo des.Count)
'remove the 2nd node
nodRoot.RemoveC hild(nodRoot.Ch ildNodes(1))
'write debug info
Debug.WriteLine ("ChildNodes count: " & nodRoot.ChildNo des.Count)


Also, you can use XPath to find a desired node to further remove.

[]s
Cesar


"Que" <aq.mahomed@gma il.com> wrote in message news:1147468267 .715035.33390@i 39g2000cwa.goog legroups.com...[color=blue]
> hi
> i have the following xml document
> <root>
> <item>
> <key>
> <scode></scode>
> </key>
> <scode></scode>
> <desc></desc>
> <pc></pc>
> </item>
> <item>
> <key>
> <scode></scode>
> </key>
> <scode></scode>
> <desc></desc>
> <pc></pc>
> </item>
> <item>
> <key>
> <scode></scode>
> </key>
> <scode></scode>
> <desc></desc>
> <pc></pc>
> </item>
> </root>
>
> how do i remove , the second scode node so that the document looks as
> follows
>
> <root>
> <item>
> <key>
> <scode></scode>
> </key>
> <desc></desc>
> <pc></pc>
> </item>
> <item>
> <key>
> <scode></scode>
> </key>
> <desc></desc>
> <pc></pc>
> </item>
> <item>
> <key>
> <scode></scode>
> </key>
> <desc></desc>
> <pc></pc>
> </item>
> </root>
>
> thanks
> Que
>[/color]