How to check duplicate email id

Posted by Chaithragm under C# on 1/10/2013 | Points: 10 | Views : 4067 | Status : [Member] | Replies : 12
hi...
in the registration page we need to check the duplicate emal-id (im using slq server)




Responses

Posted by: muralikrishnasurap-12704 on: 1/10/2013 [Member] Starter | Points: 25

Up
0
Down
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

Posted by: Jasmine131092 on: 1/10/2013 [Member] Starter | Points: 25

Up
0
Down
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

Posted by: Jasmine131092 on: 1/10/2013 [Member] Starter | Points: 25

Up
0
Down
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

Posted by: Self-Innovator on: 1/10/2013 [Member] Bronze | Points: 25

Up
0
Down
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

Posted by: perfectchourasia-9163 on: 1/10/2013 [Member] Starter | Points: 25

Up
0
Down
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

Posted by: perfectchourasia-9163 on: 1/10/2013 [Member] Starter | Points: 25

Up
0
Down
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

Posted by: Chaithragm on: 1/11/2013 [Member] Starter | Points: 25

Up
0
Down
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

Posted by: Saratvaddilli on: 1/11/2013 [Member] [MVP] Bronze | Points: 25

Up
0
Down
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

Posted by: Shubham on: 1/11/2013 [Member] Starter | Points: 25

Up
0
Down
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

Posted by: Sourabh07 on: 1/18/2013 [Member] Starter | Points: 25

Up
0
Down
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

Posted by: Kundan64 on: 1/18/2013 [Member] Starter | Points: 25

Up
0
Down
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

Login to post response