Replacing XML Elements programmaticall y with either VB.Net or C#

[James Fifth]

Hello and God Bless,

I am stumped trying to get a simple xml database replacing certain data
with other data programmaticall y. This is what my xml looks like.

*************** *************** **********
<Root_Element >
<Topic index="1">
<Sub_Topic>
<Notes></Notes>
<Notes></Notes>
</Sub_Topic>
</Topic>
<Topic index="2">
<Sub_Topic>
<Notes></Notes>
<Notes></Notes>
<Notes></Notes>
</Sub_Topic>
<Sub_Topic>
<Notes></Notes>
</Sub_Topic>
</Topic>
<Topic index="3">
<Sub_Topic>
<Notes></Notes>
</Sub_Topic>
</Topic>
</Root_Element>
*************** *************** **********

What i want to do is navigate to <Topic index="2">, and replace all
child nodes under it with new nodes.

Keep in mind that the number of nodes replacing the current ones will be
different. For instance, i wll replace the 2 <Sub_Topicsunde r <Topic
index="2"with 4 <Sub_Topicswi th different <Notesunder them.

I can read both C# and VB.Net, so it doesnt matter what language you
write in. Please help me.

Thank you all, and God Bless.
*** Sent via Developersdex http://www.developersdex.com ***

[Saurabh]

XmlDocument xdoc = new XmlDocument();
string strXML = "<Root_Element> <Topic
index=\"1\"><Su b_Topic><Notes> ";
strXML += "</Notes><Notes></Notes></Sub_Topic></Topic>";
strXML += "<Topic index=\"2\"><Su b_Topic><Notes> </Notes>";
strXML += "<Notes></Notes><Notes></Notes></Sub_Topic><Sub_ Topic>";
strXML += "<Notes></Notes></Sub_Topic></Topic><Topic index=\"3\">";
strXML +=
"<Sub_Topic><No tes></Notes></Sub_Topic></Topic></Root_Element>";
xdoc.LoadXml(st rXML);
while(xdoc.HasC hildNodes)
{
for(int i = 0; i < xdoc.SelectNode s("/Root_Element/").Count; i++)
{
if(xdoc.GetElem entsByTagName(" Topic")[i].Attributes[0].Value.ToString ().Equals("2"))
{
/* Now Replace the childNodes */
}
}
}

[Saurabh]

This code is for retrieval:

XmlDocument xdoc = new XmlDocument();
string strXML = "<Root_Element> <Topic
index=\"1\"><Su b_Topic><Notes> ";
strXML += "</Notes><Notes></Notes></Sub_Topic></Topic>";
strXML += "<Topic index=\"2\"><Su b_Topic><Notes> </Notes>";
strXML += "<Notes></Notes><Notes></Notes></Sub_Topic><Sub_ Topic>";
strXML += "<Notes></Notes></Sub_Topic></Topic><Topic index=\"3\">";
strXML +=
"<Sub_Topic><No tes></Notes></Sub_Topic></Topic></Root_Element>";
xdoc.LoadXml(st rXML);
while(xdoc.HasC hildNodes)
{
for(int i = 0; i < xdoc.SelectNode s("/Root_Element/").Count; i++)
{
if(xdoc.GetElem entsByTagName(" Topic")[i].Attributes[0].Value.ToString ().Equals("2"))
{
/* Now Replace the childNodes */
}
}
}