public void LoadDSLHP() { DSLHPbindingSource.DataSource = LopHocPhan_BUS.DanhSachLHP(); gcDSLHP.DataSource = DSLHPbindingSource; int soKhoa = cboKhoa.Items.Count; for (int i = 0; i < soKhoa; i++) { cboKhoa.Items.RemoveAt(0); } int soMonhoc = cboMonHoc.Items.Count; int soGiaoVien = cboGiaoVien.Items.Count; for (int i = 0; i < soMonhoc; i++) { repositoryItemComboBox1.Items.RemoveAt(0); cboMonHoc.Items.RemoveAt(0); } for (int i = 0; i < soGiaoVien; i++) { repositoryItemComboBox2.Items.RemoveAt(0); cboGiaoVien.Items.RemoveAt(0); } DataTable dtb = Khoa_BUS.LoadtenKhoa(); for (int i = 0; i < dtb.Rows.Count; i++) { string name = ChuanHoa(dtb.Rows[i][0].ToString().ToLower()); cboKhoa.Items.Add(name); } DataTable dtb1 = MonHoc_BUS.LoadtenMH(cboKhoa.Text); for (int i = 0; i < dtb1.Rows.Count; i++) { string name = ChuanHoa(dtb1.Rows[i][0].ToString().ToLower()); repositoryItemComboBox1.Items.Add(name); cboMonHoc.Items.Add(name); } DataTable dtb2 = GiaoVien_BUS.LoadtenGiaoVien(cboKhoa.Text); for (int i = 0; i < dtb2.Rows.Count; i++) { string name = ChuanHoa(dtb2.Rows[i][0].ToString().ToLower()); repositoryItemComboBox2.Items.Add(name); cboGiaoVien.Items.Add(name); } //cboMonHoc.ResetText(); //cboGiaoVien.ResetText(); }
public void loadInfo() { DataTable dtb1 = MonHoc_BUS.DSMH(); int t = cboMH.Items.Count; for (int i = 0; i < t; i++) { cboMH.Items.RemoveAt(0); } for (int i = 0; i < dtb1.Rows.Count; i++) { string name = dtb1.Rows[i][0].ToString(); cboMH.Items.Add(name); } cboMH.SelectedIndex = 0; tenMh = cboMH.Text; }
public void load_DS() { try { int t = gvSV.RowCount; for (int i = 0; i < t; i++) { bindingSource1.RemoveAt(0); } bindingSource1.DataSource = MonHoc_BUS.DSThiLai(tenMh); gcSV.DataSource = bindingSource1; } catch { MessageBox.Show("Load không thành công!"); } }
public static void InitDataBase() { BUS.SQLDataContext.CreateDataContext(); BaoCao = new BaoCao_BUS(); Diem = new Diem_BUS(); GiaoVien = new GiaoVien_BUS(); HocKy = new HocKy_BUS(); HocSinh = new HocSinh_BUS(); Lop = new Lop_BUS(); MonHoc = new MonHoc_BUS(); NamHoc = new NamHoc_BUS(); User = new User_BUS(); CaiDatBus = new CaiDat_BUS(); Data = new Data_BUS(); CaiDat = CaiDatBus.LoadDuLieuCaiDat(); IsLoaded = true; }
//các môn học, giáo viên thuộc khoa ... private void cboKhoa_SelectedIndexChanged(object sender, EventArgs e) { int soMonhoc = cboMonHoc.Items.Count; int soGiaoVien = cboGiaoVien.Items.Count; for (int i = 0; i < soMonhoc; i++) { repositoryItemComboBox1.Items.RemoveAt(0); cboMonHoc.Items.RemoveAt(0); } for (int i = 0; i < soGiaoVien; i++) { repositoryItemComboBox2.Items.RemoveAt(0); cboGiaoVien.Items.RemoveAt(0); } cboMonHoc.ResetText(); cboGiaoVien.ResetText(); DataTable dtb = MonHoc_BUS.LoadtenMH(cboKhoa.Text); for (int i = 0; i < dtb.Rows.Count; i++) { string name = ChuanHoa(dtb.Rows[i][0].ToString().ToLower()); repositoryItemComboBox1.Items.Add(name); cboMonHoc.Items.Add(name); } DataTable dtb1 = GiaoVien_BUS.LoadtenGiaoVien(cboKhoa.Text); for (int i = 0; i < dtb1.Rows.Count; i++) { string name = ChuanHoa(dtb1.Rows[i][0].ToString().ToLower()); repositoryItemComboBox2.Items.Add(name); cboGiaoVien.Items.Add(name); } //cboMonHoc.SelectedIndex = 0; }