private void btnTim_Click(object sender, EventArgs e) { if (cbTenLop.Text == (string)cbTenLop.SelectedValue) { LopBUL lp = new LopBUL(); string TenLop = cbTenLop.Text; DataTable dt = lp.DanhSachHocSinh(TenLop); dgvDanhSachHocSinh.DataSource = dt; dgvDanhSachHocSinh.Columns[1].HeaderText = "TenLop"; dgvDanhSachHocSinh.Columns[1].Width = 100; dgvDanhSachHocSinh.Columns[2].HeaderText = "MaHocSinh"; dgvDanhSachHocSinh.Columns[2].Width = 100; dgvDanhSachHocSinh.Columns[3].HeaderText = "HoTen"; dgvDanhSachHocSinh.Columns[3].Width = 100; dgvDanhSachHocSinh.Columns[4].HeaderText = "GioiTinh"; dgvDanhSachHocSinh.Columns[4].Width = 100; dgvDanhSachHocSinh.Columns[5].HeaderText = "DiaChi"; dgvDanhSachHocSinh.Columns[5].Width = 100; dgvDanhSachHocSinh.Columns[6].HeaderText = "HoTenBoMe"; dgvDanhSachHocSinh.Columns[6].Width = 100; dgvDanhSachHocSinh.Columns[7].HeaderText = "SoDienThoai"; dgvDanhSachHocSinh.Columns[7].Width = 100; for (int i = 0; i < dgvDanhSachHocSinh.Rows.Count - 1; i++) { dgvDanhSachHocSinh.Rows[i].Cells[0].Value = i + 1; } } }
private void button1_Click(object sender, EventArgs e) { if (txtMaLop.Text == txtMaLop.Text) { LopBUL lp = new LopBUL(); string MaLop = txtMaLop.Text; DataTable dt = lp.TimKiem(MaLop); dgvDSLop.DataSource = dt; } }
private void btnSua_Click(object sender, EventArgs e) { LopBUL lp = new LopBUL(); string MaLop = txtbMaLop.Text; string TenLop = txtbTenLop.Text; string NienKhoa = txtbNienKhoa.Text; int SiSo = int.Parse(txtbSiSo.Text); string GiaoVienChuNhiem = (string)cbGiaoVienChuNhiem.SelectedValue; lp.Sua(MaLop, TenLop, NienKhoa, SiSo, GiaoVienChuNhiem); dgvLop.DataSource = myLop.LayDsLop(); }
private void lưuToolStripMenuItem_Click(object sender, EventArgs e) { if (btnThem.Enabled == false) { LopBUL lp = new LopBUL(); string MaLop = txtbMaLop.Text; string TenLop = txtbTenLop.Text; string NienKhoa = txtbNienKhoa.Text; int SiSo = int.Parse(txtbSiSo.Text); string GiaoVienChuNhiem = (string)cbGiaoVienChuNhiem.SelectedValue; lp.Them(MaLop, TenLop, NienKhoa, SiSo, GiaoVienChuNhiem); dgvLop.DataSource = myLop.LayDsLop(); btnThem.Enabled = true; } if (btnSua.Enabled == false) { LopBUL lp = new LopBUL(); string MaLop = txtbMaLop.Text; string TenLop = txtbTenLop.Text; string NienKhoa = txtbNienKhoa.Text; int SiSo = int.Parse(txtbSiSo.Text); string GiaoVienChuNhiem = (string)cbGiaoVienChuNhiem.SelectedValue; lp.Sua(MaLop, TenLop, NienKhoa, SiSo, GiaoVienChuNhiem); dgvLop.DataSource = myLop.LayDsLop(); btnSua.Enabled = true; } if (btnXoa.Enabled == false) { try { LopBUL lop = new LopBUL(); string MaLop = txtbMaLop.Text; lop.Xoa(MaLop); } catch (Exception) { MessageBox.Show("Xóa thông tin không hợp lệ!!!"); } DialogResult dlr = MessageBox.Show("Thông báo xác nhận xóa", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dlr == DialogResult.No) { } if (dlr == DialogResult.Yes) { dgvLop.DataSource = myLop.LayDsLop(); ClearLop(); btnXoa.Enabled = true; } } }
private void button2_Click(object sender, EventArgs e) { if (cbTen.Text == (string)cbTen.SelectedValue) { LopBUL lp = new LopBUL(); string TenLop = cbTen.Text; DataTable dt = lp.TimKiem1(TenLop); dgvDSLop.DataSource = dt; } else { dgvDSLop.DataSource = myLopBUL.LayDsLop(); } txtMaLop.Clear(); }
private void btnXoa_Click(object sender, EventArgs e) { try { LopBUL lop = new LopBUL(); string MaLop = txtbMaLop.Text; lop.Xoa(MaLop); } catch (Exception) { MessageBox.Show("Xóa thông tin không hợp lệ!!!"); } DialogResult dlr = MessageBox.Show("Thông báo xác nhận xóa", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dlr == DialogResult.No) { } if (dlr == DialogResult.Yes) { dgvLop.DataSource = myLop.LayDsLop(); ClearLop(); } }