read XML out of a DataSet

[jdperroset]

Hi,

I have a SQL server stored procedure returning a XML result (using FOR
XML EXPLICIT clause). Does somebody know how to get the XML string
from an ADO DataSet? I made a TableAdapter to access the stored
procedure and in the design window I can use "Preview Data..." and it
shows me the xml result string. In know I'm near from success, but how
to reach it?

Thanks for your help

J-D

 

[sloan]

DataSet ds = new DataSet();
string x = ds.GetXml();