private void addUser_Load(object sender, EventArgs e) { List<item> items = new List<item>(); MySqlDataReader sdr; sdr = db.GetDataReader("SELECT district.`name`,district.`id` FROM district"); while (sdr.Read()) { item it = new item(sdr[0].ToString(), sdr[1].ToString()); items.Add(it); } cb_district.DataSource = items; // items.Clear(); sdr.Close(); sdr = db.GetDataReader("SELECT grid.`name`,grid.id FROM district INNER JOIN grid ON grid.district = district.id WHERE district.id = 1"); while (sdr.Read()) { item it = new item(sdr[0].ToString(), sdr[1].ToString()); items.Add(it); } cb_grid.DataSource = items; // items.Clear(); sdr.Close(); sdr = db.GetDataReader("SELECT block.`name`,block.id FROM grid INNER JOIN block ON block.grid = grid.id WHERE grid.id = 1"); while (sdr.Read()) { item it = new item(sdr[0].ToString(), sdr[1].ToString()); items.Add(it); } cb_block.DataSource = items; // items.Clear(); sdr.Close(); }
private void cb_district_SelectionChangeCommitted(object sender, EventArgs e) { string index = null; List<item> items = new List<item>(); MySqlDataReader sdr; item it = (item)cb_district.SelectedItem; index = it.Value; sdr = db.GetDataReader("SELECT grid.`name`,grid.id FROM district INNER JOIN grid ON grid.district = district.id WHERE district.id = " + index); while (sdr.Read()) { item its = new item(sdr[0].ToString(), sdr[1].ToString()); items.Add(its); } sdr.Close(); cb_grid.DataSource = items; // cb_district.Text = sdr[0].ToString(); // items.Clear(); }