How to update / delete ASPNETDB.MDF 'vw_aspnet_MembershipUsers'?

Question

How to update / delete ASPNETDB.MDF 'vw_aspnet_MembershipUsers'

To enable / disable the site registers users or delete users ///

using asp.net

it's not clear what you are asking. Do you want to know how to update the view or how to add the ability to enable/disable/delete users from a site? — Ken Henderson, Nov 29 '10 at 03:54
I want to know how to Update / delete the table records in ASPNETDB.MDF in single update / delete query ? — D Infosystems, Nov 29 '10 at 04:14

score 0 · Answer 1 · answered Dec 15 '12 at 10:59

0

for Deleting you can use:

using System.Web.Security;

Membership.DeleteUser(TextBox_username.Text);

and for updating a username you can use above cod .first delete it and then make a new one.

answered Dec 15 '12 at 10:59

score 0 · Answer 2 · edited May 23 '17 at 11:57

Note that you can't explicitly delete rows from a view (vw_aspnet_MembershipUsers), but this view is most likely based on the AspNetUsers table.

Connect to the MDF file (which is probably in your App_Data folder) in Visual Studio: https://stackoverflow.com/a/173221/188926
Right-click the database in Server Explorer > New Query
type: delete from AspNetUsers and hit run (you may need to delete from AspNetRoles first)

2 Answers2