How to write XML from a SQL Server query, to a ASP.NET textBox

[drlexkingdome]

I'm trying to do this:

-------------------------------------
1) Have SQL server return some data from this
simple stored procedure. It returns XML:

SELECT * FROM eAccessTypes
FOR XML AUTO

-------------------------------------
2) In my C# I capture the return value in
an XmlReader like so:

XmlReader xmlr = mySqlCommand.ExecuteXmlReader();

-------------------------------------
3) But I cant figure out how to get the xml
from the XmlReader and into a string
variable so I can just display it on a
web page. ? Please Help!

I've found many examples that show how to write the xml to a file or to
a stream, but not just to a simple string variable. Any help with code
examples would be a godsend! Thanks!

 

[Mark McIntyre]

I'm trying to do this:

(lots of stuff which has ZERO to do with C)

You're in the wrong place. Try one of hte MS programming groups.