Click here to Skip to main content
12,948,130 members (72,003 online)
Rate this:
 
Please Sign up or sign in to vote.
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

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>
Posted 12-Feb-13 20:10pm
Updated 12-Feb-13 20:31pm
Jαved12.5K
v4

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Go through this-
XML File Parsing in VB.NET[^]
  Permalink  
Comments
virajdawarka 13-Feb-13 3:36am
   
It is displaying on console, how to display them on listbox ? I did came across this code!!
Jαved 13-Feb-13 3:48am
   
instead of Console.WriteLine() add to ListBox as ListBox1.Items.Add().
virajdawarka 13-Feb-13 3:52am
   
ok thnks buddy, will try that and let u know !
virajdawarka 13-Feb-13 4:18am
   
Thnks a lot, its working !
Jαved 13-Feb-13 7:21am
   
You're welcome! B-)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 5,344
CHill60 3,275
Maciej Los 2,703
Jochen Arndt 1,935
ppolymorphe 1,795


Advertise | Privacy | Mobile
Web02 | 2.8.170524.1 | Last Updated 13 Feb 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100