So what you need to do is store the data source (maybe in Session) and only bind rebind the data when you absolutely need to (Like during the Is Not Post Back) Do you understand?
Please post the code for your Page_Load method and the that handles your Update (your C# code) so we can have a better look at what's going on. Please give some references and/or details of how to. This wipes out the data provided by the user during editing (editing happens after the page load).
The data adapter has a Fill Error event that occurs during a fill method.
As you can see from listing 9-3, I used Data Fill Error Event Args's members to get information about the error.Listing 9-4 and 9-5 show the code for the Row Updated and Row Updating event handlers.For example, Fill Error could occur when you can't convert data from data from a database to Common Language Runtime (CLR) type without losing precision or when data type casting is not valid.Fill Error Event Handler handles the Fill Error event.In this article I will explain how to edit master-detail form using Grid View and Details View control in ASP.
NET Download source code Introduction In one of my previous article I explained how to Master-Detail form using Grid View and Details View in ASP. In this ariticle I will explain how to edit a master/detail form in ASP. Something that has been said many times, but needs constant repeating until every developer is aware of its importance, is the performance difference between row-by-row updating and bulk updating. Let me ask this differently: The best way to find out is to benchmark.If you cannot guess which one will be much faster, remember that row-by-row kinda rhymes with "slow-by-slow" (hint, hint). I'm doing two benchmarks for this: Run 1, Statement 1 : .01457 (avg : .0098) Run 1, Statement 2 : .0133 (avg : .01291) Run 1, Statement 3 : .02351 (avg : .02519) Run 2, Statement 1 : .00882 (avg : .0098) Run 2, Statement 2 : .01159 (avg : .01291) Run 2, Statement 3 : .02348 (avg : .02519) Run 3, Statement 1 : .01012 (avg : .0098) Run 3, Statement 2 : .01453 (avg : .01291) Run 3, Statement 3 : .02544 (avg : .02519) Run 4, Statement 1 : .00799 (avg : .0098) Run 4, Statement 2 : .01346 (avg : .01291) Run 4, Statement 3 : .02958 (avg : .02519) Run 5, Statement 1 : .00749 (avg : .0098) Run 5, Statement 2 : .01166 (avg : .01291) Run 5, Statement 3 : .02396 (avg : .02519) The difference between Statement 1 and 3 is a factor of 2.5x.The Statement Type enumeration defines Select, Insert, Update, and Delete members.Now, to test these events you can write code that fills a dataset and calls the update method of data adapter.You call the Row Updated event handler when a row is updated using the Update method of a data adapter, and you call Row Updating when a row is updating.