I have done something similar by using the beforeUpdate on the grid. I display a message box that asks if the user really wants to make the update and then call a stored procedure that I pass the datagrid values and the message box response to. Depending on the message box value I either commit or rollback the transaction.
