changing the "markup" of a node

[chris yoker via DotNetMonster.com]

hi,

I have an xmlFile
<code>
<rows>
<row>
<PRODUCT-TYPE>bike</PRODUCT-TYPE>
<PRODUCT-DATE>01/01/2004</PRODUCT-DATE>
<ADDED-NODE>"blah"<ADDED-NODE />
</row>
<PRODUCT-TYPE>Car</PRODUCT-TYPE>
<PRODUCT-DATE>01/01/2003</PRODUCT-DATE>
<ADDED-NODE>"blah"<ADDED-NODE />
</row>
</rows>
</code>

I want to change the markup of the PRODUCT-TYPE node.

I want to change it to:
<ProductType>
So, my file would become

<code>
<row>
<ProductType>bike</ProductType
<PRODUCT-DATE>01/01/2004</PRODUCT-DATE>
<ADDED-NODE>1stCollectionItemText<ADDED-NODE />
</row>
etc
</code>

I can obtain the nodes no problem.
However, I have tried the:
1) .InnerXml property
2) .ReplaceChild method
3) OuterXml property (Which I don't think I can use because it is read-only)

can someone tell me how to change the markup..I'm struggling.

many thanks,
yogi

--
Message posted via http://www.dotnetmonster.com

[Martin Honnen]

chris yoker via DotNetMonster.com wrote:

I have an xmlFile
<code>
<rows>
<row>
<PRODUCT-TYPE>bike</PRODUCT-TYPE>
<PRODUCT-DATE>01/01/2004</PRODUCT-DATE>
<ADDED-NODE>"blah"<ADDED-NODE />
</row>
<PRODUCT-TYPE>Car</PRODUCT-TYPE>
<PRODUCT-DATE>01/01/2003</PRODUCT-DATE>
<ADDED-NODE>"blah"<ADDED-NODE />
</row>
</rows>
</code>

I want to change the markup of the PRODUCT-TYPE node.

I want to change it to:
<ProductType>
So, my file would become

<code>
<row>
<ProductType>bike</ProductType
<PRODUCT-DATE>01/01/2004</PRODUCT-DATE>
<ADDED-NODE>1stCollectionItemText<ADDED-NODE />
</row>
etc
</code>

I can obtain the nodes no problem.
However, I have tried the:
1) .InnerXml property
2) .ReplaceChild method
3) OuterXml property (Which I don't think I can use because it is read-only)

can someone tell me how to change the markup..I'm struggling.

If you are using the DOM then you need to create a new element e.g.
XmlElement newElement = xmlDocument.createElement("ProductType");
then append the contents of the existing element to the new element e.g.
while (oldElement.HasChildNodes) {
newElement.AppendChild(oldElement.FirstChild);
}
then replace the old element with the new e.g.
oldElement.ParentNode.ReplaceChild(newElement, oldElement);
--

Martin Honnen
http://JavaScript.FAQTs.com/

[chris yoker via DotNetMonster.com]

cheers Martin.

I am not sure how I obtain the "oldElement"
I think that I do something along the lines of:
<code>
Dim nodeList As XmlNodeList = xmlDoc.SelectNodes("Rows/row/PRODUCT-TYPE")

'And then replace the element, with the code you kindly sent.
</code>

the problem is that the above "xmlDoc.SelectNodes" xPath query returns an
EMPTY nodeList.
Yet, If I specify the xPath as follows, then it returns some rows:

<code>
Dim nodeList As XmlNodeList = xmlDoc.SelectNodes("Rows/row")
</code>

I am not sure what is going on.Given the structure of my xml, how should I
obtain the "oldElement" node?
Sorry to ask again, but I'm still finding mt feet :-)

yogi

<code>
<rows>
<row>
<PRODUCT-TYPE>bike</PRODUCT-TYPE>
<PRODUCT-DATE>01/01/2004</PRODUCT-DATE>
<ADDED-NODE>"blah"<ADDED-NODE />
</row>
<PRODUCT-TYPE>Car</PRODUCT-TYPE>
<PRODUCT-DATE>01/01/2003</PRODUCT-DATE>
<ADDED-NODE>"blah"<ADDED-NODE />
</row>
</rows>
</code>

--
Message posted via http://www.dotnetmonster.com

[chris yoker via DotNetMonster.com]

thanks Martin, I managed to find the problem..I have so many transforms
going on that I was losing track of the format of the xml.
Problem solved.
yogi

--
Message posted via http://www.dotnetmonster.com