plz help XML parsing

Question

Hi  I am very new to programming in XML. THe following is my XML document that i have to parse. I need to take all the values of all the elements and store them for later processing into database. could any please provide me the code which does this functionality in vb.net sample o/p: storenum = 998 date = 20040513 time = 142343 passport=order 998 20040513 142343 123456 Order C BOB'S REPAIR SHOP 8014957925 9014597927 123 South Front Street Memphis TN 38103 000113 00567 1234567898723 99999 0000010.95 000113 00567 1234567898723 99999 0000010.95

anoo_paturi · Answer

Try this code.I've given a sample and it should work. Hope u can continue from there Dim pcontent As XmlDocument Dim preader As XmlTextReader Dim proot As XmlNode Dim pelem As XmlElement Dim pchildelem As XmlElement preader = New XmlTextReader(xml filename) pcontent = New XmlDocument pcontent.Load(preader) proot = pcontent.FirstChild If proot.HasChildNodes Then Dim i As Integer For i = 0 To proot.ChildNodes.Count - 1 If proot.ChildNodes(i).Name.ToString.Equals(Header) Then pelem = proot.ChildNodes(i) If (pelem.HasChildNodes) Then Dim j As Integer For j = 0 To pelem.ChildNodes.Count - 1 If pelem.ChildNodes(j).Name.ToString.Equals(storenum) Then pchildelem = pelem.ChildNodes(j) msgbox( pchildelem.InnerText.ToString()) . . End If Next End If End If Next i End If