private void FrmSinhVien_Load(object sender, EventArgs e) { cmbMaKhoa.DropDownStyle = ComboBoxStyle.DropDownList; cmbMaQue.DropDownStyle = ComboBoxStyle.DropDownList;; cmbMaLop.DropDownStyle = ComboBoxStyle.DropDownList; cmbMaDanToc.DropDownStyle = ComboBoxStyle.DropDownList; cmbMaChuyenNganh.DropDownStyle = ComboBoxStyle.DropDownList; cmbMaHDT.DropDownStyle = ComboBoxStyle.DropDownList; cmbMaChucVu.DropDownStyle = ComboBoxStyle.DropDownList; cbMaLop.DropDownStyle = ComboBoxStyle.DropDownList; LoadDatatogriview(); btnLuu.Enabled = false; sql = "select MaLop, TenLop from Lop"; DAO.FillDataToCombo(sql, cmbMaLop, "MaLop", "TenLop"); //lớp sql = "select MaKhoa, TenKhoa from Khoa"; DAO.FillDataToCombo(sql, cmbMaKhoa, "MaKhoa", "TenKhoa"); //khoa sql = "select MaQue, TenQue from Que"; DAO.FillDataToCombo(sql, cmbMaQue, "MaQue", "TenQue"); //quê sql = "select MaDanToc, TenDanToc from DanToc"; DAO.FillDataToCombo(sql, cmbMaDanToc, "MaDanToc", "TenDanToc"); //dân tộc sql = "select MaChuyenNganh, TenChuyenNganh from ChuyenNganh"; DAO.FillDataToCombo(sql, cmbMaChuyenNganh, "MaChuyenNganh", "TenChuyenNganh"); //chuyên ngành sql = "select MaChucVu, TenChucVu from ChucVu"; DAO.FillDataToCombo(sql, cmbMaChucVu, "MaChucVu", "TenChucVu"); //chức vụ sql = "select MaHDT, TenHDT from HeDaoTao"; DAO.FillDataToCombo(sql, cmbMaHDT, "MaHDT", "TenHDT"); string s1 = "select MaLop, TenLop from Lop"; DAO.FillDataToCombo(s1, cbMaLop, "MaLop", "TenLop"); cbMaLop.SelectedIndex = -1; ResetValues(); cmbMaChuyenNganh.SelectedIndex = -1; GridViewSinhVien.AllowUserToAddRows = false; GridViewSinhVien.EditMode = DataGridViewEditMode.EditProgrammatically; }
private void FrmThoiKhoaBieu_Load(object sender, EventArgs e) { DAO.OpenConnection(); cmbLop.Enabled = false; cmbMon.Enabled = false; cmbPhong.Enabled = true; btnHuy.Enabled = false; btnLuu.Enabled = false; LoadDataToGridView(); DAO.FillDataToCombo("SELECT MaLop FROM Lop", cmbLop, "MaLop", "MaLop"); cmbLop.SelectedIndex = -1; DAO.FillDataToCombo("SELECT MaPhong FROM PhongHoc", cmbPhong, "MaPhong", "MaPhong"); cmbPhong.SelectedIndex = -1; DAO.FillDataToCombo("SELECT MaMon FROM MonHoc", cmbMon, "MaMon", "MaMon"); cmbLop.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; cmbMon.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; cmbPhong.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; DAO.CloseConnection(); }
private void Form1_Load(object sender, EventArgs e) { DAO.OpenConnection(); string sql = "select MaLop from Lop"; DAO.FillDataToCombo(sql, cmbMaLop, "MaLop", "MaLop"); sql = "select MaMon, TenMon from MonHoc"; DAO.FillDataToCombo(sql, cmbMonHoc, "MaMon", "TenMon"); Load_DataGridView(); cmbMaLop.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; cmbHocKy.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; cmbMonHoc.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; //GridViewDiem.Enabled = false; //GridViewDiem.Cells[0].Selected = false; /* string s1 = DAO.GetFieldValues("SELECT MaSV FROM SinhVien"); * MessageBox.Show(s1); * string s2 = "select MaSV from Diem where MaSV='" + s1 + "'"; * MessageBox.Show(s2); * if (DAO.CheckKeyExist(s2) == false) * { * string s3 = "INSERT INTO Diem VALUES('" +s1+"', null,null, null,null,null)"; * MessageBox.Show(s3); * DAO.RunSql(sql); * Load_DataGridView(); * }*/ Load_DataGridView(); }
private void cmbHocKy_SelectedIndexChanged(object sender, EventArgs e) { string str; str = "select Thoi_Khoa_Bieu.MaMon,TenMon from Thoi_Khoa_Bieu inner join MonHoc on Thoi_Khoa_Bieu.MaMon = MonHoc.MaMon where MaLop = '" + cmbMaLop.SelectedValue + "' and HocKy = '" + cmbHocKy.Text + "' group by Thoi_Khoa_Bieu.MaMon,TenMon"; DAO.FillDataToCombo(str, cmbMonHoc, "MaMon", "TenMon"); }
private void FrmDiem_Load(object sender, EventArgs e) { DAO.OpenConnection(); //Load_DataGridView(); string str; str = "INSERT INTO Diem(MaSV,MaLop,MaMon,HocKy,LanThi,Diem) SELECT MaSV, Thoi_Khoa_Bieu.MaLop, MaMon, HocKy,1, null FROM SinhVien inner join Thoi_Khoa_Bieu on SinhVien.MaLop = Thoi_Khoa_Bieu.MaLop WHERE MaSV NOT IN(SELECT MaSV FROM Diem)"; DAO.RunSql(str); string sql = "select MaLop from Lop"; DAO.FillDataToCombo(sql, cmbMaLop, "MaLop", "MaLop"); sql = "select MaMon, TenMon from MonHoc"; DAO.FillDataToCombo(sql, cmbMonHoc, "MaMon", "TenMon"); btnLuu.Enabled = false; btnHuy.Enabled = false; btnQuayLai.Enabled = false; btnSua.Enabled = false; txtMaSV.Enabled = false; txtTenSV.Enabled = false; txtDiem.Enabled = false; ResetValues(); cmbMaLop.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; cmbHocKy.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; cmbMonHoc.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; //txtLanThi.MaxLength = 1; GridViewDiem.AllowUserToAddRows = false; }
private void cmbMaKhoa_SelectedIndexChanged(object sender, EventArgs e) { string str = "select MaLop,TenLop from Lop where MaKhoa=N'" + cmbMaKhoa.SelectedValue + "'"; DAO.FillDataToCombo(str, cmbMaLop, "MaLop", "TenLop"); str = "select MaChuyenNganh,TenChuyenNganh from ChuyenNganh where MaKhoa=N'" + cmbMaKhoa.SelectedValue + "'"; DAO.FillDataToCombo(str, cmbMaChuyenNganh, "MaChuyenNganh", "TenChuyenNganh"); }
private void cmbMaLop_SelectedIndexChanged(object sender, EventArgs e) { string str; str = "select distinct HocKy from Thoi_Khoa_Bieu where MaLop = '" + cmbMaLop.SelectedValue + "'"; DAO.FillDataToCombo(str, cmbHocKy, "HocKy", "HocKy"); cmbHocKy.SelectedIndex = -1; }
private void FrmHienThiSinhVien_Load(object sender, EventArgs e) { DAO.OpenConnection(); string sql = "select MaLop, TenLop from Lop"; DAO.FillDataToCombo(sql, cmbMaLop, "MaLop", "TenLop"); cmbMaLop.SelectedIndex = -1; //LoadDatatogriview(); }
private void cmbLop_SelectedIndexChanged(object sender, EventArgs e) { if (cmbMaLop.SelectedIndex != -1) { btnLamMoi.Enabled = true; string str; str = "select distinct MaMon from Diem where MaLop = '" + cmbMaLop.SelectedValue + "'"; DAO.FillDataToCombo(str, cmbMaMon, "MaMon", "MaMon"); } }
private void cmbLop_SelectedIndexChanged(object sender, EventArgs e) { if (cmbLop.SelectedIndex != -1) { string str; str = "select distinct HocKy from Thoi_Khoa_Bieu where MaLop = '" + cmbLop.SelectedValue + "' "; // MessageBox.Show(str); DAO.FillDataToCombo(str, cmbHocKy, "HocKy", "HocKy"); } }
private void cmbMaLop_SelectedIndexChanged(object sender, EventArgs e) { string str; /*str = "select Thoi_Khoa_Bieu.MaMon,TenMon from Thoi_Khoa_Bieu inner join MonHoc on Thoi_Khoa_Bieu.MaMon = MonHoc.MaMon where MaLop = '" + cmbMaLop.SelectedValue + "' and HocKy = '" + cmbHocKy.Text + "' group by Thoi_Khoa_Bieu.MaMon,TenMon"; * //MessageBox.Show(str); * DAO.FillDataToCombo(str, cmbMonHoc, "MaMon", "TenMon"); */ str = "select HocKy from Thoi_Khoa_Bieu where MaLop = '" + cmbMaLop.SelectedValue + "'"; DAO.FillDataToCombo(str, cmbHocKy, "HocKy", "HocKy"); cmbHocKy.SelectedIndex = -1; }
private void FrmChuyenNganh_Load(object sender, EventArgs e) { DAO.OpenConnection(); txtMaChuyenNganh.Enabled = false; cmbKhoa.DropDownStyle = ComboBoxStyle.DropDownList; btnHuy.Enabled = false; btnLuu.Enabled = false; txtTenKhoa.Enabled = false; LoadDataToGridView(); DAO.FillDataToCombo("select * from Khoa", cmbKhoa, "MaKhoa", "MaKhoa"); ResetValues(); DAO.CloseConnection(); }
private void FrmInTKB_Load(object sender, EventArgs e) { DAO.OpenConnection(); DAO.FillDataToCombo("SELECT MaLop FROM Thoi_Khoa_Bieu group by(MaLop)", cmbLop, "MaLop", "MaLop"); cmbLop.SelectedIndex = -1; LoadDataToGridView(); DAO.FillDataToCombo("SELECT HocKy FROM Thoi_Khoa_Bieu group by(HocKy) ", cmbHocKy, "HocKy", "HocKy"); cmbLop.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; cmbHocKy.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; cmbHocKy.SelectedIndex = -1; cmbLop.SelectedIndexChanged += cmbLop_SelectedIndexChanged; DAO.CloseConnection(); }
private void FrmTimKiem_Load(object sender, EventArgs e) { cmbKhoa.DropDownStyle = ComboBoxStyle.DropDownList; cmbChuyenNganh.DropDownStyle = ComboBoxStyle.DropDownList; cmbQue.DropDownStyle = ComboBoxStyle.DropDownList; DAO.OpenConnection(); LoadDataToGridView(); DAO.FillDataToCombo("SELECT MaKhoa,TenKhoa FROM Khoa", cmbKhoa, "MaKhoa", "TenKhoa"); DAO.FillDataToCombo("SELECT MaChuyenNganh,TenChuyenNganh FROM ChuyenNganh", cmbChuyenNganh, "MaChuyenNganh", "MaChuyenNganh"); DAO.FillDataToCombo("SELECT MaQue,TenQue FROM Que", cmbQue, "MaQue", "TenQue"); ResetValues(); DAO.CloseConnection(); }
private void FrmLop_Load(object sender, EventArgs e) { DAO.OpenConnection(); string sql = "select MaKhoa,TenKhoa from Khoa"; DAO.FillDataToCombo(sql, cmbMaKhoa, "MaKhoa", "TenKhoa"); btnLuu.Enabled = false; btnHuy.Enabled = false; txtMaLop.Enabled = false; // cmbMaKhoa.Enabled = false; LoadDataToTable(); Reset(); cmbMaKhoa.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; }
private void FrmTimKiem_Load(object sender, EventArgs e) { DAO.OpenConnection(); GridViewTimKiem.DataSource = null; DAO.FillDataToCombo("SELECT MaKhoa,TenKhoa FROM Khoa", cmbKhoa, "MaKhoa", "TenKhoa"); cmbKhoa.SelectedIndex = -1; DAO.FillDataToCombo("SELECT MaChuyenNganh,TenChuyenNganh FROM ChuyenNganh", cmbChuyenNganh, "MaChuyenNganh", "TenChuyenNganh"); cmbChuyenNganh.SelectedIndex = -1; DAO.FillDataToCombo("SELECT MaQue,TenQue FROM Que", cmbQue, "MaQue", "TenQue"); cmbQue.SelectedIndex = -1; DAO.CloseConnection(); }
private void FrmInDSDiem_Load(object sender, EventArgs e) { DAO.OpenConnection(); string sql = "select MaLop from Lop"; DAO.FillDataToCombo(sql, cmbMaLop, "MaLop", "MaLop"); sql = "select MaMon from MonHoc"; DAO.FillDataToCombo(sql, cmbMaMon, "MaMon", "MaMon"); Load_DataGridView(); cmbMaLop.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; cmbMaMon.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; btnLamMoi.Enabled = false; txtTenMon.Enabled = false; txtLanThi.TextChanged += txtLanThi_TextChanged; cmbMaMon.SelectedIndexChanged += cmbMon_SelectedIndexChanged; cmbMaLop.SelectedIndexChanged += cmbLop_SelectedIndexChanged; DAO.CloseConnection(); }
private void FrmLop_Load(object sender, EventArgs e) { DAO.OpenConnection(); string sql = "select MaKhoa,TenKhoa from Khoa"; DAO.FillDataToCombo(sql, cmbMaKhoa, "MaKhoa", "TenKhoa"); btnLuu.Enabled = false; btnHuy.Enabled = false; txtMaLop.Enabled = false; LoadDataToTable(); txtSiSo.Enabled = false; Reset(); cmbMaKhoa.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; txtMaLop.MaxLength = 10; txtTenLop.MaxLength = 50; txtKhoaHoc.MaxLength = 10; GridViewLop.AllowUserToAddRows = false; }
private void FrmSinhVien_Load(object sender, EventArgs e) { DAO.OpenConnection(); LoadDatatogriview(); cmbMaKhoa.DropDownStyle = ComboBoxStyle.DropDownList; cmbMaQue.DropDownStyle = ComboBoxStyle.DropDownList;; cmbMaLop.DropDownStyle = ComboBoxStyle.DropDownList; cmbMaDanToc.DropDownStyle = ComboBoxStyle.DropDownList; cmbMaChuyenNganh.DropDownStyle = ComboBoxStyle.DropDownList; cmbMaHDT.DropDownStyle = ComboBoxStyle.DropDownList; cmbMaChucVu.DropDownStyle = ComboBoxStyle.DropDownList; sql = "select MaLop, TenLop from Lop"; DAO.FillDataToCombo(sql, cmbMaLop, "MaLop", "TenLop"); sql = "select MaKhoa, TenKhoa from Khoa"; DAO.FillDataToCombo(sql, cmbMaKhoa, "MaKhoa", "TenKhoa"); sql = "select MaQue, TenQue from Que"; DAO.FillDataToCombo(sql, cmbMaQue, "MaQue", "TenQue"); sql = "select MaDanToc, TenDanToc from DanToc"; DAO.FillDataToCombo(sql, cmbMaDanToc, "MaDanToc", "TenDanToc"); sql = "select MaChuyenNganh, TenChuyenNganh from ChuyenNganh"; DAO.FillDataToCombo(sql, cmbMaChuyenNganh, "MaChuyenNganh", "TenChuyenNganh"); sql = "select MaChucVu, TenChucVu from ChucVu"; DAO.FillDataToCombo(sql, cmbMaChucVu, "MaChucVu", "TenChucVu"); sql = "select MaHDT, TenHDT from HeDaoTao"; DAO.FillDataToCombo(sql, cmbMaHDT, "MaHDT", "TenHDT"); btnLuu.Enabled = false; tat(); btnSua.Enabled = false; btnHuy.Enabled = false; btnXoa.Enabled = false; btnQuayLai.Enabled = false; btnThem.Enabled = false; ResetValues(); cmbMaKhoa.SelectedIndex = -1; cmbMaLop.SelectedIndex = -1; cmbMaChuyenNganh.SelectedIndex = -1; GridViewSinhVien.AllowUserToAddRows = false; txtMaSV.MaxLength = 15; txtTenSV.MaxLength = 50; GridViewSinhVien.ReadOnly = true; }
private void FrmInBangDiemSV_Load(object sender, EventArgs e) { DAO.OpenConnection(); txtTenMon.Enabled = false; rdoMaSV.Checked = true; Load_DataGridView(); DAO.OpenConnection(); string sql = "select MaLop from Lop"; DAO.FillDataToCombo(sql, cmbMaLop, "MaLop", "MaLop"); sql = "select MaMon from MonHoc"; DAO.FillDataToCombo(sql, cmbMaMon, "MaMon", "MaMon"); Load_DataGridView(); cmbMaLop.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; cmbMaMon.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; txtTenMon.Enabled = false; ResetValues1(); ResetValues2(); DAO.CloseConnection(); }
private void FrmDiem_Load(object sender, EventArgs e) { DAO.OpenConnection(); string sql = "select MaLop from Lop"; DAO.FillDataToCombo(sql, cmbMaLop, "MaLop", "MaLop"); sql = "select MaMon, TenMon from MonHoc"; DAO.FillDataToCombo(sql, cmbMonHoc, "MaMon", "TenMon"); btnLuu.Enabled = false; btnHuy.Enabled = false; //btnXoa.Enabled = false; //btnSua.Enabled = false; btnQuayLai.Enabled = false; txtMaSV.Enabled = false; txtTenSV.Enabled = false; txtDiem.Enabled = false; Load_DataGridView(); ResetValues(); cmbMaLop.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; cmbHocKy.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; cmbMonHoc.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; //GridViewDiem.Enabled = false; //GridViewDiem.Cells[0].Selected = false; }
private void FrmDiem_Load(object sender, EventArgs e) { DAO.OpenConnection(); //Load_DataGridView(); checkupdate(); string sql = "select MaLop from Lop"; DAO.FillDataToCombo(sql, cmbMaLop, "MaLop", "MaLop"); sql = "select MaMon, TenMon from MonHoc"; DAO.FillDataToCombo(sql, cmbMonHoc, "MaMon", "TenMon"); btnLuu.Enabled = false; btnHuy.Enabled = false; btnQuayLai.Enabled = false; btnSua.Enabled = false; txtMaSV.Enabled = false; txtTenSV.Enabled = false; txtDiem.Enabled = false; ResetValues(); cmbMaLop.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; cmbHocKy.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; cmbMonHoc.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; //txtLanThi.MaxLength = 1; GridViewDiem.AllowUserToAddRows = false; }
private void cmbKhoa_SelectedIndexChanged(object sender, EventArgs e) { string sql = "select * from ChuyenNganh where MaKhoa=N'" + cmbKhoa.SelectedValue + "'"; DAO.FillDataToCombo(sql, cmbChuyenNganh, "MaChuyenNganh", "TenChuyenNganh"); }