private void LoadDSSach() { DataTable dt = Sach_DAO.LoadDuLieu(); DataTable dtg = ChuDe_DAO.LoadDuLieu(); AutoCompleteStringCollection ac = new AutoCompleteStringCollection(); for (int i = 0; i < dtg.Rows.Count; i++) { ListViewGroup lvg = new ListViewGroup(dtg.Rows[i][0].ToString(), dtg.Rows[i][1].ToString()); lsvSach.Groups.Add(lvg); } for (int i = 0; i < dt.Rows.Count; i++) { ListViewItem lvi = new ListViewItem(dt.Rows[i][1].ToString()); // ten mon lvi.SubItems.Add(dt.Rows[i][2].ToString()); // Don gia lvi.SubItems.Add(dt.Rows[i][4].ToString()); //So luong DataTable nxb = NhaXuatBan_DAO.LoadDuLieuNXB(dt.Rows[i][6].ToString()); lvi.SubItems.Add(nxb.Rows[0][1].ToString()); //NXB lvi.SubItems.Add(dt.Rows[i][7].ToString()); //id chu de lvi.SubItems.Add(dt.Rows[i][0].ToString()); // id mon lvi.Group = lsvSach.Groups[lvi.SubItems[4].Text]; lsvSach.Items.Add(lvi); ac.Add(lvi.SubItems[0].Text); } txtTenSach.AutoCompleteCustomSource = ac; }
private void FrmThemDS_Load(object sender, EventArgs e) { cboMaCD.DataSource = ChuDe_DAO.LoadDuLieu(); cboMaCD.DisplayMember = "TenCD"; cboMaCD.ValueMember = "MaCD"; cboNhaNXB.DataSource = NhaXuatBan_DAO.LoadDuLieu(); dgvDausach.DataSource = Sach_DAO.LoadDuLieu(); cboNhaNXB.DisplayMember = "TenNXB"; cboNhaNXB.ValueMember = "MaNXB"; txtMasach.ReadOnly = true; }
private void btnLuu_Click(object sender, EventArgs e) { try { //enty_sach.MaSach = int.Parse(txtMasach.Text); enty_sach.TenSach = txtTensach.Text; enty_sach.GiaBan = int.Parse(txtGiaban.Text); enty_sach.MaCD = int.Parse(cboMaCD.SelectedValue.ToString()); enty_sach.MaNXB = int.Parse(cboNhaNXB.SelectedValue.ToString()); enty_sach.SoLuong = int.Parse(txtSoluong.Text); enty_sach.NgayNhap = Convert.ToDateTime(txtNgaynhap.Text); enty_sach.MoTa = txtMota.Text; Sach_DAO.Them(enty_sach); dgvDausach.DataSource = Sach_DAO.LoadDuLieu(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void FrmThemChiTietPM_Load(object sender, EventArgs e) { cboTenSach.DataSource = Sach_DAO.LoadDuLieu(); }