private void frmHoSoHocSinh_Load(object sender, EventArgs e)
{
HoSoHSBUL cls = new HoSoHSBUL();
dgvHocSinh.DataSource = cls.HienThiDS();
dgvHocSinh.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
cboMaLop.DataSource = cls.LayMaLop();
cboMaLop.DisplayMember = "TenLop";
cboMaLop.ValueMember = "MaLop";
DataTable dta = new DataTable();
dta.Columns.Add("gioitinh", typeof(string));
dta.Columns.Add("ten", typeof(string));
dta.Rows.Add("Nam", "Nam");
dta.Rows.Add("Nu", "Nữ");
cboGioiTinh.DataSource = dta;
cboGioiTinh.DisplayMember = "ten";
cboGioiTinh.ValueMember = "gioitinh";
//Mã tự sinh
DataTable ma = cls.SinhMaHS();
string x = ma.Rows[0][0].ToString();
string mahs = "000" + x;
mahs = mahs.Substring(mahs.Length - 4, 4);
txtMaHS.Text = "HS" + mahs;
}
private void btnXem_Click(object sender, EventArgs e)
{
HoSoHSBUL cls = new HoSoHSBUL();
HoSoHocSinh x = new HoSoHocSinh();
x.MaHocSinh = txtMaHS.Text;
dgvHocSinh.DataSource = cls.Xem(x);
}
private void btnXoa_Click(object sender, EventArgs e)
{
HoSoHSBUL cls = new HoSoHSBUL();
HoSoHocSinh x = new HoSoHocSinh();
x.MaHocSinh = txtMaHS.Text;
cls.Xoa(x);
frmHoSoHocSinh_Load(sender, e);
}
private void btnSua_Click(object sender, EventArgs e)
{
HoSoHSBUL cls = new HoSoHSBUL();
HoSoHocSinh x = new HoSoHocSinh();
x.MaHocSinh = txtMaHS.Text;
x.HoTen = txtHoTen.Text;
x.NgaySinh = DateTime.Parse(txtNgaySinh.Text);
x.GioiTinh = cboGioiTinh.SelectedValue.ToString();
x.DiaChi = txtDiaChi.Text;
x.DiemVAotruong = double.Parse(txtDiemVaoTruong.Text);
x.HoTenBoMe = txtHoTenBoMe.Text;
x.sdt = txtSDT.Text;
x.MaLop = cboMaLop.SelectedValue.ToString();
cls.Sua(x);
frmHoSoHocSinh_Load(sender, e);
}
