Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jul 23, 2012 01:45 PM by BU XI - MSFT
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#
Jul 20, 2012 09:48 AM|LINK
Take a look here
tblUser User = (from U in MyEntity.tblUsers where U.UserEmail == strEmail && U.Password == strPass && U.Status == true && U.RoleType == "A").FirstorDefault();
Jul 23, 2012 03:29 AM|LINK
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?
Jul 23, 2012 01:45 PM|LINK
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.