读书人

VB.NET读取XML的有关问题

发布时间: 2012-04-14 17:14:21 作者: rapoo

VB.NET读取XML的问题
小弟初学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

读书人网 >VB Dotnet

热点推荐