See my article at
http://www.betav.com/msdn_magazine.htm that discusses
parameters passed back from a SP.
Just remember that OUTPUT parameters are past last in the TDS stream. You
need (therefore) to complete rowset population before they are available.
This means closing the DataReader or using Fill to process the rowset.
hth
--
____________________________________
Bill Vaughn
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Manivesa" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I have a Stored Procedure in SQL server that returns an output
> parameter and a cursor. I prepare a sqlcommand with the input
> parameters and all works fine except that if I use
> sqlcommand.executereader the output parameters contains nothing and if
> I use sqlcommand.executenonquery I do not have the rows my stored
> procedure returns.
>
> Anybody can help??
>
>
> Thanks in advance.
Similar Threads
