Solved

how to avoid Duplicate when you insert record

Posted on 2011-03-19
4
401 Views
Last Modified: 2012-05-11
Am trying to insert a record pulled out from Active Directory but i can see so many duplicates,how can i avoid when i insert those records.

for eg

will.smith@gmail.com repeat 5 times,i just don't want to insert a duplicate record based on mail id.

any one pleas enlighten me.

Thanks in Advance
0
Comment
Question by:Sha1395
  • 2
4 Comments
 
LVL 2

Accepted Solution

by:
ramkihardy earned 250 total points
ID: 35171208
simple you can set the maildid column unique in the table which you want to enter.......
when you try to insert a duplicate email id..it throws an error...catch that error it consist of errorid for duplicate record insertion...you can check if duplicate record inserted in catch...like
if(errid=="error id for duplicate record insertion")
{
Messagebox.show("Record alreadyb exist");
}
2.Otherwise you have to select the distinct record so that it wont contain any duplication...
Regards
Ramki
0
 
LVL 3

Assisted Solution

by:exceter
exceter earned 250 total points
ID: 35171233
Also you can create a temporary table and insert there initially with INSERT INTO .... SELECT DISTINCT EmailID...
0
 

Author Comment

by:Sha1395
ID: 35171548
Thanks Ramki and Exceter.

As you people mentioned i make Email Id is a primary key and use TRY  Catch in my code.its done.

Thanks again for all your help
0
 
LVL 2

Expert Comment

by:ramkihardy
ID: 35171602
Please mark it as accepted solution...
Thanks & regards
Ramki
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article series is supposed to shed some light on the use of IDisposable and objects that inherit from it. In essence, a more apt title for this article would be: using (IDisposable) {}. I’m just not sure how many people would ge…
Introduction Hi all and welcome to my first article on Experts Exchange. A while ago, someone asked me if i could do some tutorials on object oriented programming. I decided to do them on C#. Now you may ask me, why's that? Well, one of the re…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question