private void frm_TRACUUSACH_Load(object sender, EventArgs e) { Bang_SACH = new XL_SACH(); Bang_THELOAI = new XL_THELOAI(); Bang_NHAXUATBAN = new XL_NHAXUATBAN(); DataSet ds = new DataSet(); ds.Tables.AddRange(new DataTable[] { Bang_SACH, Bang_NHAXUATBAN, Bang_THELOAI }); DataRelation qh_NHAXUATBAN_SACH = new DataRelation("FK_NHAXUATBAN_SACH", Bang_NHAXUATBAN.Columns["MaNXB"], Bang_SACH.Columns["MaNXB"]); DataRelation qh_THELOAI_SACH = new DataRelation("FK_THELOAI_SACH", Bang_THELOAI.Columns["MaTL"], Bang_SACH.Columns["MaTL"]); ds.Relations.AddRange(new DataRelation[] { qh_NHAXUATBAN_SACH, qh_THELOAI_SACH }); DataColumn cot_TenNXB = new DataColumn("TenNXB", Type.GetType("System.String"), "Parent(FK_NHAXUATBAN_SACH).TenNXB"); DataColumn cot_TenTL = new DataColumn("TenTL", Type.GetType("System.String"), "Parent(FK_THELOAI_SACH).TenTL"); Bang_SACH.Columns.AddRange(new DataColumn[] { cot_TenNXB, cot_TenTL }); cbNXB.DataSource = Bang_NHAXUATBAN; cbNXB.DisplayMember = "TenNXB"; cbNXB.ValueMember = "MaNXB"; cbMaTL.DataSource = Bang_THELOAI; cbMaTL.DisplayMember = "TenTL"; cbMaTL.ValueMember = "MaTL"; dgvSACH.DataSource = Bang_SACH; Nhap_moi(); }
private void frm_MUONSACH_Load(object sender, EventArgs e) { bang_MUONSACH = new XL_MUONSACH(); bang_BANDOC = new XL_BANDOC(); bang_SACH = new XL_SACH(); cbMaThe.DataSource = bang_BANDOC; cbMaThe.DisplayMember = "MaThe"; cbMaThe.ValueMember = "MaThe"; txtTenBanDoc.DataBindings.Add("text", bang_BANDOC, "TenBanDoc"); txtSoDT.DataBindings.Add("text", bang_BANDOC, "SoDT"); txtDiaChi.DataBindings.Add("text", bang_BANDOC, "DiaChi"); cbMaSach.DataSource = bang_SACH; cbMaSach.DisplayMember = "MaSach"; cbMaSach.ValueMember = "MaSach"; txtTuaDe.DataBindings.Add("text", bang_SACH, "TuaDe"); txtTacGia.DataBindings.Add("text", bang_SACH, "TacGia"); DataSet ds = new DataSet(); ds.Tables.AddRange(new DataTable[] { bang_MUONSACH, bang_SACH }); DataRelation qh = new DataRelation("FR_SACH_MUONSACH", bang_SACH.Columns["MaSach"], bang_MUONSACH.Columns["MaSach"]); ds.Relations.Add(qh); DataColumn cot_TuaDe = new DataColumn("TuaDe", Type.GetType("System.String"), "Parent(FR_SACH_MUONSACH).TuaDe"); DataColumn cot_TacGia = new DataColumn("TacGia", Type.GetType("System.String"), "Parent(FR_SACH_MUONSACH).TacGia"); bang_MUONSACH.Columns.AddRange(new DataColumn[] { cot_TuaDe, cot_TacGia }); cbMaSach.DataBindings.Add("SelectedValue", bang_MUONSACH, "MaSach"); dNgayMuon.DataBindings.Add("text", bang_MUONSACH, "NgayMuon"); dNgayTra.DataBindings.Add("text", bang_MUONSACH, "NgayTra"); dgvMUONSACH.DataSource = bang_MUONSACH; DS_MUON_SACH = this.BindingContext[bang_MUONSACH]; cbMaThe_SelectedIndexChanged(sender, e); }
private void frm_NHAP_SACH_Load(object sender, EventArgs e) { Bang_SACH = new XL_SACH(); Bang_THELOAI = new XL_THELOAI(); Bang_NHAXUATBAN = new XL_NHAXUATBAN(); DataSet ds = new DataSet(); ds.Tables.AddRange(new DataTable[] { Bang_SACH, Bang_NHAXUATBAN, Bang_THELOAI }); DataRelation qh_NHAXUATBAN_SACH = new DataRelation("FK_NHAXUATBAN_SACH", Bang_NHAXUATBAN.Columns["MaNXB"], Bang_SACH.Columns["MaNXB"]); DataRelation qh_THELOAI_SACH = new DataRelation("FK_THELOAI_SACH", Bang_THELOAI.Columns["MaTL"], Bang_SACH.Columns["MaTL"]); ds.Relations.AddRange(new DataRelation[] { qh_NHAXUATBAN_SACH, qh_THELOAI_SACH }); DataColumn cot_TenNXB = new DataColumn("TenNXB", Type.GetType("System.String"), "Parent(FK_NHAXUATBAN_SACH).TenNXB"); DataColumn cot_TenTL = new DataColumn("TenTL", Type.GetType("System.String"), "Parent(FK_THELOAI_SACH).TenTL"); Bang_SACH.Columns.AddRange(new DataColumn[] { cot_TenNXB, cot_TenTL }); cbNXB.DataSource = Bang_NHAXUATBAN; cbNXB.DisplayMember = "TenNXB"; cbNXB.ValueMember = "MaNXB"; cbMaTL.DataSource = Bang_THELOAI; cbMaTL.DisplayMember = "TenTL"; cbMaTL.ValueMember = "MaTL"; dgvSACH.DataSource = Bang_SACH; txtMaSach.DataBindings.Add("text", Bang_SACH, "MaSach"); txtTuaDe.DataBindings.Add("text", Bang_SACH, "TuaDe"); txtTacGia.DataBindings.Add("text", Bang_SACH, "TacGia"); txtSoLuong.DataBindings.Add("text", Bang_SACH, "SoLuong"); dNgayNhap.DataBindings.Add("text", Bang_SACH, "NgayNhap"); cbNXB.DataBindings.Add("SelectedValue", Bang_SACH, "MaNXB"); cbMaTL.DataBindings.Add("SelectedValue", Bang_SACH, "MaTL"); DS_SACH = this.BindingContext[Bang_SACH]; An_hien_nut_lenh(false); }