private void fillSkillsList()
{
AODB aodb = new AODB();
DataTable dt = aodb.Query("SELECT DISTINCT value1 FROM tblItemEffects INNER JOIN tblAO ON (tblItemEffects.aoid=tblAO.aoid AND (tblAO.type='Weapon' OR tblAO.type='Armor' OR tblAO.type='Implant' OR tblAO.type='Spirit') AND tblItemEffects.type=53 AND tblItemEffects.value1!=214);");
List <string> skills = new List <string>();
foreach (DataRow dr in dt.Rows)
{
string name = ConfigurationManager.AppSettings[dr["value1"].ToString()];
skills.Add(name);
}
skillsList.DataSource = skills;
}
private void fillSkillsList()
{
AODB aodb = new AODB();
DataTable dt = aodb.Query("SELECT DISTINCT value1 FROM tblItemEffects INNER JOIN tblAO ON (tblItemEffects.aoid=tblAO.aoid AND (tblAO.type='Weapon' OR tblAO.type='Armor' OR tblAO.type='Implant' OR tblAO.type='Spirit') AND tblItemEffects.type=53 AND tblItemEffects.value1!=214);");
List<string> skills = new List<string>();
foreach(DataRow dr in dt.Rows) {
string name = ConfigurationManager.AppSettings[dr["value1"].ToString()];
skills.Add(name);
}
skillsList.DataSource = skills;
}
