vb.net中的ParseXml文件

问题描述

我可以帮助从xml中检索所有名称并将其显示在列表框中。





我尝试过一些代码，但它只在文本框中显示第一个标签名称，如何在列表框中显示所有代码。

Hi, Can i get some help to retrieve all name from the xml and display them on a listbox.


I tried some codes, but it is displaying only the fist tag name in a textbox,how to display all in a list box.

Imports System.IO
Imports System.Xml
Public Class Form1

    Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
        Dim clsDocument As New System.Xml.XmlDocument
        clsDocument.Load("C:\Users\Viraj\Desktop\XMLFile1.xml")
        Dim clsAuthors As System.Xml.XmlNodeList = clsDocument.SelectNodes("//bookstore/book/author")
        clsAuthors = clsDocument.GetElementsByTagName("author")
        For Each clsNode As System.Xml.XmlNode In clsAuthors
            Dim sName As String
            Try
                If clsNode.ChildNodes.Count = 1 Then
                    sName = clsNode.Item("name").InnerText
                ElseIf clsNode.ChildNodes.Count = 2 Then
                    sName = String.Concat(clsNode.Item("first-name").InnerText, " ", clsNode.Item("last-name").InnerText)
                End If
            Catch
                sName = "(Unable to retrieve name)"
            End Try
            TextBox1.Text = String.Concat(TextBox1.Text, sName, ControlChars.CrLf)
        Next

    End Sub

我的XML文件是： -

MY XML FILE IS:-

<?xml version="1.0" encoding="UTF-8"?>
<!-- This file represents a fragment of a book store inventory database -->
<bookstore>
  <book genre="autobiography" publicationdate="1981" ISBN="1-861003-11-0">
    <title>The Autobiography of Benjamin Franklin</title>
    <author>
      <first-name>Benjamin</first-name>
      <last-name>Franklin</last-name>
    </author>
    <price>8.99</price>
  </book>
  <book genre="novel" publicationdate="1967" ISBN="0-201-63361-2">
    <title>The Confidence Man</title>
    <author>
      <first-name>Herman</first-name>
      <last-name>Melville</last-name>
    </author>
    <price>11.99</price>
  </book>
  <book genre="philosophy" publicationdate="1991" ISBN="1-861001-57-6">
    <title>The Gorgias</title>
    <author>
      <name>Plato</name>
    </author>
    <price>9.99</price>
  </book>
</bookstore>

推荐答案

这篇关于vb.net中的ParseXml文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！