// if product combo box selected item changes updates the suppliers combobox
private void cmbProductBName_SelectedIndexChanged(object sender, EventArgs e)
{
List <Products_Suppliers> cbSuppliers = new List <Products_Suppliers>();
try
{
if (cmbProductBName.SelectedIndex != -1)
{
cbSuppliers = Products_SuppliersDB.GetAllProdSupOnProdID((int)cmbProductBName.SelectedValue);
cmbSuppliers.DataSource = cbSuppliers;
cmbSuppliers.DisplayMember = "SupName";
cmbSuppliers.ValueMember = "ProductSupplierId";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}