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

[John Smith]

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

 

[Val Mazur \(MVP\)]

Hi John,

Check next KB with an example

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