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
but i dont know what is the guide of user and how to find it.
can any one help me with this
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