1

I have created an ASPNETDB database on SQL Server 2008 for users, roles and profiles with Aspnet_regsql.exe.

But what I want to more user attributes apart from those default ones (name, email, mobile and comment), e.g. Postcode, Address, Telephone number, Rank, Position, etc. And also those new fields should be exposed to CreateNewUserWizard in the aspx page design mode, so that new user can be registered with more attributes.

I tried to add new columns in the "aspnet_Membership" table of ASPNETDB database. But they weren't automatically picked up.

Can anyone please give me some help on this? Thanks

Cheers, Alex

Improve this question

2 Answers 2

Reset to default
3

Don't touch the database yourself. Follow the steps outlined here:

http://weblogs.asp.net/scottgu/archive/2005/10/18/427754.aspx

Note that you need to use the "Website" project template. Profiles are not supported out-of-the-box (without some customization) for the Web Application project template.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

2

Please refer aspnet_Profile table

To add additional attributes columns you will need to create Profile Properties in web.config file and access this Properties and update the Profile of the currently created user.

If you have complex information about users then u can create your table and use the foreign key relation ship to UserId in aspnet_users table.

Check this MSDN ARTICLE

HOW TO ADD PROPERTIES for Profile

Complete details of using Profiles in Asp.net C# is explained in one of the answer on StackOverflow itself please refer how-to-assign-profile-values

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.