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
}
}
