private void displayProductTypes() { string selectQuery = "SELECT * FROM ProductTypes"; List <Product_Types_Class> productTypesList = new List <Product_Types_Class>(); try { using (var con = ConnectionManager.DatabaseConnection()) using (var cmd = new SqlCommand(selectQuery, con)) using (var rdr = cmd.ExecuteReader()) { while (rdr.Read()) { var producttypes = new Product_Types_Class (int.Parse(rdr["ProductTypeID"].ToString()), rdr["ProductType"].ToString()); productTypesList.Add(producttypes); } dgProductTypesView.DataSource = productTypesList; } } catch { } }
private void frmProductsAdd_Load(object sender, EventArgs e) { //Pulling the Product Types into the combo box when form loads //~~~~~~~~~~~~~~~~~~~~~doesn't work, but it DOES work in ProductTypes string populateProductID = "SELECT * FROM ProductTypes"; List <Product_Types_Class> productTypeIDList = new List <Product_Types_Class>(); try { using (var con = ConnectionManager.DatabaseConnection()) using (var cmd = new SqlCommand(populateProductID, con)) using (var rdr = cmd.ExecuteReader()) { while (rdr.Read()) { var producttypeID = new Product_Types_Class(int.Parse(rdr["ProductTypeID"].ToString()), rdr["ProductType"].ToString()); productTypeIDList.Add(producttypeID); } } cbProductTypeID.DataSource = productTypeIDList; cbProductTypeID.DisplayMember = "ProductTypeID"; } catch { //catch error here } }
private void frmProductTypes_Load(object sender, EventArgs e) { displayProductTypes(); string populateProductTypeID = "SELECT * FROM ProductTypes"; List <Product_Types_Class> productTypeIDList = new List <Product_Types_Class>(); try { using (var con = ConnectionManager.DatabaseConnection()) using (var cmd = new SqlCommand(populateProductTypeID, con)) using (var rdr = cmd.ExecuteReader()) { while (rdr.Read()) { var producttypeID = new Product_Types_Class(int.Parse(rdr["ProductTypeID"].ToString()), rdr["ProductType"].ToString()); productTypeIDList.Add(producttypeID); } } cbProductType.DataSource = productTypeIDList; cbProductType.DisplayMember = "ProductTypeID"; } catch { //catch error here } }