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