How to search in XML file?

d3struktor · April 23rd, 2013, 08:46 AM

I made book's catalog for my mum, with books saved in XML file.
I made simple search system, but this only returns me, ie. if I would search in names: "Agatha Christie", the program will return me "Agatha Christie" as many times, as there is book's of her. This is what i tried:

Code:

 ' Load the XML file.
        Dim xml_doc As New Xml.XmlDocument
        xml_doc.Load("BooksCatalog.xml")
        Dim tagName As String
        If rdbLastName.Checked Then
            tagName = "LastName"
        ElseIf rdbFirstName.Checked Then
            tagName = "FirstName"
        ElseIf rdbTitle.Checked Then
            tagName = "Title"
        ElseIf rdbYear.Checked Then
            tagName = "Year"
        End If

        Dim child_nodes As XmlNodeList = _
            xml_doc.GetElementsByTagName(tagName)
        Dim LastName As XmlNodeList = xml_doc.GetElementsByTagName("LastName")
        Dim FirstName As XmlNodeList = xml_doc.GetElementsByTagName("FirstName")
        Dim Title As XmlNodeList = xml_doc.GetElementsByTagName("Title")
        Dim Year As XmlNodeList = xml_doc.GetElementsByTagName("Year")

        Dim txt As String = ""
        For Each child As XmlNode In child_nodes
            If child.InnerText = txtFind.Text Then
                lboFind.Items.Add(child.InnerText)
            End If
        Next child

but I want program to return me something like this:
FirstName LastName - Title (Year)

The XML file looks:

Code:

<?xml version="1.0"?>
<BooksBook xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <ListOfBooks>
    <Book>
      <LastName>LastName1</LastName>
      <FirstName>FirstName1</FirstName>
      <Title>Title1</Title>
      <Year>Year1</Year>
    </Book>
    <Book>
      <LastName>LastName2</LastName>
      <FirstName>FirstName2</FirstName>
      <Title>Title2</Title>
      <Year>Year2</Year>
    </Book>
  </ListOfBooks>
</BooksBook>

Can any1 help me?

('Imports System.Xml' were included)