Booster1977
New member
- Joined
- Jan 23, 2012
- Messages
- 3
- Programming Experience
- 1-3
Hello everyone,
I have a problem regarding parsing XML that I've been fighting with for weeks now and can't seem to resolve. I've read every tutorial and every question on the website here, but either I don't understand it or I want something very special. So you guys are my last hope. I'll state my question as clear as possible.
I request information from a webservice and this webservice gives me an XML reply. I run this XML through a XSLT stylesheet to format it more clearly. After this all I want (and need) to do is get the values out of the XML (String, not file) and store them in a database. The first part is a problem for me, I can't seem to get the individual values out of the string. The XML String looks as follows:
I just pasted a part of the XML otherwise my post would become too long, but it's important to know there are multiple <openstaandepost></openstaandepost> that hold the exact same entries, but different data between <Veldnaam> and <Waarde> of course.
I need to get the value of each <Veldnaam> and the <Waarde> in each entry, so I can do a query on it.
I've tried everything and nothing seems to work the way I need it to. Maybe I'm trying stuff that is too difficult. If anyone could help me I would be forever grateful.
Thank you so much in advance!
I have a problem regarding parsing XML that I've been fighting with for weeks now and can't seem to resolve. I've read every tutorial and every question on the website here, but either I don't understand it or I want something very special. So you guys are my last hope. I'll state my question as clear as possible.
I request information from a webservice and this webservice gives me an XML reply. I run this XML through a XSLT stylesheet to format it more clearly. After this all I want (and need) to do is get the values out of the XML (String, not file) and store them in a database. The first part is a problem for me, I can't seem to get the individual values out of the string. The XML String looks as follows:
VB.NET:
<openstaandeposten>
<openstaandepost>
<Entry>
<Veldnaam>fin.trs.line.dim2</Veldnaam>
<Waarde>01249</Waarde>
</Entry>
<Entry>
<Veldnaam>fin.trs.line.openbasevaluesigned</Veldnaam>
<Waarde>-100.00</Waarde>
</Entry>
<Entry>
<Veldnaam>fin.trs.line.basevaluesigned</Veldnaam>
<Waarde>-123.00</Waarde>
</Entry>
<Entry>
<Veldnaam>fin.trs.line.invnumber</Veldnaam>
<Waarde>12345</Waarde>
</Entry>
<Entry>
<Veldnaam>fin.trs.head.code</Veldnaam>
<Waarde>INK</Waarde>
</Entry>
<Entry>
<Veldnaam>fin.trs.line.matchdate</Veldnaam>
<Waarde>20111025</Waarde>
</Entry>
<Entry>
<Veldnaam>fin.trs.line.datedue</Veldnaam>
<Waarde>20100513</Waarde>
</Entry>
</openstaandepost>
</openstaandeposten>
I just pasted a part of the XML otherwise my post would become too long, but it's important to know there are multiple <openstaandepost></openstaandepost> that hold the exact same entries, but different data between <Veldnaam> and <Waarde> of course.
I need to get the value of each <Veldnaam> and the <Waarde> in each entry, so I can do a query on it.
I've tried everything and nothing seems to work the way I need it to. Maybe I'm trying stuff that is too difficult. If anyone could help me I would be forever grateful.
Thank you so much in advance!