Hi all, I have something below stored in my sql server 2008 xml datatype column:

<Product_ID>A</Product_ID><Product_Name>Oil</Product_Name>


How can i read the xml from sql server into datatable become something like this:

Product_ID Product_Name
A Oil