First let's take a look at the simple update which does not dynamically assign the parameters.
In the example below I am using a simple Grid View control and updating the User Name, First Name and Last Name.
Sql Data Source allows you to Select/Insert/Update/Delete the data from the database without even writing a single line of code.
But sometimes you need to dynamically assign a parameter.
Can this article help me with this issue: I have a procedure in Oracle, that create a temporary table with output data.
After a record is successfully updated, the Updated event is handled by an event handler to perform a post-processing step where an e-mail message notification is sent.
event to perform additional initialization operations that are specific to your application, to validate the values of parameters, or to change the parameter values before the Sql Data Source control performs the update operation.
You cannot use Control Parameter since the name of the Text Box for each Grid View row is different.
You can however add assign the parameter in the Sql Data Source Updating event.
Do you have a way that I can track the @original Order ID and @Order Total parameter's value before the update occurs?