LINQ gets stored procedure return value problem my stored procedure

Little scum · Posted on 5/8/2015 4:27:29 PM

LINQ gets stored procedure return value issue
My stored procedure
IF OBJECT_ID('UpdatePassword') IS NOT NULL
DROP PROCEDURE UpdatePassword
GO
CREATE PROCEDURE UpdatePassword
@UserID VARCHAR(20),
@UserPassWord_Old VARCHAR(10),
@UserPassWord_New VARCHAR(10)
AS
BEGIN TRY
UPDATE RBC_Users SET UserPassWord=@UserPassWord_New
WHERE UserID=@UserID AND UserPassWord=@UserPassWord_Old
RETURN 1
END TRY
BEGIN CATCH
RETURN 0
END CATCH

I get it this way
DB_RBCDataContext pro = new DB_RBCDataContext();

int i = pro. UpdatePassword(Convert.ToInt32(Session["UserID"]), TextBox1.Text, TextBox3.Text);
Label1.Text = i.ToString();

The result obtained in this way is always 1, I think my stored procedure is wrong... Please help me take a look··
How to write the storage procedure for addition, deletion, and modification?

[ASP.NET] LINQ gets stored procedure return value problem my stored procedure

Related Posts

Sections viewed