Preventing Duplicate Record Insertion on Page Refresh

July 3, 2010July 3, 2010Chandradev

I was getting duplicate data in database while refreshing the page in Registration page. I searched on asp.net forum. Then i got the two type of solution

1. After insert operation just redirect to that page

protected void BtnSubmit_Click(object sender, EventArgs e)
{

//code for insert

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

}

2. Using sql query, before inserting into database, we have to check that record in database . If that record is available in database stop the execution of code.

For more detail,Please read this article

http://aspalliance.com/687_Preventing_Duplicate_Record_Insertion_on_Page_Refresh.all

nirmal July 26, 2011 / 1:02 pm

Use indexing if you are using mysql….it works for duplicate entries….it throws an error that duplicate entry is found

Reply
- Chandra Dev July 27, 2011 / 4:44 am
  
  Hi
  In first method there is no relation with database.
  
  Reply
Nayan Godhani September 21, 2013 / 11:05 am

thanks…………………………………

Reply
viagra April 30, 2014 / 7:55 am

I believe this is one of the so much vital information for me.

Annd i’m happy studying your article. However should staterment
on few basic things, The sitee styoe iis perfect, the articles is actually nice : D.
Just right job, cheers

Reply
- Chandra Dev May 1, 2014 / 4:28 am
  
  Thank you. I m glad to know.
  
  Reply
- Chandra Dev May 1, 2014 / 4:40 am
  
  Thanks. Nice to know about this.
  
  Reply
Pingback: [RESOLVED]best way to maintain state when using response.redirect to same page | ASP Questions & Answers