You can control which exception is thrown by setting the Errors property to the desired exception.
Using one of the other values for Status prevents an exception from being thrown.
The following table shows the values to which you can set the Status property in order to control later actions during the update.
If we move our mouse on to the variables, which hold the cell values, we can see the old value instead of new updated value (Refer the debugging Screen Shot at the Top). When I click on the edit button the update and cancel button appear.You can add error information to the Data Set, as well as retry logic, and so on.The Row Updating Event Args and Row Updated Event Args arguments passed to the Row Updating and Row Updated events include the following: a Command property that references the Command object being used to perform the update; a Row property that references the Data Row object containing the updated information; a Statement Type property for what type of update is being performed; the Table Mapping, if applicable; and the Status of the operation.I'll try to address your question, but I'm also going through some of the other problems here.
Without seeing your markup, it's hard for me to tell if you've created .Also i noticed one thing if i Auto Generate the Columns All events are fired without any problems but if i use Template Field only Edit Event is fired that is only once.Sorry i know i'm posting a lot of comments on my own question.As a result, you can use Row Updating to modify update behavior before it happens, to provide additional handling when an update will occur, to retain a reference to an updated row, to cancel the current update and schedule it for a batch process to be processed later, and so on.Row Updated is useful for responding to errors and exceptions that occur during the update.This could result in exceptions being swallowed (even though they are logged) and then the program can continue in an unknown state.