Deserialize XML into class object

EDN Admin · Feb 8, 2012

Hi all:
Im sorry as this may be a simple question, however looking through the various links I could not find a solution to my problem.
I am trying to deserialize XML I receive from a website and display the info. Im not 100% familair how XML works other than very simple object. This is a sample of the XML I receive from the site:
<?xml version="1.0" encoding="UTF-8"?> 
<searchResults> 
<resultCount>95</resultCount> 
<Book> 
<bookId>4343589241</bookId> 
<isbn10>0451161351</isbn10> 
<isbn13>9780451161352</isbn13> 
<listingCondition>NOT NEW BOOK</listingCondition> 
<itemCondition>Good</itemCondition> 
<quantity>3</quantity> 
<vendorCurrency>USD</vendorCurrency> 
<listingPrice>1.0</listingPrice> 
<firstBookShipCost>2.95</firstBookShipCost> 
<extraBookShipCost>0.0</extraBookShipCost> 
<minShipDays>0</minShipDays> 
<maxShipDays>0</maxShipDays> 
<totalListingPrice>3.95</totalListingPrice> 
<listingUrl>www.abebooks.com/servlet/BookDetailsPL?bi=4343589241&cm_ven=sws&cm_cat=sws&cm_pla=sws&cm_ite=4343589241</listingUrl> 
<author>Stephen King</author> 
<title>Cujo</title> 
<publisherName>Signet (MM)</publisherName> 
<catalogImage>http://isbn.abebooks.com/mz/51/45/0451161351.jpg</catalogImage> 
<vendorName>ThriftBooks</vendorName> 
<vendorLocation>Auburn, WA, U.S.A.</vendorLocation> 
<vendorId>54239181</vendorId> 
<sellerRating>5</sellerRating> 
<bindingType>S</bindingType> 
</Book> 
<Book> 
<bookId>6154514099</bookId> 
<isbn10>0451161351</isbn10> 
<isbn13>9780451161352</isbn13> 
<listingCondition>NOT NEW BOOK</listingCondition> 
<itemCondition>Good</itemCondition> 
<quantity>1</quantity> 
<vendorCurrency>USD</vendorCurrency> 
<listingPrice>1.0</listingPrice> 
<firstBookShipCost>2.8</firstBookShipCost> 
<extraBookShipCost>0.0</extraBookShipCost> 
<minShipDays>0</minShipDays> 
<maxShipDays>0</maxShipDays> 
<totalListingPrice>3.80</totalListingPrice> 
<listingUrl>www.abebooks.com/servlet/BookDetailsPL?bi=6154514099&cm_ven=sws&cm_cat=sws&cm_pla=sws&cm_ite=6154514099</listingUrl> 
<author>King, Stephen</author> 
<title>Cujo</title> 
<publisherName>Signet</publisherName> 
<catalogImage>http://isbn.abebooks.com/mz/51/45/0451161351.jpg</catalogImage> 
<vendorName>Break Time Books</vendorName> 
<vendorLocation>Elgin, IL, U.S.A.</vendorLocation> 
<vendorId>54269886</vendorId> 
<sellerRating>5</sellerRating> 
<subjects> 
<subject>Fiction|Action & Adventure|Psychological</subject> 
<subject>Fiction|Mystery & Detective|Suspense</subject> 
</subjects> 
<bindingType>S</bindingType> 
</Book> 
<Book> 
<bookId>3136015627</bookId> 
<isbn10>0451161351</isbn10> 
<isbn13>9780451161352</isbn13> 
<listingCondition>NOT NEW BOOK</listingCondition> 
<itemCondition>Good</itemCondition>
<quantity>4</quantity> 
<vendorCurrency>USD</vendorCurrency> 
<listingPrice>1.0</listingPrice> 
<firstBookShipCost>2.95</firstBookShipCost> 
<extraBookShipCost>0.0</extraBookShipCost> 
<minShipDays>0</minShipDays> 
<maxShipDays>0</maxShipDays> 
<totalListingPrice>3.95</totalListingPrice> 
<listingUrl>www.abebooks.com/servlet/BookDetailsPL?bi=3136015627&cm_ven=sws&cm_cat=sws&cm_pla=sws&cm_ite=3136015627</listingUrl> 
<author>Stephen King</author> 
<title>Cujo</title> 
<publisherName>Signet (MM)</publisherName> 
<catalogImage>http://isbn.abebooks.com/mz/51/45/0451161351.jpg</catalogImage> 
<vendorName>Blue Cloud Books</vendorName> 
<vendorLocation>Phoenix, AZ, U.S.A.</vendorLocation> 
<vendorId>55521360</vendorId> 
<sellerRating>5</sellerRating> 
<bindingType>S</bindingType> 
</Book> 
<Book> 
<bookId>6557267724</bookId> 
<isbn10>0451161351</isbn10> 
<isbn13>9780451161352</isbn13> 
<listingCondition>NOT NEW BOOK</listingCondition> 
<itemCondition>Good</itemCondition> 
<quantity>1</quantity> 
<vendorCurrency>USD</vendorCurrency> 
<listingPrice>1.0</listingPrice> 
<firstBookShipCost>2.62</firstBookShipCost> 
<extraBookShipCost>0.0</extraBookShipCost> 
<minShipDays>0</minShipDays> 
<maxShipDays>0</maxShipDays> 
<totalListingPrice>3.62</totalListingPrice> 
<listingUrl>www.abebooks.com/servlet/BookDetailsPL?bi=6557267724&cm_ven=sws&cm_cat=sws&cm_pla=sws&cm_ite=6557267724</listingUrl> 
<author>Stephen King</author> 
<title>Cujo</title> 
<publisherName>Signet</publisherName> 
<catalogImage>http://isbn.abebooks.com/mz/51/45/0451161351.jpg</catalogImage> 
<vendorName>OwlsBooks</vendorName> 
<vendorLocation>Hammond, IN, U.S.A.</vendorLocation> 
<vendorId>51218811</vendorId> 
<sellerRating>5</sellerRating> 
<subjects> 
<subject>Fiction|Action & Adventure|Psychological</subject> 
<subject>Fiction|Mystery & Detective|Suspense</subject> 
</subjects> 
<bindingType>S</bindingType> 
</Book> 
</searchResults> 

