How to make the DataGridView save correctly when the data changes?

Question

C++ / C#

oleDbDataAdapter->Update(dataSet->Tables["Название таблицы"]);

I save like this, but instead of saving only the record that was edited, all other records in the table are replaced by the edited record. How to fix?
I use the following sql code to update records:

UPGRADE table
SET column1 = ?, column2 = ?, column3 = ?, column4 = ?

Answer 1

And where WHERE, of course, UPDATE in this form updates all records, one more column with record Id is needed.
Here is an example https://msdn.microsoft.com/ru-ru/library/system.da... (v=vs.110).aspx