private void cmbItemType_SelectedIndexChanged(object sender, EventArgs e) { lbAllItems.Items.Clear(); possibleItems colPossibleItems = new possibleItems(); string sqlItems = ""; switch (cmbItemType.Text) { case "Armor": sqlItems = "select itemid,name from item_armor order by name;"; break; case "Basic": sqlItems = "select itemid,name from item_basic order by name;"; break; case "Furnishings": sqlItems = "select itemid,name from item_furnishing order by name;"; break; case "Usable": sqlItems = "select itemid,name from item_usable order by name;"; break; case "Weapons": sqlItems = "select itemid,name from item_weapon order by name;"; break; } if (connection3.State == ConnectionState.Closed) { connection3.Open(); } MySqlCommand myItemsCmd = new MySqlCommand(sqlItems, connection3); MySqlDataReader myItemReader = myItemsCmd.ExecuteReader(); while (myItemReader.Read()) { possibleItem pItem = new possibleItem(); pItem.id = Int32.Parse((myItemReader[0].ToString()), System.Globalization.NumberStyles.Integer); pItem.description = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(myItemReader[1].ToString().Replace('_', ' ')); colPossibleItems.add(pItem); } connection3.Close(); foreach (possibleItem item in colPossibleItems) { lbAllItems.Items.Add(item.description); } }
public virtual void add(possibleItem item) { this.List.Add(item); }