VB.Net XML Retrieve entire node based on first element.

[RexR35630]

Example

<?xml version="1.0" encoding="UTF-8"?>
 <BooksXML>
   <Books>
 
     <BookInfo>
        <BookName>Hobbit</BookName>
        <Author>Token</Author>
        <Genre>Fantasy</Genre>
     </BookInfo>
 
     <BookInfo>
        <BookName>Spirits Of Lore</BookName>
        <Author>Yolenda</Author>
        <Genre>Romance</Genre>
     </BookInfo>
 
   </Books>
</BooksXML>

I need to return the whole node using with a query criteria of "Hobbit" so it would return
Hobbit
Token
Fantasy

I've tried

Dim BookName As String = cb_BookList.SelectedItem
Dim xmlDoc As New XmlDocument()
xmlDoc.Load(BooksXMLLocation)
Dim nodes As XmlNodeList = xmlDoc.DocumentElement.SelectNodes("/BooksXML/Books/BookInfo")
 
Dim BookName As String = ""
Dim BookAuther As String = "" 
Dim Genre As String = ""
For Each node As XmlNode In nodes
   BookName = node.SelectSingleNode("BookName").InnerText
   BookAuther =node.SelectSingleNode("BookAuther").InnerText
   Genre = node.SelectSingleNode("Genre").InnerText
Next

Any help would be appreciated
Thank you

[Frinavale]

It looks like you stopped half way to what you want to accomplish.

It looks like you should successfully be grabbing all of the BookInfo nodes and that you are looping through them.

The only thing you seem to be missing is an If statement to find the information you are looking for.

    Dim bookNameToSerachFor As String = cb_BookList.SelectedItem
    Dim xmlDoc As New XmlDocument()
    xmlDoc.Load(BooksXMLLocation)
    Dim nodes As XmlNodeList = xmlDoc.DocumentElement.GetElementsByTagName("BookInfo")
 
    Dim bookName As String = ""
    Dim bookAuthor As String = "" 
    Dim genre As String = ""
    For Each node As XmlNode In nodes
       bookName = node.SelectSingleNode("BookName").InnerText
       If String.Compare(bookNameToSearchFor, bookName, True) = 0 Then
         bookName = node.SelectSingleNode("BookName").InnerText
         bookAuthor =node.SelectSingleNode("Author").InnerText
         genre = node.SelectSingleNode("Genre").InnerText
         Exit For
       End If
    Next
'At this point you have the information 
'about the book that you were searching for...
'Or you don't because you couldn't find the book

Mind you maybe you are having a problem because you misspelled the word Author (you spelled it as Auther). This would mean that you would never find a the node containing the author information.

Actually there is no node called "BookAuthor" either!
You need to ensure that you use the appropriate names when you are retrieving nodes. You should be using "Author".

In the future you need to state more details about what is not working.


-Frinny

[kvinvisibleguy]

Dear Friend,
I have made your project(as you wanted).I have uploaded the files to the following URL:-

http://www.filehosting.org/file/details/478406/Rex.rar

This RAR file has three files inside.One .xml and two .vb files.I have used the code by Frinavale-but made some changes(spelling correction and a
one or two minor additions).These files have to be processed by C-Pad technique(Developed by me)-details see URL:-

http://www.dreamincode.net/forums/to...&#entry2124851

This C-pad technique hold good for VB.Net and WPF/VB.Net applications.Here you just call the compiler and msbuild from your cmd window.
It works very fine.Gives light weight results.No unnecessary extra baggages(files).
You have to do two things before compiling:-
1.Correct the path given in Rex22.vb file-from "C:\Users\VEKATRAMAN\Desktop\Rex\BooksXMLLocation. xml" to

"C:\Users\......\Desktop\Rex\BooksXMLLocation. xml"

Here the dotted portion is particular to your computer.Propably your name.Keep all three files in desktop in Folder "Rex".
Now the compiler calling is as follows:-

path=%path%;c:\windows\microsoft.net\framework\v4. 0.30319
VBC /OUT:Rex1 /T:winexe C:\Users\........\Desktop\Rex\Rex1.vb
VBC /OUT:Rex1 /T:winexe C:\Users\........\Desktop\Rex\Rex11.vb C:\Users\VEKATRAMAN\Desktop\Rex\Rex1.vb
Rex1

Your executive file will be in C:\Users\........ folder.All VB.Net (by C-Pad) .exe files get created here only.

Regards and blessings,
Happy coding,

Venkatraman/kvinvisibleguy
(age-68 +)