DataReader and Returned Parms

I have found that I am unable to read the parms until after I do a close on
the DataReader. Is that accurate?

In the instance where you are executing a procedure which returns multiple
answer sets, would this still be true?

So if I wanted to get the return value for each of the answer sets, I would
in the Procedure create a variable which would hold the RETURN_Value into
something like RETURN_VALUE1, RETURN_VALUE2....etc? Then after all the
answer sets have been returned I could then read the parameter return
values?

Thanks in Advance for your assistance....

Miha
Fri Dec 19 08:53:07 CST 2003

Hi Jim,

Yes, I think that you can read the return parameters only after you've read
all rows.

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

"Jim Heavey" <JimHeavey@nospam.com> wrote in message
news:Xns945657AD199C9JimHeaveyhotmailcom@207.46.248.16...
> I have found that I am unable to read the parms until after I do a close
on
> the DataReader. Is that accurate?
>
> In the instance where you are executing a procedure which returns multiple
> answer sets, would this still be true?
>
> So if I wanted to get the return value for each of the answer sets, I
would
> in the Procedure create a variable which would hold the RETURN_Value into
> something like RETURN_VALUE1, RETURN_VALUE2....etc? Then after all the
> answer sets have been returned I could then read the parameter return
> values?
>
> Thanks in Advance for your assistance....

bruce
Fri Dec 19 11:22:38 CST 2003

mostly correct, the parameters are returned after all result sets, you don't
need to close, just read all rows, for all result sets first (see
NextResult())

-- bruce (sqlwork.com)

"Jim Heavey" <JimHeavey@nospam.com> wrote in message
news:Xns945657AD199C9JimHeaveyhotmailcom@207.46.248.16...
> I have found that I am unable to read the parms until after I do a close
on
> the DataReader. Is that accurate?
>
> In the instance where you are executing a procedure which returns multiple
> answer sets, would this still be true?
>
> So if I wanted to get the return value for each of the answer sets, I
would
> in the Procedure create a variable which would hold the RETURN_Value into
> something like RETURN_VALUE1, RETURN_VALUE2....etc? Then after all the
> answer sets have been returned I could then read the parameter return
> values?
>
> Thanks in Advance for your assistance....

William
Fri Dec 19 14:39:43 CST 2003

Check out Bill Vaughn's article Retrieving the Gozoutas
http://www.betav.com/msdn_magazine.htm
"Jim Heavey" <JimHeavey@nospam.com> wrote in message
news:Xns945657AD199C9JimHeaveyhotmailcom@207.46.248.16...
> I have found that I am unable to read the parms until after I do a close
on
> the DataReader. Is that accurate?
>
> In the instance where you are executing a procedure which returns multiple
> answer sets, would this still be true?
>
> So if I wanted to get the return value for each of the answer sets, I
would
> in the Procedure create a variable which would hold the RETURN_Value into
> something like RETURN_VALUE1, RETURN_VALUE2....etc? Then after all the
> answer sets have been returned I could then read the parameter return
> values?
>
> Thanks in Advance for your assistance....