To use rowupdating
I put a breakpoint on the Row Updating event handler and found that the event is not fired. I put a breakpoint on the Row Updating event handler and found that the event is not fired. In the Row Editing function, the edit textboxes appear and I can get the "old" values Then the page renders, I edit the textboxes and hit Update.
This does save a lot of time on the network and all the layers in between.
are iterated over and each parameter variable in the update statement is replaced with the value for that parameter. Event Args e) private void da_Row Updating(object sender, Sql Row Updating Event Args e) object.
Single quote delimiters are added around the string values. The solution delimits the string values for the Category Name and Description fields in the Categories table from the Northwind database used in this example.
private void Custom Adapter Batch Update Form_Load(object sender, System.
One thing to keep in mind: the solution code iterates in reverse order through the parameters collection so that parameters are replaced correctly if there are more than nine parameters; if they were processed in forward order, parameter , and so on.