views:

63

answers:

0

I created a database in ms access2007, created data source in c# from the my MS Access database.

I needed fields from two different tables on one form.

On the form I coded for the save button:

        try
        {
            this.Validate();
            this.entitiesBindingSource.EndEdit();
            this.product_DetailsBindingSource.EndEdit();
            this.entitiesTableAdapter.Update(this.iNSPRODataSet.Entities);
            this.product_DetailsTableAdapter.Update(this.iNSPRODataSet.Product_Details);
            MessageBox.Show("Update successful");
        }
        catch (System.Exception ex)
        {
            MessageBox.Show("Update failed");
        }

The entities Table gets updated in ms access, BUT the product_Details Table does not get updated.

Why and how do I fix up my mess?