SqlDataReader and Return Value

[Binny]

I have a stored procedure which returns a recordset and
also returns a value.
I know how to access the recordset.
How can i access the integer value returned by the stored
procedure

Iam using SqlCommand.ExecuteReader

thanks

 

[Carl Prothman [MVP]]

I have a stored procedure which returns a recordset and
also returns a value.
I know how to access the recordset.
How can i access the integer value returned by the stored
procedure

Binny,
You must Close the SqlDataReader after getting the rows,
then get the Return value.

For more information, see
http://support.microsoft.com/default.aspx?scid=kb;en-us;308049


--

Thanks,
Carl Prothman
Microsoft ASP.NET MVP
http://www.able-consulting.com

 

[Binny]

Thanks Carl

-----Original Message-----


Binny,
You must Close the SqlDataReader after getting the rows,
then get the Return value.

For more information, see
http://support.microsoft.com/default.aspx?scid=kb;en- us;308049


--

Thanks,
Carl Prothman
Microsoft ASP.NET MVP
http://www.able-consulting.com



.