// 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()); } }