Need Simple XML help in 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 ***

[Martin Honnen]

James Fifth wrote:

<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.

Use System.Xml.XmlD ocument e.g.
XmlDocument xmlDocument = new XmlDocument();
xmlDocument.Loa d(@"file.xml") ;
// using XPath and SelectSingleNod e to find element
XmlElement topic =
xmlDocument.Sel ectSingleNode(@ "/Root_Element/Topic[@index = '2']") as
XmlElement;
if (topic != null) {
// now there are various ways to proceed
// 1: setting InnerXml e.g.
topic.InnerXml = "<Sub_Topic><No tes></Notes></Sub_Topic>";
// that parses the string on the right side into nodes and
// replaces the previous contents

// 2: creating nodes with the DOM e.g
XmlElement subtopic = xmlDocument.Cre ateElement("Sub _Topic");
XmlElement notes = xmlDocument.Cre ateElement("Not es");
notes.InnerText = "DOM example";
subtopic.Append Child(notes);

while (topic.HasChild Nodes) {
topic.RemoveChi ld(topic.LastCh ild);
}

topic.AppendChi ld(subtopic);

// save document e.g.
xmlDocument.Sav e(@"file.xml") ;
}

--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/

[Thankful]

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 ***

Thank you for this. Though simple, I have been looking for this for a long time.

BizTalk Utilities - Frustration free BizTalk Adapters
http://www.topxml.com/biztalkutilities