Does anybody know how to convert xml field from SQL Query to Dataset?
For example I have a table T with Fields A(VARCHAR), B(INT), & C(XML).
Field C has <test><row>ROW 1</row><row>ROW 2</row></test>
I make a query to get this data and call this Dataset1
Now I want the Column C content to be converted into a dataset call it Dataset2 so that I can drag and drop tables from there to make my reports.
Is it possible to do it without using webservice?Another limitation I have, I should not have to connect to DB again, so this boils down to use the already data contained in Dataset1.
I was trying to somehow embed this XML content in the query at runtime dynamically?
I am currently looking for a way to use the Dataset1 as the datasource and and parse the XML content of Dataset1 to Dataset2.
Also, is it that XML content needs to hardcoded in the query, can't we do it dynamically and run the query?
View Complete Post