concurrency violation: The updatecommand affected 0 of the expected 1

[dkotoupas]

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:

Try
            Me.Validate()
            Me.sqlBindingSource.EndEdit()
 
            Dim slqCmdBuilder As New SqlCommandBuilder(sqlAdapter)
 
            Me.sqlAdapter.Update(Me.sqlDs.Tables("Items"))
 
            slqCmdBuilder.Dispose()
            slqCmdBuilder = Nothing
 
            Me.sqlBindingSource.ResetBindings(True)
 
Catch ex As Exception
            MessageBox.Show(ex.Message, "Ειδοποίηση", MessageBoxButtons.OK, MessageBoxIcon.Error)
End Try

can anyone help me plz?

[MarMan]

Are you changing the primary key?

[dkotoupas]

i not changing the primary key nut i think i fihured it out. theres a trigger on my table that automatically updates the last date & time the record is changed. when i create my sqldata adapter i do a "select * from table" which in turn retrieves this record. i think that if i select all fields except this datetime field i soulded have a problem. whats your oppion?

[dkotoupas]

i was right. creating a script without the last update datetime of the record fixed the problem. thnx anyway

[Shaggy Hiker]

That's a very annoying problem, so it is good that you found such a rational solution.