ASP.NET Duplicate records getting inserted in database

Question

We have a survey web app that randomly inserts duplicate survey records after user completes survey.

I tried to fix the problem by redirecting to a confirmation.aspx page, and therefore the survey page doesn't get reposted when user hits F5. That fix worked.

However, we have noted that duplicate records are still getting in, sometimes 20 minutes apart, sometimes a minute.

If you click on the Back Button, the confirmation page won't let the user go back, so it will just post the confirmation page back.

Here's an example of the duplicate records:

CustomerSurveyID    CustURL SurveyType  SentDate    SubscriberID    ResponseDate    CustomerID
2665    http://survey.xxx.com/ConsumerSurvey.aspx?17157&281600783&2&2014-05-27T00:00:00 2   2014-05-27 00:00:00.000 17157   2014-05-29 16:36:41.787 281600783
2666    http://survey.xxx.com/ConsumerSurvey.aspx?17157&281600783&2&2014-05-27T00:00:00 2   2014-05-27 00:00:00.000 17157   2014-05-29 16:37:08.027 281600783

We have no idea what the end user could be doing to cause this duplicates to get inserted in the database. Is there a reason that could be happening?

You will need to provide at least some code. How are you saving your data? — andleer
– andleer, Commented May 30, 2014 at 18:06

user3525511 · Accepted Answer · 2014-05-30 20:40:05Z

1

40-Love I would direct you to this excellent article. As you will see, there are several options for your problem. All solutions are discussed here. I recommend using two,

Response.Redirect(Request.Url.ToString(), false)

And Sql exceptions to trap duplicates. this may require changes to your database.

http://aspalliance.com/articleViewer.aspx?aId=687&pId=-1

answered May 30, 2014 at 20:40

user3525511

Sign up to request clarification or add additional context in comments.

Comments

Mitesh · Accepted Answer · 2014-05-30 18:56:56Z

1

What i am guessing is that user is clicking back button and again inserting the record that's why you may be getting duplicate record.

My suggestion is that:-

1)Once the user insert the record reset all the controls value to blank,so that if he/she again try to click the insert button,duplicate entry is avoided. 2)And on the page_load event call one reset() function which will reset all the controls value to their defaults.

answered May 30, 2014 at 18:56

Mitesh

1081 silver badge11 bronze badges

Comments

Tyshun · Accepted Answer · 2014-05-30 21:12:56Z

1

It would help if you provided code to show when the data gets inserted into the database within your flow. Without seeing your code, I'll assume there is some reason you need to stay on the same page and not redirect to a confirmation page or something of that nature upon the form submission. Redirection would be the simplest solution. If that's not possible, make sure your code that inserts the data is inside a block that checks whether the page is being rendered for the first time.

if(!isPostback())
{
    /*Database Handling Code Here*/
}

answered May 30, 2014 at 21:12

Tyshun

3254 silver badges15 bronze badges

Comments

live-love · Accepted Answer · 2014-06-02 18:40:58Z

0

The problem was they had two browser windows open at the same time, and they were hitting the Finish button on two different windows, thus inserting twice.

In this case, Response.Redirect was not effective.

The solution in this case was to create an unique index in the table that was being updated.

answered Jun 2, 2014 at 18:40

live-love

53.2k27 gold badges257 silver badges220 bronze badges

Collectives™ on Stack Overflow

ASP.NET Duplicate records getting inserted in database

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related