executereader not returning parameters

Just a note, but are you making sure to close the
DataReader from the ExecuteDataReader call before you try
to access your output parameters? The output parameters
are the last thing returned by the server, so the stream
has to be closed out before it will pick up the returned
values.

>-----Original Message-----
>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.
>.
>