>I need a code sample that I can use that shows how to return XML from a stored proc in SQL Server 2000 into a variable in C#/ASP.Net.
>
>I have already written a SPOC that produces the XML I want.
>
>Thanks.

Use the sqlxml managed classes. Here is a great article on the subject.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sqlxml_intromanagedclasses.asp

BOb