Hi

      I need to add, delete ,update data into Ms access 2003 database table in Window application. I have created dataset and tabledataadpater. Changes are work fine with dataset but not refelacts in to database.
This is my code ...

Private Sub ProductsBindingNavigatorSaveItem_Click
        Me.Validate()
        Me.ProductsBindingSource.EndEdit()
        Me.ProductsTableAdapter.Update(Me.ProductdbDataSet .Products)

    End Sub

Private Sub products_Load
      Me.ProductsTableAdapter.Fill(Me.ProductdbDataSet.P roducts)

End Sub

add new , save does not work with access database


Pl give solution if any one knows....