
Untitled
By: a guest on
Aug 1st, 2012 | syntax:
None | size: 1.23 KB | hits: 14 | expires: Never
Update aspnet membership password answer
user.ChangePasswordQuestionAndAnswer(password, question, answer);
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [dbo].[aspnet_Membership_ChangePasswordQuestionAndAnswer]
@ApplicationName nvarchar(256),
@UserName nvarchar(256),
@NewPasswordQuestion nvarchar(256),
@NewPasswordAnswer nvarchar(128)
AS
BEGIN
DECLARE @UserId uniqueidentifier
SELECT @UserId = NULL
SELECT @UserId = u.UserId
FROM dbo.aspnet_Membership m, dbo.aspnet_Users u, dbo.aspnet_Applications a
WHERE LoweredUserName = LOWER(@UserName) AND
u.ApplicationId = a.ApplicationId AND
LOWER(@ApplicationName) = a.LoweredApplicationName AND
u.UserId = m.UserId
IF (@UserId IS NULL)
BEGIN
RETURN(1)
END
UPDATE dbo.aspnet_Membership
SET PasswordQuestion = @NewPasswordQuestion, PasswordAnswer = @NewPasswordAnswer
WHERE UserId=@UserId
RETURN(0)
END
public virtual bool ChangePassword(string oldPassword, string newPassword)
string newPassword = user.ResetPassword();
user.ChangePassword(newPassword, "SOMENEWPASSWORD");
user.ChangePasswordQuestionAndAnswer("SOMENEWPASSWORD", question, answer);