I need to read data from an XML file and am struggling to loop through the different levels.
Program loops through the first Mix record but not subsequent ones.
In this case the XML is in levels - I need information for each Component but also need related info from the mix. I have tried many variations on reading this but carn't get it to loop through correctly. There could be multiple jobs and mixes for each job.
Be glad of any help on this or direction - XML file attached and my vb code below:-
Dim settings As New XmlReaderSettings
settings.IgnoreWhitespace = True
settings.IgnoreComments = True
Dim xmlIn As XmlReader = XmlReader.Create("Test.xml", settings)
Dim intCounter As Integer
Dim strCode As String = ""
Dim strStkCode As String = ""
Dim intMixCounter As Integer
Dim intCompCount As Integer
Dim strJobNo As String = ""
Dim dblWeight As Double = 0
Dim strMixDate As String
If xmlIn.ReadToDescendant("Job") Then
If xmlIn.ReadToDescendant("Mix") Then
intMixCounter = (xmlIn.ReadElementString("MixCounter"))
strCode = (xmlIn.ReadElementString("MixJobNumber"))
strMixDate = (xmlIn.ReadElementString("MixedDate"))
intCompCount = (xmlIn.ReadElementString("ComponentCount"))
If xmlIn.ReadToDescendant("Component") Then
intCounter = (xmlIn.ReadElementString("ComponentCounter"))
dblWeight = (xmlIn.ReadElementString("ComponentKG"))
'Will write code here using info on each component / mix
Loop While xmlIn.ReadToNextSibling("Component")
Loop While xmlIn.ReadToNextSibling("Mix")
Loop While xmlIn.ReadToNextSibling("Job")
End If Test3.xml
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
-Mike Kapnisakis, Warner Bros
With your subscription - you'll gain access to our exclusive IT community of thousands of IT pros. You'll also be able to connect with highly specified Experts to get personalized solutions to your troubleshooting & research questions. It’s like crowd-sourced consulting.
We can't always guarantee that the perfect solution to your specific problem will be waiting for you. If you ask your own question - our Certified Experts will team up with you to help you get the answers you need.
Our certified Experts are CTOs, CISOs, and Technical Architects who answer questions, write articles, and produce videos on Experts Exchange. 99% of them have full time tech jobs - they volunteer their time to help other people in the technology industry learn and succeed.
We can't guarantee quick solutions - Experts Exchange isn't a help desk. We're a community of IT professionals committed to sharing knowledge. Our experts volunteer their time to help other people in the technology industry learn and succeed.