C# get stored procedure printed text

Asked Sep 21 '13 at 23:10

Active Sep 21 '13 at 23:10

Viewed 154 times

I'm having a stored procedure that returns printed text. E.g

To import this report into Excel (and preserve leading zeros in numbers, etc):

Click here, then press CTRL-A, CTRL-C.
Open Excel, press CTRL-A, right-click mouse, select Format Cells, click Text.
Click on A1 cell, press SHIFT-INS to paste.

REPORT FOR 21-09-2013

Date Who Total 21-09-2013 ALBERT 10

So i want to be able to retrieve this text from my C# application. I've tried to retrieve it via ExecuteScalar() and ExecuteReader() but no luck. Is there any other alternative to solve this problem ?

asked Sep 21 '13 at 23:10

chosenOne Thabs

1,480
3
21
39

1

How does that SP returns printed text? Does it run SELECT statement or simple uses PRINT at the end? – Yuriy Galanter Sep 21 '13 at 23:14
If the later - take a look at http://stackoverflow.com/a/1880507/961695 – Yuriy Galanter Sep 21 '13 at 23:31
@Yuriy It loops through a CURSOR. Inside the while loop it prints values. – chosenOne Thabs Sep 22 '13 at 12:03
This link(stackoverflow.com/a/1880507/961695) helped. Thanks Yuriy – chosenOne Thabs Sep 22 '13 at 12:15
Possible duplicate of [Capture Stored Procedure print output in .NET](http://stackoverflow.com/questions/1880471/capture-stored-procedure-print-output-in-net) – pmcilreavy Nov 04 '16 at 05:25

C# get stored procedure printed text

0 Answers0