Re: What is the thoughtful process behind it? SqlDataReader.NextResult Method

Hi John,

Check next KB with an example

http://support.microsoft.com/kb/308049/EN-US/

--
Val Mazur
Microsoft MVP

http://xport.mvps.org



"John Smith" <JSmith_SJ@xxxxxxxxxxx> wrote in message
news:eWzOC%23RQFHA.3628@xxxxxxxxxxxxxxxxxxxxxxx
>
>
> I am using .NetFramework 1.1. and SQL2K.
>
> I am calling a stored procedure and it has multiple results set and some
> output parameters.
>
> If the output parameter does not meet certain condition, I am quitting the
> stored procedure (SP) by calling "return" statement which results in SP
> not
> returning any result set further.
>
>
>
> Since output parameters of the stored procedure is the last result set in
> a
> data reader, my code has to process the result set first and then output
> result set.
>
>
>
> What is the thoughtful process behind making output parameters of a stored
> procedure as the last result set in a datareader?
>
> Thanks,
>
> John
>
>


.

Relevant Pages

  • Re: DBD::Sybase and $sth->{syb_result_type} v. DBD::ODBC (Sql Server)
    ... write output parameters and return a value. ... individual operations in the procedure by calling odbc_more_results. ... Things get a little more complex for what I guess Sybase calls CS_MSG_RESULT ... the status from a stored procedure was ...
    (perl.dbi.users)
  • RE: output parameters not working in if return resultset
    ... > Hi Charts, ... output parameters not working in if return resultset ... > | I am calling a stored procedure in SQL Server to return resultset to fill ...
    (microsoft.public.dotnet.framework.aspnet.datagridcontrol)
  • RE: output parameters not working in if return resultset
    ... output parameters not working in if return resultset ... | I am calling a stored procedure in SQL Server to return resultset to fill ...
    (microsoft.public.dotnet.framework.aspnet.datagridcontrol)
  • What is the thoughtful process behind it? SqlDataReader.NextResult Method
    ... I am calling a stored procedure and it has multiple results set and some ... Since output parameters of the stored procedure is the last result set in a ... What is the thoughtful process behind making output parameters of a stored ...
    (microsoft.public.dotnet.framework.adonet)
  • DataReader... and ...
    ... the stored procedure by calling "return" statement which results ... Since output parameters of the stored procedure is the last result set ... What is the thoughtful process behind making output parameters of a ...
    (microsoft.public.dotnet.framework.aspnet)