p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/)
-   Pro Visual Basic 2005 (http://p2p.wrox.com/pro-visual-basic-2005-217/)
-   -   How to search in XML file? (http://p2p.wrox.com/pro-visual-basic-2005/89908-how-search-xml-file.html)

d3struktor April 23rd, 2013 09:46 AM

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)


All times are GMT -4. The time now is 09:11 AM.

Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
2013 John Wiley & Sons, Inc.