private void populateGearTable() { DataTable gearTable = new DataTable(); gearTable.Columns.Add("ID", typeof(int)); gearTable.Columns.Add("Naziv", typeof(string)); gearTable.Columns.Add("Proizvođač", typeof(string)); gearTable.Columns.Add("Kategorija", typeof(string)); gearTable.Columns.Add("Opis", typeof(string)); gearTable.Columns.Add("Veličina", typeof(string)); gearTable.Columns.Add("Ukupno", typeof(int)); gearTable.Columns.Add("Dostupno", typeof(int)); allGear = GearDAO.getAllDetailed(); foreach (var g in allGear) { gearTable.Rows.Add(g.gear_id, g.name, g.manufacturer_name, g.gear_category_name, g.description, g.size_value, g.quantity, g.available ); } dataGridViewGear.DataSource = gearTable; cBoxGearSearchCategory.Items.AddRange(GearDAO.getAllCategories().ToArray()); }
private void AddGearForm_Load(object sender, EventArgs e) { manufacturers = GearDAO.getAllManufacturers(); categories = GearDAO.getAllCategories(); gearSizes = GearDAO.getAllSizes(); gearItemsDetailed = GearDAO.getAllDetailed(); cBoxGearName.Items.AddRange(gearItemsDetailed.ToArray()); cBoxGearCategory.Items.AddRange(categories.ToArray()); cBoxGearManufacturer.Items.AddRange(manufacturers.ToArray()); cBoxGearSize.Items.AddRange(gearSizes.ToArray()); }