Hi,

I have textboxes, sqldatasource and <asp:controlparameter> to insert new records into a a data table. I find a strange thing. After clicking a button to enter a record into the table successfully, I refresh the page and another same record is entered into the table(there are 2 the same records)!!!

Please advise how to avoid this from happening?

 Gary 

Reponse.Redirect(CurrentPage)--After insert

HTH

Hi Friend,

Check the article ... It will solve ur problem

http://msdn2.microsoft.com/en-us/library/ms379557(vs.80).aspx

Actually whenever you refresh the page it requests the page against last event that was fired to the server. for example in your case you have button to postback and save the values to db. so when we click on that button it saves the values... that's fine :) but when you refresh the page after postback it will again fire the button postback event and will insert  a new record.

So solution is to redirect to another page or same page after adding the values so that if one refresh the page it will not effect your logic

Thanks for your kind help.