page refresh with response.redirect vs server.transfer
ASP.NET 2.0 VS2005
I have an ASP.NET application that is highly transactional. i.e about 20 text boxes on each page and data collected from each page updated to a SQL database . Lets call one of the pages myPage.aspx. The user enters data for the 20 or so textboxes and the hits an "Update" button which inserts a record to the SQL database. The users needs to start the next record.
Currently I am simply using response.redirect("myPage.aspx") to reload the page and effectively clear the text boxes ready for the next transaction.
Is reloading the page with respons.redirect the best way of refreshing page textboxes and datagrids?
I am considering server.transfer("myPage.aspx") because it is more economical but it seems odd. i.e to transfer page 'focus' on itself. I have only used this when progessing to another page and not for page reload.
I just need advise on what would be the best practice in a case like this.