X
+1 832 290 9522
+91 98250 31415
Book a 30 mins call
database

How to avoid duplicate entry of a record in database when user hits refresh.

Alex
March 30, 2010
ASP.NET Development, Dot Net Development

Problem

In case we are saving data in database on click of a button, and what happens if a user hits refresh??
The data will be saved twice in the database. How can we avoid this behavior??

Solution

Here is the solution in case the website is being developed in asp.net version 1.1 + with C# as the scripting language. The below implementation is designed by keeping “Order of page lifecycle events” in mind. The event order is Page_Load => btnSubmit_Click => Page_PreRender. The following code can be implemented to avoid the problem.

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Session[“RefrechCheck”] = DateTime.Now.ToString();
}
}
protected void Page_PreRender(object sender, EventArgs e)
{
ViewState[“RefrechCheck”] = Session[“RefrechCheck”];
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (Page.IsValid && Session[“RefrechCheck”].ToString() == ViewState[“RefrechCheck”].ToString())
{
Session[“RefrechCheck”] = DateTime.Now.ToString();
int result = SaveComment();
}
}

Happy coding.

Table of Contents

  1. Problem
  2. Solution

Tags Cloud

ASP.NET Development Services ASP.NET Development Solutions Concept Infoway
Recent News Post
Advantages of ASP.NET Development
Sep10

Advantages of ASP.NET Development

ASP.Net is a powerful framework used for the development of dynamic web pages, website and web based applications....
View More
Benefits of Outsourcing Software Development to India
Jan20

Benefits of Outsourcing Software Development to India

The most successful business strategy adopted by organizations worldwide today is certainly outsourcing their software development requirements to...
View More