validation to check duplicate records before inserting

Question

0.00/5 (No votes)

See more:

i need a validation to restrict the entries of duplicate data in my database. i am using asp.net, c# and sql server as my development environment.
i have in total four tables in a database called 'CGRT' and table names being project,staff,yearly,monthly . please give me a solution so that i can restrict the entries of duplicate data i would prefer if its at client end with a error msg.

Posted 28-Oct-12 1:50am

a2ulthakur

Add a Solution

Comments

Kuthuparakkal 28-Oct-12 7:52am

Have you tried implementing Primary Keys ?

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Frank R. Haugen · Accepted Answer · 2012-10-28T02:09:00

I'm not coding it for you!

The way I would have done it, if resource use was not an issue, and it was 100 or less rows in the tables, was to load the relevant table(s) into a DataSet[^] and search through all rows in the first column (not the record ID column if it has one), if the first fits compare each relavant field on the row using String.Compare() and should all match, then return error message or whatever you want.

Now I use C# for desktop so I don't need to worry to much about resources, but if this is on a website calling another websites SQL server, it's not a good fix.

hope this was helpful!

-frank

PS: feel free to comment on this if I'm missing the point of the question entirely

Jibesh · Accepted Answer · 2012-12-14T07:02:00

The better and most optimized solution is to write a query or stored procedure which returns the count of the existing values if count is not equal to zero means you already have this record in your table skip further insertion.

The term 'Duplicate Entries' only be defined you so you have to modify the query with your parameter a sample query look like this.

eg: select count(staffName) from student where staffName ='Bingo'
this query will return number of items that matches staffName Bingo. If Bingo already exists it will return 0. else the number of occurrence

sisir patro · Accepted Answer · 2012-12-14T07:15:00

Solution 5

hi,

You can use EXISTS for your solution.

SQL

SELECT DepartmentID, Name 
FROM HumanResources.Department 
WHERE EXISTS (SELECT NULL)
ORDER BY Name ASC ;

Refer this link for better result.Preventdiuplicate record entry

Thanks

Posted 14-Dec-12 7:15am

sisir patro

validation to check duplicate records before inserting

3 solutions

Solution 1

Solution 4

Solution 5

Add your solution here

Preview 0