Updating database from datagridview
You can prevent a concurrency violation by filling another dataset with the updated records from the data source and then performing a merge to prevent a concurrency violation.
(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 you're familiar with Table Adapters, you can jump directly to one of these topics: Updating a data source is a two-step process.Introduction A Data Grid View control can be used to display data from a database.