DataReader... and ...

From: "John Smith" <JSmith_SJ@xxxxxxxxxxx>
Date: Thu, 14 Apr 2005 13:03:59 -0700

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

.

Follow-Ups:
- Re: DataReader... and ...
  - From: William F. Robertson, Jr.

Prev by Date: Re: where does Console.WriteLine() goto in a web app?
Next by Date: generic object referance
Previous by thread: Vertical alignment of textbox in edititemtemplate
Next by thread: Re: DataReader... and ...
Index(es):
- Date
- Thread

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)
Re: What is the thoughtful process behind it? SqlDataReader.NextResult Method
... > stored procedure by calling "return" statement which results in SP ... > Since output parameters of the stored procedure is the last result set in ... > What is the thoughtful process behind making output parameters of a stored ...
(microsoft.public.dotnet.framework.adonet)