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?

Question

There are 2 textbox on web Page say First Name, Last Name, etc.

And a Button called Insert Records.

On Click of Insert Button, records get inserted. After inserting the records, If you refresh the page, it will again insert records.

How can you prevent it?

Arshad · Answer

Hi you can do this some thing like that in the Click Event of your save button just add on condition at the top using the ViewState if(ViewState[Khan]==null) { //your code for Adding the Data in your database //after that just assign the value to the viewstate some thing like that ViewState[Khan].ToString()==Done } I hope it should work please check it n let me know. Thanks

zafar jaffary · Answer

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

Kirtan Patel · Answer

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

Niradhip Chakraborty · Answer

After saving the recordsplease empty the text field. If possible please send us the codeWe will try to solve it.

Vijaya Kadiyala · Answer

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

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?