how to prevent user to insert duplicate records in database using asp.net web form.

Question

2.40/5 (2 votes)

See more:

Hello all,

I am using a from to insert data into database.

when from is fill by user and press on submit button again and again continuously then a bunch of duplicate rows inserted into database.

How can i prevent user to submit duplicate data.

When i am disabling the submit button after one click by using system.thread.sleep(3000); then it does not perform validation of page.

if the connection is slow the user click multiple times before the Postback happens and then you get multiple Inserts... I tried using OnClientClick="this.disabled=true" on the Insert button but if there are validation problems the user will have to fix them first and then the Insert button is disabled.

Please suggest what i have to do resolve this.

Thanks

Posted 3-Dec-13 8:21am

Mukesh Bhagat

Updated 3-Dec-13 8:41am

v3

Add a Solution

Comments

Maciej Los 3-Dec-13 15:34pm

What is your query and code behind (onClick)?

2 solutions

Solution 1

Firstly, you should prevent duplicate records being written to the database if at all possible (you can always check if a record with exactly the same contents exists and return an error)

You say that if you disable the button on clicking and there are validation problems the insert button is disabled?

Well can you not enable the button if there are validation problems?

So;

On Click - disable the button to prevent another click
On Validation Error - enable the button again.

Incidentally, I personally prefer disbling the whole form rather than just the button.

Posted 3-Dec-13 16:02pm

_Maxxx_

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)

JoCodes · Accepted Answer · 2013-12-03T18:43:00

Solution 2

You can use Page.Valid for the submit button click event , and if passes validation then only

Disable the control .

You may refer the link which uses GetPostBackEventReference method approach too.

http://forums.asp.net/t/1395392.aspx[^]

Try and revert.

Hope this helps...

Posted 3-Dec-13 18:43pm

JoCodes