Double insert to database

Question

0.00/5 (No votes)

See more:

We have a asp.net web application database is sql server 2008 ,which is hosted in a server. Sometimes we face a problem like:-----
Suppose a user is inserting a record in a table. As per our coding one record should be inserted only once with an id as primary key. But sometimes the same record is being inserted twice with different id but other details remain exactly same.So far we have ruled out problem in coding and stored procedure,but we are unable to find the exact problem.
If anyone has faced similar situation,please give us some
solution.

Posted 26-Nov-12 0:01am

sanjay acharya

Add a Solution

Comments

__TR__ 26-Nov-12 6:19am

One of the situations the scenario you described can occur is when the user double clicks a button instead of a single click. This causes the button click event to be fired twice and if there is some data inserted into the database in this event, it will get duplicated.
To avoid this you can hide your button through JavaScript when user clicks the button there by avoiding the double click.

dimpledevani 26-Nov-12 7:56am

You can clear the values as soon as your insert query fires or disabl the button once its clicked.Debug your code and find out

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)

Vishal.Shimpi144 · Answer 1 · 2012-11-26T00:22:00

definitely the problem is in your code.. You may be call stored procedure as well as inline query both. debug your application line by line thoroughly. you will definitely got whats wrong you have done. if still you wont find the mistake, then make your ID column to indentity false keep primary key as it is then execute. it will return u the error at 2nd time insertion.

Anurag Sinha V · Answer 2 · 2012-11-26T00:25:00

Hi,

Looking at your post am able to kinda infer that there is some uniqueness problem.
But since primary key has been used on ID and records with different ID's, but similar details are being entered, you might want to use a CTE with delete option to eliminate the duplicate records.

Also you might want to alter the primary key to include ID plus some other relevant unique column.

jaswinder Singh03 · Answer 3 · 2012-11-26T00:35:00

Solution 3

Check your code..

Make sure you added

C#

command.ExecuteNonQuery()

only once....

Hope it helps

Posted 26-Nov-12 0:35am

jaswinder Singh03

Comments

sanjay acharya 26-Nov-12 7:32am

ya we have used command.ExecuteNotQuery() only once.

jaswinder Singh03 26-Nov-12 7:36am

have you used ExecuteScalar etc. with ExecuteNonQuery. if yes remove it..

Double insert to database

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0