Datagrid edits not saved

[mattwagner]

Hi,

I have a MS Access 2003 (.mdb) database called "Assets.mdb" which I display in a datagrid. When I edit entries on the datagrid and click my save update/save button upon reloading of the application they have not been saved. What am I doing wrong?

Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click`

        Try
            Me.Validate()
            Me.AssetListBindingSource.EndEdit()
            Me.AssetListTableAdapter.Update(Me.AssetLink.AssetList)
            MsgBox("Update successful")
        Catch ex As Exception
            MsgBox("Update failed")
        End Try

    End Sub

But the strange thing is if i add a new row in at the borrom and click save, it will update and tay in the database?

Any Ideas?

Many Thanks