asp.net > get the result from a SP (in xml, FOR XML AUTO)

[bcardoso]

Hi,

I am using a SP, which has someting like (SELECT ... FROM ... WHERE ... FOR XML AUTO).
The result is in XML, but my question is: how can I retrive that XML (directly to a variable), to send it to the browser via ASP.NET.
I tried SqlDataReader and SqlDataAdapter, but without results.
Thanks,
Benjamim

 

[ronenhm]

Hi

as far as i understand you like to get the result XML and assign it to a string object ?

how about getting the result into dataset
and calling the ds.GetXml() method?


string SQL = "SELECT * FROM Customers FOR XML AUTO";

DataSet ds = SqlHelper.ExecuteDataset ("User ID=sa;Initial Catalog=Northwind;DataSource=LOCALHOST",CommandType.Text ,SQL );
string XML = ds.GetXml();

or you don't need the FOR XML AUTO
just use the ds.GetXml();

I hope that helps
ronen