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?