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");
}
