Problem retrieving data from Stored Procedure from SQL 2005

[Prasad]

Hi,
I am creating a stored procedure which contains an output parameter.
Though the procedure is getting compiled properly I am not able to
execute it from within SQL Server Management Studio and also through
an aspx page. I keep getting empty output (not null)

The code:


Create procedure LoginUser


@cust_Password varbinary,
@cust_name varchar,
@cust_id int output


AS


BEGIN


SELECT @cust_id=Id from Customer where Name=@cust_name and
Password=@cust_ Password;


END


How can I retreive the value @cust_id ?

[Munna]

Re: Problem retrieving data from Stored Procedure from SQL 2005

On May 27, 3:35 pm, Prasad <mahashabdepra. ..@gmail.comwro te:

Hi,
I am creating a stored procedure which contains an output parameter.
Though the procedure is getting compiled properly I am not able to
execute it from within SQL Server Management Studio and also through
an aspx page. I keep getting empty output (not null)
>
The code:
>
Create procedure LoginUser
>
@cust_Password varbinary,
@cust_name varchar,
@cust_id int output
>
AS
>
BEGIN
>
SELECT @cust_id=Id from Customer where Name=@cust_name and
Password=@cust_ Password;
>
END
>
How can I retreive the value @cust_id ?

Hi

check out this thread, just check the last message

http://forums.asp.net/p/1208409/2362152.aspx

here is a good article that demonstrate Using Output Parameters

http://aspnet.4guysfromrolla.com/articles/062905-1.aspx

Best of luck

Munna

https://www.munna.shatkotha.com

https://www.munna.shatkotha.com/blog

https://www.shatkotha.com

[SoftLion]

Re: Problem retrieving data from Stored Procedure from SQL 2005

Use
SELECT Id from Customer where Name=@cust_name and
Password=@cust_ Password;

And call ExecuteScalar