Avoid Duplication of Data insertion in ASP.net

Question

5.00/5 (1 vote)

See more:

Hello helpers,

I am Doing ASP.net application.

I have one page on which I am collecting data from user and saving data into database.

When I click on save button all data is successfully saved but when I Refresh that Page the entries are saved twice.

How could I avoid insertion of Duplicate entries on Page Refresh.

Thanks.

Posted 7-Feb-11 1:08am

nitin bhoyate

Updated 7-Feb-11 4:35am

Henry Minute

v2

Add a Solution

Comments

Rounak Hasan 12-Feb-11 5:36am

Is the database table dont have any primary key??????

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)

davfeu · Answer 1 · 2011-02-07T01:18:00

Solution 1

Best way would be to check if the Data is already in your database before you insert it.

Also you could set a Flag after inserting your data (for example in a sessionvariable) and check for this flag before you save (again).

Posted 7-Feb-11 1:18am

davfeu

Comments

nitin bhoyate 7-Feb-11 7:58am

Thanks

OriginalGriff · Answer 2 · 2011-02-07T01:19:00

Solution 2

Good question! Get's my 5.

There is a solution with code here[^] - I haven't tried it, but the idea seems sound.

Posted 7-Feb-11 1:19am

OriginalGriff

Comments

nitin bhoyate 7-Feb-11 8:02am

Thanks Very Good Link. But According to My two hours of googling. Check IS Exist in Database will take less time(8 sec Provided in one blog, Session checking takes 11 sec provided in same blog http://aspalliance.com/687_Preventing_Duplicate_Record_Insertion_on_Page_Refresh.all).

Well Til i am Googling to fing proper and Quick Way.
Thanks for Reply

velmahesh · Answer 3 · 2011-02-07T02:37:00

Solution 3

Hi nitin bhoyate :rose:,

:thumbsdown:

1. whenever u will insert the data, then you validate the input data'a. (Script via..(javascript or anything..))

2. whenever u will insert the data then, Clear the values.

Note: validation is the best solution...

Posted 7-Feb-11 2:37am

velmahesh

Comments

Rounak Hasan 12-Feb-11 5:34am

I thik it is best option..

Manas Bhardwaj · Answer 4 · 2011-02-07T03:22:00

Solution 4

Well, in my opinion you should only save the data when IsPostBack [^]is true.

C#

if(IsPostBack)
{
    //save my data
}

Posted 7-Feb-11 3:22am

Manas Bhardwaj