Hi,
Capturing the output from print statements will be somewhat more difficult.
IIRC ADO had a special collection that contains these messages in its
command object. Can't find (or overlooked) that same functionality in .NET.
As the output gets to stdout when you call the sp from the console, you
might want to try to redirect standard output to a stream and read the
results from there.
You'll have to do some more digging work on this !
Erik
"Sunny" <su***@newsgroups.nospam> wrote in message
news:eU**************@TK2MSFTNGP10.phx.gbl...
In article <ce**********@news3.tilbu1.nb.home.nl>,
ne********@NeOtammiSnPgAaM.nl says... Hi,
IIRC, you can add a parameter with ParameterDirection.Return to the
command that's calling the storedprocedure. Retrieving the return value can then
be done by reading the value of the passed parameter.
Erik
Hi,
and do you know a way to get the output of the PRINT statements from the
SP?
Thanks
Sunny