public ThemSinhVien(DbAccess db) : this() { this.DB = db; DB.dataKhoa = DB.GetListKhoa(null); for (int i = 0; i < DB.dataKhoa.Rows.Count; i++) { comboBoxKhoa.Items.Add(DB.dataKhoa.Rows[i]["Mã khoa"].ToString()); } DB.dataLop = DB.GetListLop(null); for (int i = 0; i < DB.dataLop.Rows.Count; i++) { comboBoxIDLop.Items.Add(db.dataLop.Rows[i]["Mã lớp"]); } }
void UpDateData() { db.dataLop = db.GetListLop(comboBoxKhoa.Text); if (db.dataLop.Rows.Count > 0) { dataGridView1.Rows.Clear(); dataGridView1.Visible = true; label2.Visible = true; txtTenKhoa.Visible = true; txtSiSo.Visible = true; txtSiSo.Text = db.dataLop.Rows.Count.ToString(); } for (int i = 0; i < db.dataLop.Rows.Count; i++) { dataGridView1.Rows.Add(i + 1, db.dataLop.Rows[i]["Mã lớp"], db.dataLop.Rows[i]["Tên lớp"], db.dataLop.Rows[i]["Sĩ số"], db.dataLop.Rows[i]["Niên khóa"]); } }