About Registration form

Question

0.00/5 (No votes)

See more:

I have created a form that accepts information from user and stores it into database.
but problem is that when i click on refresh button or press go back on page, the data duplicates in database.

so if any one has solution please help me out..

Posted 5-Jul-12 21:17pm

abcforcode

Add a Solution

Comments

bbirajdar 21-Jul-12 14:43pm

How in the world the data gets duplicated in the database when you are inserting/updating the user data against the particular unique userId ?Your database design is wrong...

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

Pankaj Nikam · Answer 1 · 2012-07-05T21:30:00

Solution 4

There is a pattern called PRG (POST - Redirect - GET). You can follow it to avoid duplicate insertions. Its simply like POST the data to the server, and redirect it to the same or different page.

There are other ways too if you want, which can be easily searched. Have a look at the discussion here[^].

Posted 5-Jul-12 21:30pm

Pankaj Nikam

Updated 21-Jul-12 6:55am

v2

Comments

Rahul Rajat Singh 6-Jul-12 4:00am

good answer, +5.

Pankaj Nikam 6-Jul-12 4:06am

Thank you :)

abcforcode 9-Jul-12 9:27am

thank you..

Pankaj Nikam 9-Jul-12 10:28am

You are most welcome. Please mark it as answer if it helps you :)

Rahul Rajat Singh · Answer 2 · 2012-07-05T22:00:00

what you can do is

1. once user hits the button, first check if the record already exist in DB(based on some key field like email ID)
2. if the check result false. insert the data in DB.
2. when user hits the refresh the check will return true let the user know that he already did it and no action was taken.

P.S. I also liked the answer by "Pankaj Nikam". that is also a good way to go.

Sanjay Kunjam · Answer 3 · 2012-07-05T21:23:00

Solution 1

Hi,

Save your form/registration data on the Button Click Event.
or

VB

If IsPostBack Then
'' save your data to db code here
'' and reset all controls.
End If

Posted 5-Jul-12 21:23pm

Sanjay Kunjam

Updated 5-Jul-12 21:32pm

v2

Comments

Pankaj Nikam 6-Jul-12 3:28am

I believe a button click IS a post back. If you write code like the one you mentioned, it wont be saved at all.

Sanjay Kunjam 6-Jul-12 3:36am

I think every Control in ASP.NET have their own state and value even after post_back event.
So it will be save in the Database.
I have used the same login i.e. data saving on Button Click Event.

Pankaj Nikam 6-Jul-12 4:07am

When you click the refresh button after a post-back, you submit the data once again. Even the browser shows a warning if you try such things. Saving the data in the database should be only once and to avoid this, I have mentioned a tip in my answer.

Sanjay Kunjam 6-Jul-12 4:24am

Good one. Thanks.

Pankaj Nikam 6-Jul-12 4:41am

Welcome :)

Arul R Ece · Answer 4 · 2012-07-05T21:30:00

Solution 3

Page Load()//(
{

if(!ispostback)
{
//Your code here.................
}
}

Posted 5-Jul-12 21:30pm

Arul R Ece

Abolfazl Beigi · Answer 5 · 2012-07-05T21:27:00

Solution 2

I think You must every event that contains code in your cs file. maybe there is some sql insertion code there.

Posted 5-Jul-12 21:27pm

Abolfazl Beigi

akee seth · Answer 6 · 2012-07-05T21:46:00

Solution 5

Hope this link will help you
http://www.mindfiresolutions.com/Avoid-Duplicate-record-insertion-on-page-refresh-in-ASPNET-486.php[^]

Posted 5-Jul-12 21:46pm

akee seth

About Registration form

6 solutions

Solution 4

Solution 6

Solution 1

Solution 3

Solution 2

Solution 5

Add your solution here

Preview 0

Existing Members

...or Join us