private void AddProductsWithSuppliers_Load(object sender, EventArgs e)
{
//// TODO: This line of code loads data into the 'travelExpertsDataSet.Products' table. You can move, or remove it, as needed.
//this.productsTableAdapter.Fill(this.travelExpertsDataSet.Products);
//// TODO: This line of code loads data into the 'travelExpertsDataSet.Products_Suppliers' table. You can move, or remove it, as needed.
//this.products_SuppliersTableAdapter.Fill(this.travelExpertsDataSet.Products_Suppliers);
//// TODO: This line of code loads data into the 'travelExpertsDataSet.Packages_Products_Suppliers' table. You can move, or remove it, as needed.
//this.packages_Products_SuppliersTableAdapter.Fill(this.travelExpertsDataSet.Packages_Products_Suppliers);
ProductBox.DataSource = jamesProductsDB.GetProducts();
ProductBox.DisplayMember = "ProdName";
ProductBox.ValueMember = "ProductId";
SuppliersBox.DataSource = SuppliersFunctions.GetSuppliers();
SuppliersBox.ValueMember = "SupplierId";
SuppliersBox.DisplayMember = "SupName";
//((DataGridViewComboBoxCell)dgvRow.Cells[2]).Value =
// supplierIdPairs[indOfRightElement].SupplierId;
}
private void UpdateSuppliersAndProducts_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'travelExpertsDataSet.Products_Suppliers' table. You can move, or remove it, as needed.
//this.products_SuppliersTableAdapter.Fill(this.travelExpertsDataSet.Products_Suppliers);
//DISPLAYS THE DATA IN TEH FORM
relationshipInitial.DataSource = SuppliersFunctions.GetRelations();
relationshipInitial.DisplayMember = "ProductSupplierId";
relationshipInitial.ValueMember = "ProductSupplierId";
productNew.DataSource = jamesProductsDB.GetProducts();
productNew.DisplayMember = "ProdName";
productNew.ValueMember = "ProductId";
supplierNew.DataSource = SuppliersFunctions.GetSuppliers();
supplierNew.ValueMember = "SupplierId";
supplierNew.DisplayMember = "SupName";
//productCurrent.Source = SuppliersFunctions.GetRelations();
//productCurrent.Text =
//supplierCurrent.Text =
}