Parse XML Response String And Get Usable Variables

[pjgoodi]

Hi,

I'm new to VB.net and totally new to XML. I am building a program that receives a response to a XML inquiry from hwresponse.GetResponseStream. So far I have been able to submit the request and receive a response. I now need take that response (in the form of a string) and convert it to a format which will allow me to make decisions based on it. Perhaps by creating dataset/datatable and passing to variables.

My rough idea would be to create a new row for each lineid corresponding to an articleid with dates etc then loop.

I've spent days Googling an can't find anything in VB.net that fits. I know this is down to my lack of knowledge and a tiny brain. I would be eternally grateful to anyone who could help.

The response is a reply to a stock enquiry:


<?xml version="1.0" encoding="UTF-8" ?>
<ew:quote_A2 xmlns:ew="http://www.reifen.net">
<DocumentID>A2</DocumentID>
<Variant>5</Variant>
<ErrorHead>
<ErrorCode>0</ErrorCode>
</ErrorHead>
<BuyerParty>
<PartyID>305026</PartyID>
<AgencyCode>91</AgencyCode>
</BuyerParty>
<OrderLine>
<LineID>10</LineID>
<OrderedArticle>
<ArticleIdentification>
<ManufacturersArticleID>520654</ManufacturersArticleID>
<EANUCCArticleID>5452000877154</EANUCCArticleID>
</ArticleIdentification>
<ArticleDescription>
<ArticleDescriptionText>205/55R16 91H OPTIGRIP FP</ArticleDescriptionText>
</ArticleDescription>
<Availability>3</Availability>
<RequestedQuantity>
<QuantityValue>200</QuantityValue>
</RequestedQuantity>
<Error>
<ErrorCode>0</ErrorCode>
</Error>
<ScheduleDetails>
<DeliveryDate>9999-12-31</DeliveryDate>
<AvailableQuantity>
<QuantityValue>200</QuantityValue>
</AvailableQuantity>
</ScheduleDetails>
</OrderedArticle>
</OrderLine>
<OrderLine>
<LineID>10</LineID>
<OrderedArticle>
<ArticleIdentification>
<ManufacturersArticleID>522794</ManufacturersArticleID>
<EANUCCArticleID>5452001082922</EANUCCArticleID>
</ArticleIdentification>
<ArticleDescription>
<ArticleDescriptionText>205/55R16 91H UG 8 MS FP</ArticleDescriptionText>
</ArticleDescription>
<Availability>2</Availability>
<RequestedQuantity>
<QuantityValue>200</QuantityValue>
</RequestedQuantity>
<Error>
<ErrorCode>0</ErrorCode>
</Error>
<ScheduleDetails>
<DeliveryDate>2013-02-04</DeliveryDate>
<AvailableQuantity>
<QuantityValue>5</QuantityValue>
</AvailableQuantity>
</ScheduleDetails>
<ScheduleDetails>
<DeliveryDate>9999-12-31</DeliveryDate>
<AvailableQuantity>
<QuantityValue>195</QuantityValue>
</AvailableQuantity>
</ScheduleDetails>
</OrderedArticle>
</OrderLine>
</ew:quote_A2>

[AceInfinity]

Look into the XmlReader class: http://msdn.microsoft.com/en-US/libr...=VS.80%29.aspx