private void MySetProduct() { db = new SalesDBMF(); var ProQ = from ProList in db.products select ProList.product_id; foreach (int ProID in ProQ) { cbProductID.Items.Add(ProID); } cbProductID.SelectedIndex = 0; }
private void MySetCategories() { db = new SalesDBMF(); var CateQ = from CateList in db.categories select CateList.category_id; foreach (int CateID in CateQ) { cbCateID.Items.Add(CateID); } cbCateID.SelectedIndex = 0; }
private void MySetOrder() { db = new SalesDBMF(); var OrdQ = from OrdList in db.orders select OrdList.order_id; foreach (int OrdID in OrdQ) { cbOrdersID.Items.Add(OrdID); } cbOrdersID.SelectedIndex = 0; }
private void MySetCustomer() { db = new SalesDBMF(); var CusQ = from CusList in db.customers select CusList.customer_id; foreach (string CusID in CusQ) { cbCusto.Items.Add(CusID); } cbCusto.SelectedIndex = 0; }
private void MySetBrand() { db = new SalesDBMF(); var BrQ = from BraList in db.brands select BraList.brand_id; foreach (int BraID in BrQ) { cbBrandID.Items.Add(BraID); } cbBrandID.SelectedIndex = 0; }
private void MySetStore() { db = new SalesDBMF(); var STOQ = from StoList in db.stores select StoList.store_id; foreach (string StoID in STOQ) { cbStore.Items.Add(StoID); } cbStore.SelectedIndex = 0; }
private void MySetStaff() { db = new SalesDBMF(); var StaQ = from StaList in db.staffs select StaList.staff_id; foreach (string StaID in StaQ) { cbStaff.Items.Add(StaID); } cbStaff.SelectedIndex = 0; }
private void MySetDistrict() { db = new SalesDBMF(); var DistQ = from DistList in db.districts select DistList.district_name; foreach (string DistName in DistQ) { cbDist.Items.Add(DistName); } cbDist.SelectedIndex = 0; }
private void MySetProvince() { db = new SalesDBMF(); var ProvQ = from ProvList in db.provinces select ProvList.province_name; foreach (string ProvName in ProvQ) { cbProv.Items.Add(ProvName); } cbProv.SelectedIndex = 0; }
private void MySetCategory() { db = new SalesDBMF(); var CateQ = from CateList in db.categories select CateList; DataTable dt = new DataTable(); dt.Columns.Add("Category_ID"); dt.Columns.Add("Category_Name"); foreach (var p in CateQ) { dt.Rows.Add(p.category_id, p.category_name); } dtGridView.DataSource = dt; }
private void MySetBrand() { db = new SalesDBMF(); var BrandQ = from BraList in db.brands select BraList; DataTable dt = new DataTable(); dt.Columns.Add("Brand_ID"); dt.Columns.Add("Brand_Name"); foreach (var p in BrandQ) { dt.Rows.Add(p.brand_id, p.brand_name); } dtGridView.DataSource = dt; }
private void MySetProvince() { db = new SalesDBMF(); var ProvinceQ = from ProvList in db.provinces select ProvList; DataTable dt = new DataTable(); dt.Columns.Add("Province_ID"); dt.Columns.Add("Province_Name"); foreach (var p in ProvinceQ) { dt.Rows.Add(p.province_id, p.province_name); } dtGridView.DataSource = dt; }
private void MySetStore() { db = new SalesDBMF(); var StoQ = from StoreList in db.stores select StoreList; DataTable dt = new DataTable(); dt.Columns.Add("Store_ID"); dt.Columns.Add("Store_Name"); dt.Columns.Add("Phone"); dt.Columns.Add("Email"); dt.Columns.Add("Street"); dt.Columns.Add("City"); dt.Columns.Add("State/Province"); dt.Columns.Add("Zipcode"); foreach (var p in StoQ) { dt.Rows.Add(p.store_id, p.store_name, p.phone, p.email, p.street, p.city, p.state, p.zip_code); } dtGridView.DataSource = dt; }
private void MySetCustomer() { db = new SalesDBMF(); var CusQ = from CusList in db.customers select CusList; DataTable dt = new DataTable(); dt.Columns.Add("Customer_ID"); dt.Columns.Add("First_Name"); dt.Columns.Add("Last_Name"); dt.Columns.Add("Phone"); dt.Columns.Add("Email"); dt.Columns.Add("Street"); dt.Columns.Add("City"); dt.Columns.Add("State/Province"); dt.Columns.Add("Zipcode"); foreach (var p in CusQ) { dt.Rows.Add(p.customer_id, p.first_name, p.last_name, p.phone, p.email, p.street, p.city, p.state, p.zip_code); } dtGridView.DataSource = dt; }