MS SQL2005 Query/Stored Proc Results To Text using SqlCommand or such

Question

I have a simple question.

I need to return results as simple text, either as a string or similar.

ie I want the same behaviour such as

Results to Text (Cntrl + T)

when you run a Query from SQL Server Management Studio.

How can this be done programatically against calling a Stored Proc from C#?

ie similar to ExecuteReader(); or ExecuteXMLReader(); but returning a string instead.

Is there some ToString() available?

Thanks, Kai.

Answer 1

No, you will have to build the sting yourself by reading from dbreader.