im using a sqldataadapter, dataset and bindingsource to connect to a table. i retrieve all records from the database and i change the data on a field then update changes to database. when i try to change back to original value i get a Concurrency violation error (concurrency violation: The updatecommand affected 0 of the expected 1). this is the code:

Code:
  1. Try
  2.             Me.Validate()
  3.             Me.sqlBindingSource.EndEdit()
  4.  
  5.             Dim slqCmdBuilder As New SqlCommandBuilder(sqlAdapter)
  6.  
  7.             Me.sqlAdapter.Update(Me.sqlDs.Tables("Items"))
  8.  
  9.             slqCmdBuilder.Dispose()
  10.             slqCmdBuilder = Nothing
  11.  
  12.             Me.sqlBindingSource.ResetBindings(True)
  13.  
  14. Catch ex As Exception
  15.             MessageBox.Show(ex.Message, "Ειδοποίηση", MessageBoxButtons.OK, MessageBoxIcon.Error)
  16. End Try

can anyone help me plz?