Help!!!!!! TableAdapter Or BindingSource ?
-
Hi, my question is thus: i created a master detail entry form, i have to insert the master record before the detail record. :(( the issue is the master does not insert here is the code:
private bool Save() { bool saved = false; Validate(); fACTORY_PURCHASEBindingSource.EndEdit(); fACTORY_ITEMSBindingSource.EndEdit(); FactoryDataSet.FACTORY_PURCHASEDataTable newInvoice = (FactoryDataSet.FACTORY_PURCHASEDataTable) factoryDataSet.FACTORY_PURCHASE.GetChanges(DataRowState.Added); FactoryDataSet.FACTORY_ITEMSDataTable newItems = (FactoryDataSet.FACTORY_ITEMSDataTable) factoryDataSet.FACTORY_ITEMS.GetChanges(DataRowState.Added); FactoryDataSet.FACTORY_PURCHASEDataTable deleteInvoice = (FactoryDataSet.FACTORY_PURCHASEDataTable) factoryDataSet.FACTORY_PURCHASE.GetChanges(DataRowState.Deleted); FactoryDataSet.FACTORY_ITEMSDataTable deleteItems = (FactoryDataSet.FACTORY_ITEMSDataTable) factoryDataSet.FACTORY_ITEMS.GetChanges(DataRowState.Deleted); try { if (newInvoice != null || newItems != null) { fACTORY_PURCHASETableAdapter.Update(newInvoice); fACTORY_ITEMSTableAdapter.Update(newItems); } if(deleteInvoice != null || deleteItems != null) { fACTORY_ITEMSTableAdapter.Update(deleteItems); fACTORY_PURCHASETableAdapter.Update(deleteInvoice); } factoryDataSet.AcceptChanges(); saved = true; } catch (Exception ex) { MessageBox.Show(ex.Message); } return saved; }