Updating table data

[maxcad]

I am a novice so be patient with me. I started a simple form and dragged the datasource onto the form and VB created everything nicely including the navigation bar. The problem is that the save button has no code behind it to update the sql database. Using the code on the msdn site shows an error, so I modified it as follows. It shows no errors but fails when run.

        Try
            Me.Validate()
            Me.OTQ_CUST_UNITBindingSource.EndEdit()
            Me.TableAdapterManager.UpdateAll(VM_Sandbox2DataSet)
            MsgBox("Update successful")
            OTQ_CUST_UNITBindingNavigatorSaveItem.Enabled = False
        Catch ex As Exception
            MsgBox("Update failed")
        End Try
 

Any insights would be appreciated.