This should be a quick one, I have a button to delete a user but an additional UserDetails table retains the information so I added a FK contraint in the Database Diagrams hoping this would be removed too if it's connected to the user details but after setting that I get a YSOD when registering a user.

Whats the best way to remove this additional user data?

I managed this manually by using:

Dim CurrentUser As String = Membership.GetUser(User.Identity.Name).ToString()

Protected Sub btnYes_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnYes.Click
Membership.DeleteUser(User.Identity.Name, True)
Dim conString As String = System.Configuration.ConfigurationManager.Connecti onStrings("ConnectionString").ConnectionString
Dim con As New SqlConnection(conString)
Dim cmd As SqlCommand = New SqlCommand("DELETE FROM UserDetails WHERE (UserName = @UserName)", con)
cmd.Parameters.AddWithValue("@UserName", CurrentUser)
con.Open()
cmd.ExecuteNonQuery()
con.Close()
con.Dispose()

FormsAuthentication.SignOut()
FormsAuthentication.RedirectToLoginPage()
End Sub

Hi Alex,

Yes, that works well. If you want to do it the database way, search Google for "cascading delete sql server". You can link your data to the users table and define behavior for the Delete operation.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!