View Single Post
  #1 (permalink)  
Old April 23rd, 2013, 09:46 AM
d3struktor d3struktor is offline
Registered User
Points: 10, Level: 1
Points: 10, Level: 1 Points: 10, Level: 1 Points: 10, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2012
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default How to search in XML file?

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)