ASP.NET 4 Unleashed

Canceling Command Execution

You can cancel SqlDataSource commands when some criterion is not met. For example, you might want to validate the parameters that you use with the command before executing the command.

You can cancel a command by handling any of the following events exposed by the SqlDataSource control:

• Deleting— Happens immediately before the SqlDataSource executes its delete command.

• Filtering— Happens immediately before the SqlDataSource filters its data.

• Inserting— Happens immediately before the SqlDataSource executes its insert command.

• Selecting— Happens immediately before the SqlDataSource executes its select command.

• Updating— Happens immediately before the SqlDataSource executes its delete command.

For example, the ...