Need to read xml from the database.

[Transcend]

Hi guys, i'm fairly stuck on this one!

I've been looking at MSXML2 in vb 6 to try and solve this one but haven't gotten very far so far!
Basically I am reading a recordset in from the database, and one of the fields is long text, that looks something like this:

<Parameters>
<Parameter>
<Name>Start</Name>
<Type>DateTime</Type>
</Parameter>
<Parameter>
<Name>End</Name>
<Type>DateTime</Type>
<Prompt>Last Date</Type>
</Parameter>

All i want to do is parse the XML and create a collection of 'parameters'.
I have created the classes and collections that i need, only thing now is how to I parse the XML and get the values out??

I'm really stuck, any help is appreciated.

Transcend

 

[Transcend]

Sorry that should have been

<Parameters>
<Parameter>
<Name>Start</Name>
<Type>DateTime</Type>
</Parameter>
<Parameter>
<Name>End</Name>
<Type>DateTime</Type>
<Prompt>Last Date</Type>
</Parameter>
</Parameters>

Transcend

 

[Transcend]

Ok finally figured it out! I needed to use the LoadXML method rather than the Load method.

Dim xmldoc As DOMDocument
Dim x As IXMLDOMNode
Dim y As IXMLDOMNode
Dim i As Integer


Set xmldoc = New DOMDocument
xmldoc.async = "false"
xmldoc.loadXML (Text1.Text)


Transcend