void LoadData() { try { dvgNV.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dvgNV.Enabled = true; // dtNhanVien = new DataTable(); dtNhanVien.Clear(); // dtgioitinh = new DataTable(); dtgioitinh.Clear(); // dtNhanVien = dbNhanVien.LayBangNhanVien(); dvgNV.DataSource = dtNhanVien; // this.btnHuy.Enabled = false; this.btnLuu.Enabled = false; // this.btnSua.Enabled = true; this.btnTaiLai.Enabled = true; this.btnThem.Enabled = true; this.btnTroVe.Enabled = true; this.btnXoa.Enabled = true; // checkBoxKhac.Enabled = true; checkBoxNam.Enabled = true; checkBoxNu.Enabled = true; // this.txtMaNV.Enabled = false; this.txtTenNV.Enabled = false; this.cbGioiTinh.Enabled = false; this.txtSDT.Enabled = false; this.txtDiaChi.Enabled = false; this.txtEmail.Enabled = false; this.txtMK.Enabled = false; this.cbQuyen.Enabled = false; // this.txtTimNV.Enabled = true; this.btnTim.Enabled = true; this.txtTimNV.ResetText(); // this.txtCN.Enabled = false; // DvgNV_CellClick(null, null); this.txtMaNV.Focus(); // } catch (SqlException) { MessageBox.Show("Lỗi Rồi! Không Load Được Bảng", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void BtnHT_Click(object sender, EventArgs e) { //LoadData(); if (cbTable.SelectedValue.ToString() == "CHINHANH") { LoadData(); dvgShowTable.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dt = dbChiNhanh.LayBangChiNhanh(); dvgShowTable.DataSource = dt; dvgShowTable.Rows[0].Selected = false; } else if (cbTable.SelectedValue.ToString() == "NHANVIEN") { LoadData(); dvgShowTable.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; dt = dbNhanVien.LayBangNhanVien(); dvgShowTable.DataSource = dt; dvgShowTable.Rows[0].Selected = false; } else if (cbTable.SelectedValue.ToString() == "PHIEUNHAPHANG") { LoadData(); dvgShowTable.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; dt = dbPhieuNhap.LayBangPhieuNhap(); dvgShowTable.DataSource = dt; dvgShowTable.Rows[0].Selected = false; } else if (cbTable.SelectedValue.ToString() == "KHO") { LoadData(); dvgShowTable.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dt = dbKho.LayBangKho(); dvgShowTable.DataSource = dt; dvgShowTable.Rows[0].Selected = false; } else if (cbTable.SelectedValue.ToString() == "HANGHOA") { LoadData(); dvgShowTable.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; dt = dbHangHoa.LayBangHangHoa(); dvgShowTable.DataSource = dt; dvgShowTable.Rows[0].Selected = false; } else if (cbTable.SelectedValue.ToString() == "NHACUNGCAP") { LoadData(); dvgShowTable.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dt = dbNhaCungCap.LayBangNhaCungCap(); dvgShowTable.DataSource = dt; dvgShowTable.Rows[0].Selected = false; } else if (cbTable.SelectedValue.ToString() == "PHIEUXUATHANG") { LoadData(); dvgShowTable.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; dt = dbPhieuXuat.LayBangPhieuXuat(); dvgShowTable.DataSource = dt; dvgShowTable.Rows[0].Selected = false; } else if (cbTable.SelectedValue.ToString() == "KHACHHANG") { LoadData(); dvgShowTable.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; dt = dbKhachHang.LayBangKhachHang(); dvgShowTable.DataSource = dt; dvgShowTable.Rows[0].Selected = false; } else { MessageBox.Show("Chưa Chọn bảng ??"); } }
void LoadMaNV(ComboBox cb) { cbMaNV.DataSource = dbNhanVien.LayBangNhanVien(); cbMaNV.ValueMember = "MaNV"; cbMaNV.DropDownStyle = ComboBoxStyle.DropDownList; }