3

Hey I am wondering how I can edit users stored in ASPNETDB.MDF I am using ASP.Net 4 / Visual Studio / SQL Server.

I can set a gridview to show the users, but cannot directly edit them. I will be wanting to deploy this, and then assign permissions to users (Moderator etc) as well as have the ability to disable accounts etc.

Or is there a way to use ASP.Net Website Administration Tool from a live website?

Any ideas would be greatly appreciated!

Cheers

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
noscript
  • 77
  • 2
  • 10

4 Answers4

2

When you open the solution in Visual Studio, the DB should show up in your App_Data folder. If it's not there, make sure show all files is checked. You should be able to double click it to open up the database in Server Explorer and edit the tables directly

Wil
  • 2,328
  • 2
  • 20
  • 27
  • 1
    Yes its definitely in the App_Data, Although this method wont help me when its being stored on the server. As I will need to be able to manage new users, and assign moderator role to a select few. – noscript Jul 29 '11 at 15:23
1

You should use server side code to deal with them by using Membership. Take a look at http://msdn.microsoft.com/en-us/library/yh26yfzy.aspx

Maysam
  • 7,246
  • 13
  • 68
  • 106
1

As Maysam points out, you should not modify these things directly via any SQL tool but rather use the Membership API. A quick and easy way to get there would be the MVC Membership Starter Kit.

Wyatt Barnett
  • 15,573
  • 3
  • 34
  • 53
0

This tutorial will help you start with creating an interface for user management tasks on your web-site.

With this tutorial you can feature your user management further.

Kirill
  • 3,028
  • 1
  • 17
  • 18