An unhandled exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in WindowsApplication1.exe

Question

I have made a simple project and connected it to a database through datasource. But when I am adding a record or trying to update any record through table adapters it gives me "An unhandled exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in WindowsApplication1.exe" error.

I used the simple normal code for updating:

Private Sub EmpBindingNavigatorSaveItem1_Click(sender As Object, e As EventArgs) Handles EmpBindingNavigatorSaveItem1.Click
        Me.Validate()
        Me.EmpBindingSource.EndEdit()
        Me.TableAdapterManager.UpdateAll(Me._MyDatabase_2DataSet)
    End Sub

Could you please help me out with this....

Saniya

Answer 1

Please catch the error, and see what the exact error message is.

---

Please mark as answer, if this was it. Visit my SQL Server Compact blog