Just to provide background, as part of my UI, I have DataGrid, TreeView and a button and using these 3 controls I'm trying to build SQL tables. My DataGrid is populated based on the node selected in TreeView and on click of button SQL table is created.
User has the flexibility to edit/delete data in DataGrid and same will be updated in DB using PositionChanged event. Now error is coming in this event.
Reason: Reason was ADO.Net uses Optimistic Concurrency (by default) which means, even if a single cell is edited, whole row will be compared against DB. So, issue comes when you are trying to update a row which is no longer present. Hence update fails.