In todays post i will tell you how you can avoid repeated insertion of records into database due to page refresh.
In asp.net when you insert a record the page posts back to the server and when ever you refresh the page that postback is repeated due to which the record is inserted again into the database. This is a big problem we don't want that so we want to avoid postback on page refresh.
So here are the ways you can handle this problem.
here is the markup for the page:
Markup:
CSharp:
When the page loads the first time a ViewState "HasPosted" is stored with value false and when data is inserted the value is changed to true. Data can only be inserted once by using this technique. When you press the insert button again after first insertion an error message will popup and if you try to repeat the insertion by refreshing the page you will see the error message.
In asp.net when you insert a record the page posts back to the server and when ever you refresh the page that postback is repeated due to which the record is inserted again into the database. This is a big problem we don't want that so we want to avoid postback on page refresh.
So here are the ways you can handle this problem.
- By avoiding the duplicate postback
- By redirecting to another page after saving data
- By using ViewState to check if data is already inserted
here is the markup for the page:
Markup:
1: <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
2: <!DOCTYPE html>
3: <html xmlns="http://www.w3.org/1999/xhtml">
4: <head runat="server">
5: <title></title>
6: </head>
7: <body>
8: <form id="form1" runat="server">
9: <div>
10: <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Insert Data" />
11: </div>
12: </form>
13: </body>
14: </html>
CSharp:
1: using System;
2: using System.Collections.Generic;
3: using System.Linq;
4: using System.Web;
5: using System.Web.UI;
6: using System.Web.UI.WebControls;
7: public partial class _Default : System.Web.UI.Page
8: {
9: protected void Page_Load(object sender, EventArgs e)
10: {
11: if (!IsPostBack)
12: ViewState["HasPosted"] = false;
13: }
14: protected void Button1_Click(object sender, EventArgs e)
15: {
16: bool posted = (bool)ViewState["HasPosted"];
17: if (!posted)
18: {
19: //Data Insertion code here
20: //here you can do the tasks which you want do to do just on the the first click of the button for example inserting data into database
21: Response.Write("<script type='text/javascript'>alert('Data Inserted Successfully!!');</script>");
22: ViewState["HasPosted"] = true;
23: }
24: else Response.Write("<script type='text/javascript'>alert('Already Inserted');</script>");
25: }
26: }
When the page loads the first time a ViewState "HasPosted" is stored with value false and when data is inserted the value is changed to true. Data can only be inserted once by using this technique. When you press the insert button again after first insertion an error message will popup and if you try to repeat the insertion by refreshing the page you will see the error message.
