VB.NET读取XML的有关问题
VB.NET读取XML的问题
小弟初学BV.NET 对操作XML不熟，特此请教：
XML内容：
请问：在VB.NET中怎样循环取得name和Remarks的值？
要插入数据库，sql为 "insert into aaa(id,name,remarks) values(id,'name','remarks')"
------解决方案--------------------
比如取得name
Dim doc As XmlDocument = New XmlDocument()
doc.Load("c:\sample.xml")
Dim list As XmlNodeList = doc.GetElementsByTagName("name")
Dim node As XmlNode
For Each node In list
If node.ParentNode.NodeType = XmlNodeType.Element _
AndAlso node.ParentNode.Name = "user" Then
Trace.WriteLine(node.InnerText)
End If
Next
小弟初学BV.NET 对操作XML不熟，特此请教：
XML内容：
- VB.NET code
<users>
<user>
<id>1</id>
<name>schyu</name>
<Remarks>net开发</Remarks>
</user>
<user>
<id>2</id>
<name>张三</name>
<Remarks>开发</Remarks>
</user>
<user>
<id>3</id>
<name>李四</name>
<Remarks>开发</Remarks>
</user>
</users>
请问：在VB.NET中怎样循环取得name和Remarks的值？
要插入数据库，sql为 "insert into aaa(id,name,remarks) values(id,'name','remarks')"
------解决方案--------------------
比如取得name
Dim doc As XmlDocument = New XmlDocument()
doc.Load("c:\sample.xml")
Dim list As XmlNodeList = doc.GetElementsByTagName("name")
Dim node As XmlNode
For Each node In list
If node.ParentNode.NodeType = XmlNodeType.Element _
AndAlso node.ParentNode.Name = "user" Then
Trace.WriteLine(node.InnerText)
End If
Next