When using ASP.NET Membership, ensuring all e-mail addresses are unique

Question

0.00/5 (No votes)

See more:

Hiya,

I am using the Create User Wizard provided within Visual Studio to create user accounts for my system and cannot work out how to ensure that both the username and email address are both unique. I have searched online and within a couple of books we have here and can't find the solution.

Can anyone help?

Thanks in advance!

Posted 18-Jan-12 4:47am

Scrappy 1871

Add a Solution

3 solutions

Solution 3

Hi Mark,

I have worked out how to check whether the email address is being used by using:

Membership.GetUserNameByEmail(string email);

How would I then prevent the Wizard going on any further if the email address does exist?

Thanks

Posted 18-Jan-12 6:45am

Scrappy 1871

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)

Not Active · Accepted Answer · 2012-01-18T05:43:00

Solution 1

If you are using the defaults supplied when running aspnet_regsql then a database named aspnetdb is created. Within this there is a table called aspnet_User and within that a column named UserName.

Does this give you any ideas of how to check for unique user names?

Posted 18-Jan-12 5:43am

Not Active

Comments

NandaKumer 18-Jan-12 13:10pm

good one

NandaKumer · Accepted Answer · 2012-01-18T07:10:00

Solution 4

check these blogs
http://www.4guysfromrolla.com/articles/062508-1.aspx[^]
http://msdn.microsoft.com/en-us/library/ff648345.aspx[^]
--NDK

Posted 18-Jan-12 7:10am

NandaKumer