Parsing XML from DB

[LochDhu]

I have a VARCHAR2 field in SQL Server holding XML. I need to query that field and parse the contents with, I assume, either an XMLDocument or XMLTextReader. Does anyone have any suggestions on how to approach this. The query part is no problem - it's how to take the contents and build an XMLDocument or XMLTextReader object.

Thanks,

Scott

 

[LochDhu]

I answered my own question.

Dim xmlDoc As New System.Xml.XmlDocument
xmlDoc.LoadXml(ds.Tables(0).Rows(0).Item(1).ToString)

Scott

 

[ThatRickGuy]

I am a lazy person, I make the DataSet object do all my XML writing for me

-Rick

----------------------

http://www.ringdev.com