I created a class object like this:
Imports System.Xml.Serialization 
Public Class SearchResults 
Public Property resultCount As Integer 
Public Property Books() As New List(Of Book) 
End Class
Public Class Book 
Public Property bookID As String 
Public Property isbn10 As String 
Public Property isbn13 As String 
Public Property listingCondition As String 
Public Property quantity As Integer 
Public Property vendorCurrency As String 
Public Property listingPrice As Double 
Public Property firstBookShipCost As Double 
Public Property extraBooKShipCost As Double 
Public Property minShipDays As Integer 
Public Property maxShipDays As Integer 
Public Property totalListingPrice As Double 
Public Property listingURL As String 
Public Property author As String 
Public Property title As String 
Public Property publisherName As String 
Public Property catalogImage As String 
Public Property vendorName As String 
Public Property vendorLocation As String 
Public Property vendorID As String 
Public Property sellerRating As Integer 
Public Property bindingType As String 
End Class
And I added deserialization logic like this:
Dim response As WebResponse = request.GetResponse() 
Dim data As Stream = response.GetResponseStream 
Dim stream As New StreamReader(data)
Dim reader As XmlTextReader = New XmlTextReader(stream)
Dim books As SearchResults 
Dim xmlSerializer As XmlSerializer = New XmlSerializer(GetType(SearchResults)) 
books = CType(xmlSerializer.Deserialize(stream), searchResults)
I receive an error There is an error in XML document(1,1) on the books = CType... line and not sure where the problem is. The XML looks just fine and I can run through the elements using other methods.
I have also attempted to create an XSD and class using the XSD utility and that did not work.
I can deserialize simple single node XML files, however Im getting messed up with resultCount and the nested Books.
Can someone take a peek at the XML and my example code to see what I need to do?

View the full article

Deserialize XML into class object

EDN Admin

Well-known member