(A concurrency violation occurs when another user modifies a record in the data source after the dataset has been filled.)To make changes to an existing data row, add or update data in the individual columns.If the dataset contains constraints (such as foreign keys or non-nullable constraints), it's possible that the record can temporarily be in an error state as you update it.When the merge is complete, if there are any constraints on the dataset that cannot be enabled, a Constraint Exception is thrown.
For more information about suspending events, see Turn off constraints while filling a dataset.
My data grid view data source is a Binding Source object that holds a Data Table as the data source.
Problem is, when I make changes via (my) Data Grid View object - the row State stays on 'unmodified' instead of modified; even though the values in the Data Table changed (that's what makes my update not work, since it consider the row State as undefined).
If you're familiar with Table Adapters, you can jump directly to one of these topics: Updating a data source is a two-step process.
The first step is to update the dataset with new records, changed records, or deleted records.
This means that if you try to update the original data source with the target dataset, it might not be able to find the original row to update.