Read XML data from SQL 2005 table

[nilaangel78]

Hi All,

I have SQL 2005 table with columns TypeId(int) & Description(nte xt datatype).
The Description column has XML file content as value in the table.
Now i want to read the data into a dataset in VB.Net. How to do it in VB.Net. I am using Winforms and VB.Net in VS 2005.

Please help me.

Thanks

Nila

[MrMancunian]

Hi, I wrote an Insight on this topic. Unless you want to do something additional with the XML, this should cover it. If not, please post some more info.

Steven