Sqldatasource updating event to check using the debugger
You can add a handler for these events to manipulate, reorder, or validate parameters for a statement before it is executed, as well as to cancel the command.For example, if you are using a events after the database operation completes.
because e.cancel is not available in updating event.
Edit My Grid View in my Sorry, but you're going to have to have some code in the code-behind!
Edit Looking at your code, I don't think you're ever binding your Grid View, so your Sql Data Source is never trying to select the data from your database.
Therefore, you cannot directly cancel the Update database operation by calling the Cancel method on the Db Command object that is exposed by the Sql Data Source Command Event Args object.
You can, however, cancel the database operation by setting the The following code example demonstrates how to display data that is retrieved from a Microsoft SQL Server database in a Drop Down List control and update the record using a Text Box control.