How to check duplicate email id

Hi Chaithragm ,

Use ASP.net Compare validator and between two text boxes and changes 'operator' property in compare validator to "NotEqual" this may help you.

Best Regards
Murali Krishna.S

Chaithragm, if this helps please login to Mark As Answer. | Alert Moderator

hi...
in the registration page we need to check the duplicate emal-id (im using slq server)
....................................................
[URL=HTTP://WWW.EZDIE.COM/EPAD/2013-MERCEDES-BENZ-SL-CLASS-PRICE-REVIEWS/7980/] 2013 MERCEDES BENZ SL-CLASS [/url]

Chaithragm, if this helps please login to Mark As Answer. | Alert Moderator

hi...
in the registration page we need to check the duplicate emal-id (im using slq server)
....................................................
[URL=HTTP://WWW.EZDIE.COM/EPAD/2013-MERCEDES-BENZ-SL-CLASS-PRICE-REVIEWS/7980/] 2013 MERCEDES BENZ SL-CLASS [/url]

Chaithragm, if this helps please login to Mark As Answer. | Alert Moderator

http://www.dotnetfunda.com/codes/code1857-validating-duplicate-email-id-from-database-while-form-filling.aspx

Join Hands Change lives
Thanks & Regards
Straight Edge Society

Chaithragm, if this helps please login to Mark As Answer. | Alert Moderator

http://sandeep-chourasia.blogspot.in/2012/05/check-exist-or-not.html

ER sandeep chourasia
sandeepchrs@yahoo.com (on facebook)
http://www.aspnetcodes.com/

Chaithragm, if this helps please login to Mark As Answer. | Alert Moderator

mark your response

ER sandeep chourasia
sandeepchrs@yahoo.com (on facebook)
http://www.aspnetcodes.com/

Chaithragm, if this helps please login to Mark As Answer. | Alert Moderator

i have to ckeck in the client side itself....as it happens in google registration

Chaithragm, if this helps please login to Mark As Answer. | Alert Moderator

how chaithragm ,
Do one thing write your logic to cross check withe data base in ontextchange event that will work for sure

Thanks and Regards
V.SaratChand
Show difficulties that how difficult you are

Chaithragm, if this helps please login to Mark As Answer. | Alert Moderator

Hi!!! Chaithragm

protected void btnsav_Click(object sender, EventArgs e)//////// or text change event
{

try
{
confunction();////is your connection string
con.Open();
MySqlCommand msql = new MySqlCommand("SELECT mailid from user_master WHERE mailid='" + txtmail.Text + "' ", con);
MySqlDataReader mdr = msql.ExecuteReader();
if (mdr.Read())
{
mdr.Close();
con.Close();
lblmsz.Visible = true;
lblmsz.Text = "Duplicate entry found";
return;
}
else
{
your next process
}

Thanks&Regards:-
Shubham Choudhary
Software Engineer
www.facebook.com/shubham.kunar

Chaithragm, if this helps please login to Mark As Answer. | Alert Moderator

Hi Friend

it is little typical but not impossible there is some important link that can helps you...

http://www.isurinder.com/blog/post/2009/01/09/ASPNET-Membership-Provider-Validating-Duplicate-Email-Addresses.aspx#.UO91yfIgf9Y

http://stackoverflow.com/questions/12419645/check-for-duplicate-emailid

http://stackoverflow.com/questions/10232706/how-does-one-prevent-duplicate-email-addresses-while-users-modify-their-email-ad

i think it helps you thanks

http://forums.asp.net/t/1827779.aspx/1?check+for+duplicate+emailid+in+3+tier

Shubham Agrahari

Chaithragm, if this helps please login to Mark As Answer. | Alert Moderator

Hi,

SELECT email, 

 COUNT(email) AS NumOccurrences

FROM users where email = 'abc@gmail.com'

HAVING ( COUNT(email) > 1 )

Please mark this answer if your problem is resolved

Sourabh07

Chaithragm, if this helps please login to Mark As Answer. | Alert Moderator

use the simple query like: Select COUNT(EmailAddress) From Person.EmailAddress Where EmailAddress = 'dylan0@adventure-works.com'
and execute the command as ExecuteScalar method.
Its returns 0 if the emailid already not exist and returned value will be grater than 0 if record exist.


Mark as answer if its help you.

Chaithragm, if this helps please login to Mark As Answer. | Alert Moderator