populating a form with data from a SQL server then updating

Question

Hello I wrote a form which so far just consists of text fields and checkboxes. The data from previous entries is loaded when the page loads and then I set the values of each field (for example contactname.Text = dbread[contactname].ToString();). The problem is that when I populate the fields on page load the stored procedure I'm using to update the values uses this information rather than the information actually current in the TextBoxes. I want users to be able to change and update the information but also have it preloaded with the last data they submitted. Any advice would be greatly appreciated. Thanks.

Krishna Garad · Answer

Hi Mike Generally this type of situation occurs when u r allowing the page postback event fire again and again. For u r problame just write u r page lod code in if(!IsPostBack) { //Your Code.... } now u r able to get the changed value of textboxes. This is becaus when u r updating the textboxes with new value at that time u r page postback event is firing and the old values from database are populating ur texboxes that's why u r not able to change the value in updating event try this if any further ask again Hope this para will teach u the effect of form postback event.

Mike Chambers · Answer

Thanks. That was exactly what I was looking for...it works as expected now.

populating a form with data from a SQL server, then updating