Updating Database From DataGrid

Question

I have a datagrid with a record bound to it from a database. The SELECT statement is of this form SELECT * FROM Table1 WHERE ID = @ID. I had VS generate the UPDATE and DELETE statements automatically. I do not understand why when I edit the datagrid for some records the data change is persisted in the database and for others it is not?

Algo Rhythm · Answer

Yes the column id is the primary key.

Kumar AG · Answer

Is your column ID is a primary key? http://msdn.microsoft.com/en-us/library/aa0416cz(VS.71).aspx MSDN: Note that it is recommended to always return a unique primary key value in your query. Otherwise the preceding UPDATE statement may update more than one row which might not be your intent.

Algo Rhythm · Answer

I found that checking 'Use Optimistic Concurrency' caused this problem but I do not understand why since there is only one user updating the data.

Algo Rhythm · Answer

I found that checking 'Use Optimistic Concurrency' caused this problem but I do not understand why since there is only one user updating the data.