How to change user name in ASP.NET 2.0 Membership Provider

re: How to change user name in ASP.NET 2.0 Membership Provider

Marwan Roushdy — Wed, 19 Aug 2009 13:50:15 GMT

Here is a C# version of Doug's plus corrected some issues regarding finding the username because sometimes it could not be available in web.config.

///////////////////////

public class utils

{

public static bool ChangeUserName(string oldUserName,string newUserName)

{

bool IsSuccsessful = false;

string ApplicationName;

if(IsUserNameValid(newUserName))

{

if ((ConfigurationManager.ConnectionStrings["applicationName"] == null) || String.IsNullOrEmpty(ConfigurationManager.ConnectionStrings["applicationName"].ToString()))

{ApplicationName = System.Web.Hosting.HostingEnvironment.ApplicationVirtualPath;}

else

{ ApplicationName = ConfigurationManager.ConnectionStrings["applicationName"].ToString(); }

SqlConnection myConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationServices"].ToString());

SqlCommand cmdChangeUserName= new SqlCommand();

cmdChangeUserName.CommandText="dbo.aspnet_Membership_ChangeUserName";

cmdChangeUserName.CommandType = CommandType.StoredProcedure;

cmdChangeUserName.Connection = myConn;

cmdChangeUserName.Parameters.Add("@ApplicationName", SqlDbType.NVarChar);

cmdChangeUserName.Parameters.Add("@OldUserName", SqlDbType.NVarChar);

cmdChangeUserName.Parameters.Add("@NewUserName", SqlDbType.NVarChar);

cmdChangeUserName.Parameters["@ApplicationName"].Value = ApplicationName;

cmdChangeUserName.Parameters["@OldUserName"].Value = oldUserName;

cmdChangeUserName.Parameters["@NewUserName"].Value = newUserName;

try

{

myConn.Open();

cmdChangeUserName.ExecuteNonQuery();

myConn.Close();

IsSuccsessful = true;

}

catch(Exception ex )

{IsSuccsessful = false;}

}

else{IsSuccsessful = false;}

return IsSuccsessful;

}

private static bool IsUserNameValid(string username)

{

//Add whatever username requirement validation you want here, doesnt

//the membership provider have some build in functionality for this?

return true;

}

re: How to change user name in ASP.NET 2.0 Membership Provider

D-Ball — Fri, 20 Feb 2009 09:58:54 GMT

Here is the VB version of Thomas' code...

1. Make sure New UserName is Unique

2. Update the aspnet_Users table directly

3. Execute to following code to change the username/cookie/identity without leaving the webpage...

' Obtains the name of the FormsAuthentication Cookie, uses that name to request the Cookie and Decrypts the Cookies information into a AuthTicket

Dim AuthTicket As FormsAuthenticationTicket = FormsAuthentication.Decrypt(HttpContext.Current.Request.Cookies(FormsAuthentication.FormsCookieName).Value)

' Instantiates a new user identity authenticated using forms authentication based on the FormsAuthenticationTicket.

' The FormsAuthenticationTicket has been created using the exact same parameters of the user with the Old Username except the Old Username has been updated with the New Username.

Dim NewFormsIdentity As New FormsIdentity(New FormsAuthenticationTicket(AuthTicket.Version, NewUsername, AuthTicket.IssueDate, AuthTicket.Expiration, AuthTicket.IsPersistent, AuthTicket.UserData))

' Parse out the AuthTicket's UserData into a string array of Roles

Dim Roles As String() = AuthTicket.UserData.Split("|".ToCharArray)

' Creates a new user that has the NewFormsIdentity and belongs to the array of Roles, if any, that was stored in the FormsAuthenticationTicket

Dim NewGenericPrincipal As New System.Security.Principal.GenericPrincipal(NewFormsIdentity, Roles)

' Sets the security information for the current HTTP request to the new user. The Username has now been changed (i.e. HttpContext.Current.User.Identity.Name = NewUsername, prior to this step is was the OldUsername)

HttpContext.Current.User = NewGenericPrincipal

' Removes the forms-authentication ticket from the browser

FormsAuthentication.SignOut()

' Cancels the current session

HttpContext.Current.Session.Abandon()

' Creates an authentication ticket for the supplied New Username and adds it to the cookies collection of the response or the URL

FormsAuthentication.SetAuthCookie(HttpContext.Current.User.Identity.Name, AuthTicket.IsPersistent)

4. Response.Redirect back to the same page if needed.

re: How to change user name in ASP.NET 2.0 Membership Provider

D-Ball — Fri, 20 Feb 2009 09:50:52 GMT

Thomas, your code works great. Thanks!

re: How to change user name in ASP.NET 2.0 Membership Provider

muadib — Thu, 11 Dec 2008 16:40:26 GMT

Thanks to Omar, Doug Taylor and Thomas

re: How to change user name in ASP.NET 2.0 Membership Provider

codebounce.com — Sun, 28 Sep 2008 11:23:11 GMT

Hellons!

I stumbled upon this and thought was very useful. My only concern as someone already pointed out: updating all references to the old id.

In spite of this, still useful.

I also bookmarked it:

www.codebounce.com/ASPNET

re: How to change user name in ASP.NET 2.0 Membership Provider

sweetpea-hk — Thu, 10 Jan 2008 22:49:14 GMT

<a href= http://gener4.com >golden valley cabin rentals</a>

Where is the ChangeUserName() function?

Dev by Doug — Thu, 15 Nov 2007 17:21:54 GMT

I recently built a site that uses the Microsoft ASP.NET Membership, Role and Profile providers (2.0 framework

re: How to change user name in ASP.NET 2.0 Membership Provider

Alexqgr — Thu, 15 Nov 2007 02:06:42 GMT

re: How to change user name in ASP.NET 2.0 Membership Provider

Alexwvg — Thu, 15 Nov 2007 02:06:38 GMT

re: How to change user name in ASP.NET 2.0 Membership Provider

Alexyqf — Thu, 15 Nov 2007 02:06:34 GMT

Where's the ChangeUserName() function?

Code Journal .NET — Tue, 13 Nov 2007 21:59:41 GMT

Where's the ChangeUserName() function?

Membership Provider: changing the username

re: How to change user name in ASP.NET 2.0 Membership Provider

Doug Taylor — Sun, 04 Nov 2007 02:54:26 GMT

Like the addition, but I'm guessing you do this because your front end has the user log in with their e-mail address and password: making the e-mail behave as if it was the username. For those of us still using the "out of the box" behavior, this isn't the case, so you you wouldn't necessarily want to overwrite the e-mail address with a username change.

However I wonder if that's a better way to go... probably easier for users to remember an e-mail address over a username, especially if they visit the site sporadically.

re: How to change user name in ASP.NET 2.0 Membership Provider

FM — Fri, 02 Nov 2007 03:43:21 GMT

Works like a charm Doug! Thanks. I added the following to your stored procedure cause I'm anal and I want everything to be consistent:

-- Change the e-mail address

UPDATE dbo.aspnet_Membership

SET Email = @NewUserName, LoweredEmail = LOWER(@NewUserName)

WHERE ApplicationId = @ApplicationId AND UserId = @UserId

re: How to change user name in ASP.NET 2.0 Membership Provider

Doug Taylor — Fri, 02 Nov 2007 03:23:17 GMT

Hey folks, looks like I spoke too soon... a problem with my class above is Membership.GetUser() is designed to return a MembershipUser object. So when I try to do this:

Dim myUser As cMembershipUser

myUser = Membership.GetUser(Me.OriginalUserName)

it fails because myUser is the wrong type, and even when I try to cast the return result it doesn't work. Anyone know how to use inheretance, but still let your modified class be used in this way? In the meantime as a workaround I created a static utility class with a method that lets me update the username interfacing with the stored procedure above. I've pasted it below, and you'd use it like this:

utils.ChangeUserName("oldUserName", "newUserName")

----------------

Imports Microsoft.VisualBasic

Imports System.Data.SqlClient

Public Class utils

Public Shared Function ChangeUserName(ByVal oldUserName As String, ByVal newUserName As String) As Boolean

Dim IsSuccsessful As Boolean = False

If IsUserNameValid(NewUserName) Then

Dim myConn As New SqlConnection(ConfigurationManager.ConnectionStrings("pbv2005").ToString)

Dim cmdChangeUserName As New SqlCommand()

With cmdChangeUserName

.CommandText = "dbo.aspnet_Membership_ChangeUserName"

.CommandType = Data.CommandType.StoredProcedure

.Connection = myConn

.Parameters.Add("@ApplicationName", Data.SqlDbType.NVarChar)

.Parameters.Add("@OldUserName", Data.SqlDbType.NVarChar)

.Parameters.Add("@NewUserName", Data.SqlDbType.NVarChar)

End With

cmdChangeUserName.Parameters("@ApplicationName").Value = ConfigurationManager.AppSettings("AppKey").ToString

cmdChangeUserName.Parameters("@OldUserName").Value = oldUserName

cmdChangeUserName.Parameters("@NewUserName").Value = newUserName

Try

myConn.Open()

cmdChangeUserName.ExecuteNonQuery()

myConn.Close()

IsSuccsessful = True

Catch ex As Exception

IsSuccsessful = False

End Try

Else

IsSuccsessful = False

End If

Return IsSuccsessful

End Function

Private Shared Function IsUserNameValid(ByVal username As String) As Boolean

' Add whatever username requirement validation you want here, doesn't

' the membership provider have some build in functionality for this?

If username.Length > 4 Then

Return True

Else

Return False

End If

End Function

End Class

re: How to change user name in ASP.NET 2.0 Membership Provider

Doug Taylor — Tue, 30 Oct 2007 19:40:35 GMT

Here's a class that interfaces with the stored procedure I just mentioned. It inherits from System.Web.Security.MembershipUser, and I use it like this (VB.NET):

Dim myUser As cMembershipUser

myUser = Membership.GetUser(Me.OriginalUserName)

myUser.ChangeUserName("NewUserNameHere")

--------------------------

Imports Microsoft.VisualBasic

Imports System.Data.SqlClient

Public Class cMembershipUser

Inherits System.Web.Security.MembershipUser

Public Function ChangeUserName(ByVal NewUserName As String) As Boolean

Dim IsSuccsessful As Boolean = False

If IsUserNameValid(NewUserName) Then

Dim myConn As New SqlConnection(ConfigurationManager.ConnectionStrings("pbv2005").ToString)

Dim cmdChangeUserName As New SqlCommand()

With cmdChangeUserName

.CommandText = "dbo.aspnet_Membership_ChangeUserName"

.CommandType = Data.CommandType.StoredProcedure

.Connection = myConn

.Parameters.Add("@ApplicationName", Data.SqlDbType.NVarChar)

.Parameters.Add("@OldUserName", Data.SqlDbType.NVarChar)

.Parameters.Add("@NewUserName", Data.SqlDbType.NVarChar)

End With

cmdChangeUserName.Parameters("@ApplicationName").Value = ConfigurationManager.AppSettings("AppKey").ToString

cmdChangeUserName.Parameters("@OldUserName").Value = Me.UserName

cmdChangeUserName.Parameters("@NewUserName").Value = NewUserName

Try

myConn.Open()

cmdChangeUserName.ExecuteNonQuery()

myConn.Close()

IsSuccsessful = True

Catch ex As Exception

IsSuccsessful = False

End Try

Else

IsSuccsessful = False

End If

Return IsSuccsessful

End Function

Private Function IsUserNameValid(ByVal username As String) As Boolean

' Add whatever username requirement validation you want here, doesn't

' the membership provider have some build in functionality for this?

If username.Length > 4 Then

Return True

Else

Return False

End If

End Function

End Class

re: How to change user name in ASP.NET 2.0 Membership Provider

Doug Taylor — Tue, 30 Oct 2007 18:29:37 GMT

After reading the discussion above I created the following stored procedure that seems to do the trick. Sorry if it got word-wrapped, but hopefully you get the idea. I'm surprised that Microsoft would have the foresight to distinguish between UserId and UserName, but not build in the ability to change the username. Why else would you have a seperate UserId value if not to let UserName change?

Working on something now that'll allow this to be called in code along the lines of:

Membership.ChangeUserName("OldName", "NewName")

Hope it helps!

------------

CREATE PROCEDURE dbo.aspnet_Membership_ChangeUserName

@ApplicationName NVARCHAR(256),

@OldUserName NVARCHAR(256),

@NewUserName NVARCHAR(256)

BEGIN

DECLARE @UserId AS UNIQUEIDENTIFIER

DECLARE @ApplicationId AS UNIQUEIDENTIFIER

-- Lookup the ApplicationId

SELECT @ApplicationId = ApplicationId

FROM dbo.aspnet_Applications

WHERE LoweredApplicationName = LOWER(@ApplicationName)

-- Lookup the UserId

SELECT @UserId = UserId

FROM aspnet_Users

WHERE ApplicationId = @ApplicationId AND LoweredUserName = LOWER(@OldUserName)

-- Change the username

UPDATE dbo.aspnet_Users

SET UserName = @NewUserName, LoweredUserName = LOWER(@NewUserName)

WHERE ApplicationId = @ApplicationId AND UserId = @UserId

END

re: How to change user name in ASP.NET 2.0 Membership Provider

boby — Sat, 20 Oct 2007 10:28:48 GMT

i usee the query in this controlchange password

"select password into register where

email='"+changepassword1.Username+"'"

then

it give massege for falier

if i use username field in username text the give success massege

but i want to control on email basies

re: How to change user name in ASP.NET 2.0 Membership Provider

Ben Erwood — Tue, 02 Oct 2007 07:37:38 GMT

Daniel,

I've used the approached you describe and it has worked just fine for me.

Cheers, Ben

re: How to change user name in ASP.NET 2.0 Membership Provider

Jon Swain — Tue, 25 Sep 2007 13:59:55 GMT

I ended up just going straight to the database level and changing each username within the database. You can easily do this in the aspnet_users table.

See:

jonswain.wordpress.com/.../renamingchanging-username-in-aspnet