void LoadData() { dtLoaiLaptop = new DataTable(); dtLoaiLaptop.Clear(); dtLoaiLaptop = dbLoaiLaptop.LayLoaiLT().Tables[0]; cmbLoaiLT.Enabled = false; txtTen.Enabled = false; groupGia.Enabled = false; cmbLoaiLT.DataSource = dtLoaiLaptop; cmbLoaiLT.DisplayMember = "TenLoaiLT"; cmbLoaiLT.ValueMember = "MaLoaiLT"; }
void loadData() { try { dtLoaiLT = new DataTable(); dtLoaiLT.Clear(); dtLoaiLT = dbLoaiLT.LayLoaiLT().Tables[0]; dgvLoaiLaptop.DataSource = dtLoaiLT; this.txtMaLoaiLaptop.ResetText(); this.txtTenLoaiLaptop.ResetText(); this.btnLuu.Enabled = false; this.btnHuy.Enabled = false; this.pnlLoaiLT.Enabled = false; this.btnThem.Enabled = true; this.btnSua.Enabled = true; this.btnXoa.Enabled = true; this.btnThoat.Enabled = true; } catch (SqlException) { MessageBox.Show("Không lấy được nội dung trong table . Lỗi rồi!!!"); } }
void loadData() { try { dtLoaiLaptop = new DataTable(); dtLoaiLaptop.Clear(); dtLoaiLaptop = dbLoaiLaptop.LayLoaiLT().Tables[0]; (dgvLaptop.Columns["Loai"] as DataGridViewComboBoxColumn).DataSource = dtLoaiLaptop; (dgvLaptop.Columns["Loai"] as DataGridViewComboBoxColumn).DisplayMember = "TenLoaiLT"; (dgvLaptop.Columns["Loai"] as DataGridViewComboBoxColumn).ValueMember = "MaLoaiLT"; dtLaptop = new DataTable(); dtLaptop.Clear(); dtLaptop = dbLaptop.LayLaptop().Tables[0]; dgvLaptop.DataSource = dtLaptop; this.txtMaLaptop.ResetText(); this.txtTenLaptop.ResetText(); this.cmbLoaiLT.ResetText(); this.ptBoxHinhLaptop.ResetText(); this.txtDonGia.ResetText(); this.txtSoLuongCon.ResetText(); this.txtxGhiChu.ResetText(); this.pnlLT.Enabled = false; this.btnLuu.Enabled = false; this.btnHuy.Enabled = false; this.btnRefresh.Enabled = true; this.btnThem.Enabled = true; this.btnXoa.Enabled = true; this.btnSua.Enabled = true; this.btnThoat.Enabled = true; } catch (SqlException) { MessageBox.Show("Không lấy được nội dung trong table . Lỗi rồi!!!"); } }
public void LoadSanPham() { try { dtLoaiLaptop = new DataTable(); dtLoaiLaptop.Clear(); dtLoaiLaptop = dbLoaiLaptop.LayLoaiLT().Tables[0]; (dgvLaptop.Columns["Loai"] as DataGridViewComboBoxColumn).DataSource = dtLoaiLaptop; (dgvLaptop.Columns["Loai"] as DataGridViewComboBoxColumn).DisplayMember = "TenLoaiLT"; (dgvLaptop.Columns["Loai"] as DataGridViewComboBoxColumn).ValueMember = "MaLoaiLT"; dtLaptop = new DataTable(); dtLaptop.Clear(); dtLaptop = laptop.LayLaptop().Tables[0]; dgvLaptop.DataSource = dtLaptop; } catch (SqlException) { MessageBox.Show("Không lấy được nội dung trong table . Lỗi rồi!!!"); } }