Return Value from SqlCommand in ASP.Net

[Adhik]

Hi,

My application has frontend in ASP.Net, middle tier in vb.Net and backend
SQL Server.

I have created one function in Middle tier for adding any records by passing
Procedure Name and Parameters Array.
Here i am using SQLCommnd Object to Call procedure, to take return value
i.e. Id or flag of successful insert/update, I have added one
@retVal as integer as OUTPUT parameter. But if i didn't declare this @retVal
parameter in Procedure as OTUPUT parameter, then it gives error.

Before this is ASP and VB as middle tier, I dont need to declare output
parameter in procedure, just i have to call retrun at end of procedure which
retrun the reqired value.

What should i have to do this same to work with ASP.Net.

Hoping some solution.

Regards
Adhik

[Patrick Steele [MVP]]

In article <eu$6JedTDHA.1556@TK2MSFTNGP10.phx.gbl>, [email]adhik@hotpop.com[/email]
says...

> Hi,
>
> My application has frontend in ASP.Net, middle tier in vb.Net and backend
> SQL Server.
>
> I have created one function in Middle tier for adding any records by passing
> Procedure Name and Parameters Array.
> Here i am using SQLCommnd Object to Call procedure, to take return value
> i.e. Id or flag of successful insert/update, I have added one
> @retVal as integer as OUTPUT parameter. But if i didn't declare this @retVal
> parameter in Procedure as OTUPUT parameter, then it gives error.
>
> Before this is ASP and VB as middle tier, I dont need to declare output
> parameter in procedure, just i have to call retrun at end of procedure which
> retrun the reqired value.
>
> What should i have to do this same to work with ASP.Net.

See:

"HOW TO: Call a Parameterized Stored Procedure by Using ADO.NET"
[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;308049[/url]

--
Patrick Steele
Microsoft .NET MVP
[url]http://weblogs.asp.net/psteele[/url]