How Do I Stop Duplicate Insertion In Sql Server .As Primary Key Is Autoincreament

Question

3.00/5 (2 votes)

See more:

When My asp.net Application is running on live Server.when Server is responding Slow , User Can click on Save button Multiple time before Successfull Message receive.

If user clicking twice time on button then Two same Record Inserted at one time and then after successful message and all fields blank.How could I resolve this Issue ?
Note in Sqlserver Primary Key ID is Auto Increment Set.

Posted 24-Jan-14 3:23am

Tariq Mehmood

Updated 24-Jan-14 9:07am

Thanks7872

v2

Add a Solution

4 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)

Ron Beyer · Accepted Answer · 2014-01-24T03:29:00

Solution 1

I would disable the submit button after the first click...

Posted 24-Jan-14 3:29am

Ron Beyer

Comments

[no name] 24-Jan-14 9:35am

how you do it there is so many validation and checks i can not stop and prevent event click after just one click ?

[no name] 24-Jan-14 9:44am

I've already done this way : Disable button in first on click t then at the end Enabled again also , Still the same issue of Duplicaton.

gettgotcha 24-Jan-14 10:16am

When are you enabling the button again, after clicking on the button do you navigate to different page something like confirmation page or not?

[no name] 24-Jan-14 10:42am

no i not navigate the page.

Karthik_Mahalingam 24-Jan-14 21:28pm

5, Good Idea Ron

Vedat Ozan Oner · Accepted Answer · 2014-01-24T04:36:00

you can check whether a record exists or not before inserting it.

you have two options at this point.
1- you may ban an insertion completely if there exists another record having the same fields.
2- you may put a time-limit for it if actually such duplicated data may exist. this option requires additional 'DateTime insertDate' column on your table.

for the first option,

SQL

if not exists select 1 from TableA where ColA=@a and ColB=@b
insert into TableA(ColA, ColB) values(@a,@b)

for the second option

SQL

if not exists select 1 from TableA where ColA=@a and ColB=@b and DATEDIFF(mi,insertDate, GETDATE())<5 
insert into TableA(ColA, ColB, insertDate) values(@a,@b,GETDATE())

V5709 · Accepted Answer · 2014-01-26T20:04:00

Solution 3

After submitting successfully you can clear all fields & in submit button code you may have used proper validations for blank fields..

Other wise you can use check for duplicate fields in sql query .

Posted 26-Jan-14 20:04pm

V5709

Ahmed Jubayer · Accepted Answer · 2014-01-27T18:15:00

Solution 4

if user click several times then the duplicate data store in the table.to prevent it you can disable the submit button.... or set some logic to stop duplicate insertion.

Posted 27-Jan-14 18:15pm

Ahmed Jubayer