How to read XML data from a table

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Girish Bhat Ten Centuries Points: 1323 More actions · Answer 1

Get the XML into a string variable on the VB.NET side and then use:

Dim objDS As DataSet

Dim objXMLReader As StringReader

Dim strXML As String

objXMLReader = New StringReader(strXML)

objDS = New DataSet

objDS.ReadXml(objXMLReader)

Vijaya Kadiyala SSCrazy Eights Points: 9149 More actions · Answer 2

Hi

In addition to the above, When you store XML in nText datatype do you validate this in any Business Layer with a XSD?

Thanks -- Vijaya Kadiyala
www.dotnetvj.com
SQL Server Articles For Beginers

Cookies on SQLServerCentral