Retrieve XML file from MSSQL

Hi Everyone,

How to retrieve a XML file from MSSQL using a stored procedure in asp.net ?

Thanks,
may

Check this:

http://www.sqldbatips.com/showarticle.asp?ID=23

this will help to generate a xml file than leater from your asp.net app u can read.

Or u can use the power of SQL to generate xml than from asp.net page to manipulate that xml (save edit...) examle:

create procedure usp_getXMLasselect *from ordersfor xml auto

i hope this will help u..

Sorry for my bad english