How to delete a user in ASPNet database

bex · December 23rd, 2008, 12:18 PM

Hi there i have this problem with deleting a user from aspnet db. i am using VS2005
when i try to configure data source on the datasource controll i do not get the generate ,update,insert,delete statment.

i found this on internet

Code:

USE ASPNet
GO
DECLARE @UserId uniqueidentifier
SET @UserId = 'THE GUID OF THE USER HERE'
DELETE FROM aspnet_Profile WHERE UserID = @UserId
DELETE FROM aspnet_UsersInRoles WHERE UserID = @UserId
DELETE FROM aspnet_PersonalizationPerUser WHERE UserID = @UserId
DELETE FROM dbo.aspnet_Membership WHERE UserID = @UserId
DELETE FROM aspnet_users WHERE UserID = @UserId

but i dont know what is the guide of user and how to find it.

can any one help me with this

thank

Imar · December 23rd, 2008, 12:29 PM

Hi there,

The UserId can be retrieved from the ProviderUserKey, like this:

CSharp Code:

Guid userId = (Guid)Membership.GetUser().ProviderUserKey;

Visual Basic Code:

Dim userId As Guid = CType(Membership.GetUser().ProviderUserKey, Guid)

But why are you using direct SQL? I think you're much better off using the API:

Code:

Membership.DeleteUser(Membership.GetUser().UserName, True)

Hope this helps,

Imar

bex · December 23rd, 2008, 06:54 PM

thanks for your replay i never used

Code:

 Membership.DeleteUser(Membership.GetUser().UserName, True)

and i dont know how to implement

it can you plase guide me a bit or tell me where can i finde more about it ? (books)

bex · December 25th, 2008, 05:15 AM

that was quiet easy i found it in begin aspnet 2.0