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