On Save Button Click, it insert records, If you refresh again it will insert records.How can we prevent this from inserting on refreshing Page?

Hello

Did your problem solve already? I have the same problem. I have a button on my asp.net application it should insert new record if no record exist in the database otherwise update the record.

Can you help me out? if i give you my code?

Thanks

Redirect Browser to The Same page after Inserting Record into Database It Will Prevent Duplicate Record insert When you Refresh the page .

See Following Code Written by me

 protected void btnInsert_Click(object sender, EventArgs e)
        {
         
           
                con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFileName=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True");
                con.Open();
                Response.Write("Connection Success");
                comm = new SqlCommand();
                comm.Connection = con;
                comm.CommandText = "INSERT INTO users VALUES('" + txtUsername.Text + "','" + txtPassword.Text + "')";
                comm.ExecuteNonQuery();
                con.Close();
                Response.Redirect("~/default.aspx");
                showdata();
              
           
       
        }

Regards,

Hi,

You need to place Business Unique keys on the table columns  to avoid this.

Thanks -- Vj

http://dotnetvj.blogspot.com

http://oravj.blogspot.com