public GiangVien(GUI.frmDSHocSinh frmDSHS)
{
this.frmDSHS = frmDSHS;
}
private void btnOK_Click(object sender, EventArgs e)
{
//Lay gia tri cua ban hoc sinh
string sqlHS = "select * from HOCSINH";
DataTable tableHS = lop.LoadData(sqlHS);
DataRow rowHS = tableHS.Rows[0];
//Lay gia tri cua ban giang vien
string sqlGV = "select * from GIANGVIEN";
DataTable tableGV = lop.LoadData(sqlGV);
DataRow rowGV = tableGV.Rows[0];
try
{
//Phan quyen giao vien
if (phanquyen == "2")
{
string q = "select * from HOCSINH where MALOP='" + comboBox1.SelectedValue.ToString() + "'";
DataTable dt = lop.LoadData(q);
GUI.frmDSHocSinh dsHS = new GUI.frmDSHocSinh();
//Combobox
string commandLOP = "select * from LOP";
dsHS.cbMaLop.DataSource = lop.LoadData(commandLOP);
dsHS.cbMaLop.DisplayMember = "TENLOP";
dsHS.cbMaLop.ValueMember = "MALOP";
dsHS.dataGridView1.DataSource = dt;
dsHS.Show();
}
//Phan quyen hoc sinh
else
{
//Truyen tham du lieu datagridview cho frmHocSinh
string commandDIEM = "select * from DIEM where MAHS='" + lblMA.Text + "'";
DataTable tableDIEM = lop.LoadData(commandDIEM);
//Truyen tham du lieu text cho frmHocSinh
string commandGIANGVIEN = "select * from GIANGVIEN where MALOP='" + comboBox1.SelectedValue + "'";
DataTable tableGIANGVIEN = lop.LoadData(commandGIANGVIEN);
DataRow drGIANGVIEN = tableGIANGVIEN.Rows[0];
GUI.frmHocSinh dsTTHS = new GUI.frmHocSinh();
//Combobox
string commandLOP = "select * from LOP";
dsTTHS.cbMaLop.DataSource = lop.LoadData(commandLOP);
dsTTHS.cbMaLop.DisplayMember = "TENLOP";
dsTTHS.cbMaLop.ValueMember = "MALOP";
//THONG TIN
dsTTHS.txtMaGV.Text = Convert.ToString(drGIANGVIEN["MAGV"]);
dsTTHS.txtGV.Text = Convert.ToString(drGIANGVIEN["TENGV"]);
dsTTHS.txtNgaySinh.Text = Convert.ToString(drGIANGVIEN["NGAYSINH"]);
dsTTHS.txtEmail.Text = Convert.ToString(drGIANGVIEN["EMAIL"]);
dsTTHS.txtSDT.Text = Convert.ToString(drGIANGVIEN["SDT"]);
dsTTHS.txtKhoa.Text = Convert.ToString(drGIANGVIEN["KHOA"]);
//ANH
dsTTHS.pictureBox1.Image = Image.FromFile(@"D:\DEV express\QuanLy\Image\" + Convert.ToString(drGIANGVIEN["HINH"]));
dsTTHS.pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage;
//Datagridview cua HOC SINH
dsTTHS.dataGridView1.DataSource = tableDIEM;
dsTTHS.Show();
}
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
}
