xmlnode question

[NS]

Hello,
I'm new to xml and I have a question:

I try to do the following
Dim doc As New XmlDocument
doc.LoadXml("<Request><Root><Requestor name='' /><FlowData flowstatus=''
/><Products><productdate productid='' /></Products></Root></Request>")

Dim node As XmlNode =
doc.SelectSingleNode("Request/Root/Requestor/@name")

node.Value = "TestValue"
Dim node3 As XmlNode =
doc.SelectSingleNode("Request/Root/FlowData/@flowstatus")

node3.Value = "TestStatus"

'here comes something I don't know how to do, I want to fill in multiple
products

Dim i As Integer = 1
Dim node2 As XmlNode
For i = 1 To 3

node2 =
doc.SelectSingleNode("Request/Root/Products/productdate/@productid")
node2.Value = i

i = i + 1
Next i
Finally I take the innerxml to do further operations.

The problem is that the value for node2 always get overwritten. I want a
loop that fills x number of products.

Any suggestions ?

Regards,

[Martin Honnen]

NS wrote:

Dim doc As New XmlDocument
doc.LoadXml("<Request><Root><Requestor name='' /><FlowData flowstatus=''
/><Products><productdate productid='' /></Products></Root></Request>")

Dim i As Integer = 1
Dim node2 As XmlNode
For i = 1 To 3

node2 =
doc.SelectSingleNode("Request/Root/Products/productdate/@productid")
node2.Value = i

i = i + 1
Next i

The problem is that the value for node2 always get overwritten. I want a
loop that fills x number of products.

Well your XML above does not have several products elements but only one
and only once productdate element. If you want to add elements to an
XmlDocument then you need to first create them and then insert as needed
e.g.
Dim Products As XmlNode = doc.SelectSingleNode("Request/Root/Products")
For I = 2 To 3
Dim ProductDate As XmlElement = doc.CreateElement("productdate")
ProductDate.SetAttribute("productid", I.ToString())
Products.AppendChild(ProductDate)
Next

--

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

[NS]

"Martin Honnen" <ma*******@yahoo.deschreef in bericht
news:uH**************@TK2MSFTNGP03.phx.gbl...

>

Well your XML above does not have several products elements but only one

and only once productdate element. If you want to add elements to an
XmlDocument then you need to first create them and then insert as needed
e.g.
Dim Products As XmlNode = doc.SelectSingleNode("Request/Root/Products")
For I = 2 To 3
Dim ProductDate As XmlElement = doc.CreateElement("productdate")
ProductDate.SetAttribute("productid", I.ToString())
Products.AppendChild(ProductDate)
Next

--

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

Thank you very much ! Do you have any tips suggestions to read my
xmldocument into a dataset ?
Dim doc As New XmlDocument
doc.LoadXml("<Request><Root><Requestor name='' /><FlowData flowstatus=''
/><Products><productdate productid='' /></Products></Root></Request>")
Or any other suggestions so that I can manipulate data ?
e.g. I want to build a webform with a detail table with all the products
from my xmldocument.

Regards,
NS