ASP.NET Custom Authentication & Role Problem

Question

0.00/5 (No votes)

See more:

I have read a lot of articles on SqlMembershipProvider and SqlRoleProvider, but i think is still does not meet-up with my requirement or maybe i am not getting something straight in it.
I have created a registration page an a login page for user of the website, Two roles are also created (Administrator and Standard Role) the administrator role control other users and roles. I tried using the LoginControl and the CreateUserWizard control in ASP.NET but after i have use (aspnet_regsql.exe utility), the tables that are created does not meet-up with what i want. Like the column in my web application has something like (Company_Name, Company_Id, Home_Address e.t.c) but the tables dont have such columns in them.

--- How can i implement Member and Role in my Application ---

Posted 8-Jul-11 6:19am

ahmedfaruk88

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Parwej Ahamad · Accepted Answer · 2011-07-08T06:37:00

Solution 1

You can customize CreateUserWizard control look at this article:
http://www.4guysfromrolla.com/articles/070506-1.aspx#postadlink[^]

Posted 8-Jul-11 6:37am

Parwej Ahamad

Comments

ahmedfaruk88 8-Jul-11 13:06pm

If i customize the create user wizard and add more controls like (Company_Name, Company_Id, Home_Address e.t.c). it means i will have to edit the underlying table (aspnet_Users) table to accommodate the it. Or what am i to do

Parwej Ahamad 8-Jul-11 22:01pm

See the below Philippe Mori comment.

Philippe Mori 8-Jul-11 21:58pm

You can also create another table with a column for the UserId and any custom fields. You can then set the relationship between the table so that deleting a row from aspnet_Users will CASCADE DELETE. When adding a user, that new table can also be filled. You might wnat to add some code to ensure that if adding a user in your table fails, then aspnet_Users table won't have that user and vice-versa. In my case, I have used a TransactionScope for that purpose. In that case, you have to ensure that the Distributed transaction coordinator service is running when running the application from Visual Studio integrated server.

ahmedfaruk88 25-Aug-11 9:37am

Please can you give a guideline on how to ensure that if adding a user on the table fails then or a field is not inserted in the other table that referenced the aspnet_Users table then the creation of user in the aspnet_users table should be rolled back.

Thankss