I have referred to your post, Im using MySQL as a DB and I want to check email address availability as it is email is a primary key. As you have mentioned in that post if there are 100,000 id`s. I keep ending up in searching. how to resolve this?
When user press the register button, make a SQL query to find if the email input has a record in the DB. If there is one, redirect the registration page back to the user.
venkateshyel...
Member
12 Points
29 Posts
Registration page check email address record exits in database or not before registration of a ne...
Jul 20, 2012 09:39 AM|LINK
I am developing a user registrion page for which I need to check whether a user is registered or not at the point of Registration
I have used email address as a primary key.
Can some tell me how to do this in ASP.NET Ajax, C#
ajax
christiandev
Star
8597 Points
1841 Posts
Re: Registration page check email address record exits in database or not before registration of ...
Jul 20, 2012 09:48 AM|LINK
Take a look here http://forums.asp.net/t/1825643.aspx/1?Efficient+way+to+validate+user+input+against+a+database
Regards, Christiandev (@chrisdev80), MCPD Web (2 & 4) & MCTS Windows (www.ScoreDonkey.com)
AXEL BLAZE
Member
65 Points
110 Posts
Re: Registration page check email address record exits in database or not before registration of ...
Jul 20, 2012 09:48 AM|LINK
tblUser User = (from U in MyEntity.tblUsers where U.UserEmail == strEmail && U.Password == strPass && U.Status == true && U.RoleType == "A").FirstorDefault();
ajax
chetan.sarod...
All-Star
65619 Points
11118 Posts
Re: Registration page check email address record exits in database or not before registration of ...
Jul 23, 2012 03:29 AM|LINK
Refer this
http://encosia.com/aspnet-username-availability-checking-via-ajax/
http://encosia.com/username-availability-check-usability-improvements/
ajax
Senior Software Engineer,
Approva Systems Pvt Ltd, Pune, India.
venkateshyel...
Member
12 Points
29 Posts
Re: Registration page check email address record exits in database or not before registration of ...
Jul 23, 2012 06:33 AM|LINK
I have referred to your post, Im using MySQL as a DB and I want to check email address availability as it is email is a primary key. As you have mentioned in that post if there are 100,000 id`s. I keep ending up in searching. how to resolve this?
BU XI - MSFT
All-Star
22367 Points
2704 Posts
Microsoft
Re: Registration page check email address record exits in database or not before registration of ...
Jul 23, 2012 01:45 PM|LINK
Hello
When user press the register button, make a SQL query to find if the email input has a record in the DB. If there is one, redirect the registration page back to the user.
If you have any feedback about my replies, please contact msdnmg@microsoft.com.
Microsoft One Code Framework