If an update on a row would result in a violation of a primary key or unique index, the update on that row is not performed.
Alternatively, the Sql Data Source can be used in place of the Object Data Source.Recall that to support inserting, updating, and deleting, with the Object Data Source we needed to specify the object layer methods to invoke to perform the insert, update, or delete action. Concurrency is always tricky, but I am assuming that you just want your updates to win. Refresh Object State Manager entrie So you have an entity that is updated, and you want to update it in the database with the least amount of code...The columns that are not on the list retain their original values.
If IGNORE is provided, all errors encountered during the update are ignored.
Refer back to the Examining the Events Associated with Inserting, Updating, and Deleting tutorial for a more detailed discussion on the chain of events associated with inserting, updating, and deleting from a data Web control.
Figure 5: Clicking the Delete Button in the Grid View Invokes the Sql Data Source s SQL statements can be specified through the Properties window or the control s declarative syntax.
Select the Delete Query property, which will bring up a set of ellipses.
Figure 2: Select the Delete Query Property from the Properties Window provide a value for this parameter (leave its Parameter source at None ).
Here is how I did it for my same case and modified the names to mimic your classes.