private void ListBoxTagGroup_SelectedIndexChanged(object sender, EventArgs e) { listBoxTag.Items.Clear(); if (ListBoxTagGroup.SelectedItem == null) { return; } string tagGroupName = ListBoxTagGroup.SelectedItem.ToString(); int group_id = cap_map_tag_group[tagGroupName].id; string sqlcmd = string.Format("SELECT * FROM edu.tag_def where is_valid = 1 and group_id ={0} ;", group_id); var tags = globalDB.ExeQuery(sqlcmd, false); while (tags.Read()) { Db_struct.Tag_def tag = new Db_struct.Tag_def(); tag.id = Convert.ToInt32(tags.GetString(0)); tag.caption = tags.GetString(1); if (!cap_map_tag.ContainsKey(tag.caption)) { cap_map_tag.Add(tag.caption, tag); } listBoxTag.Items.Add(tag.caption); // ListBoxTagGroup. } }
private static void ReadTagList() { string sqlcmd = string.Format("SELECT * FROM edu.tag_def where is_valid = 1;"); var tags = globalDB.ExeQuery(sqlcmd, false); while (tags.Read()) { Db_struct.Tag_def tag = new Db_struct.Tag_def(); tag.id = Convert.ToInt32(tags.GetString(0)); tag.caption = tags.GetString(1); tag_list.Add(tag); // ListBoxTagGroup. } }