User730446648 posted
I started with this tool.
See the bottom of the first post, there is a link to a user.cs file
http://forums.asp.net/t/1110595.aspx
As is the file mentioned above does work to apply yourself as admin ad remove the member.
However, when using the tool it only removes the member from the members database.
It does not remove the member from the classifieds database in the members table.
For this to work completly, I converted it to vb, and added some code for the removal process.
It's pretty easy though, just make a new stored procedure.
You need to start with the user file you use for managing your members.
When it runs through and deletes them member tell it to get the username you want to delete.
MembersDB.RemoveMemberFromDatabase(ListBox1.SelectedValue)
That line above tells it to go into App_Data/BLL/Members.vb
and looks for a sub your about to create, RemoveMemberFromDatabase
Save this sub below in App_Code/BLL/Member.vb
Public
Shared
Sub RemoveMemberFromDatabase(ByVal UserName
As
String)
Using db
As
New MembersDataAdapter()
db.RemoveMemberByUsername(UserName, "/")
End
Using
End
Sub
That sub tells it to look in App_Code/DAL/Members.xsd
I like to go into the code itself, and I just copied insertmember,
delete the entries, only leaving the top three.
THE TOP THREE NAMES BELOW ARE ABBREVIATED.
RETURN
ASPNETusername
ASPNETAPPNAME
Since you copied, don't forget to change ALL insertmember (in your copy) to RemoveMemberByUsername
Now it looks for your stored procedure.
Here's one I wrote.
ALTER PROCEDURE
RemoveMemberByUsername @AspNetUsername
nvarchar(256),
@AspNetApplicationName
nvarchar(256)
AS
DELETE FROM
classifieds_Members
WHERE
(AspNetUsername = @AspNetUsername) AND
(AspNetApplicationName = @AspNetApplicationName)
And it should work.
(Note that I am using the final version so it says my members table is classifieds_Members)
If you are using beta, just remove "classifieds_"
Make sure you make a backup before trying new code, and test it out before publishing.
Good Luck
