«

I have a stored procedure which is returning an int. Could you
pleasde give me ADO.Net code that how can I retrieve the returning
value from from stored procedure in aspx page and put that returning
value in a variable.

Thanks

<> wrote in message
news: ups.com...

>I have a stored procedure which is returning an int. Could you
> pleasde give me ADO.Net code that how can I retrieve the returning
> value from from stored procedure in aspx page and put that returning
> value in a variable.

There's something wrong with your newsreader - it' just posted this in a new
thread...


--
http://www.markrae.net

SqlComand comm = new SqlCommand(connection);
comm.Text = @"

declare @res int
execute @res = spYouStoredProcedure @YourParameter = <yourvalue>
select @res"
);
int res = comm.ExecuteScalar();



> I have a stored procedure which is returning an int. Could you
> pleasde give me ADO.Net code that how can I retrieve the returning
> value from from stored procedure in aspx page and put that returning
> value in a variable.
>
> Thanks
>