public List <Equipments> GetEquipments() { List <Equipments> equipments = new List <Equipments>(); con.Open(); using (var cmd = new MySqlCommand("Select * from Equipments", con)) { using (var reader = cmd.ExecuteReader()) { Equipments equipment; while (reader.Read()) { equipment = new Equipments(reader.GetInt32("EquipmentId"), reader.GetString("EquipmentName"), reader.GetInt32("EquipmentQuantityInStock")); equipments.Add(equipment); } } } con.Close(); return(equipments); }
private void frmPlushDecorateAndOrder_Load(object sender, EventArgs e) { equipment = new Equipments(); FillCheckedListBoxEquipments(); }