Use Command.ExecuteXMLReader() to retrieve the XML. You'll probably have to use a combination of XmlTextWrite, StringWriter, and StringBuilder to get the XML into a string.

-Mike

>Can you recommend code that I could use from C# in ASP.Net?
>
>For example how do I call a SPROC that returns XML to a C# variable.
>
>ie..
>
>var = Command.ExecuteNonQuery().
>
>Such that var ends up with XML from the sproc that uses the FOR XML....