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_NHAXUABAN_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_NHAXUABAN_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 }); cobNSX.DataSource = Bang_NHAXUATBAN; cobNSX.DisplayMember = "TenNXB"; cobNSX.ValueMember = "MaTL"; cobTheLoai.DataSource = Bang_THELOAI; cobTheLoai.DisplayMember = "TenTL"; cobTheLoai.ValueMember = "MaTL"; dgvTraCuu.DataSource = Bang_SACH; Nhap_moi(); }
private void frm_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_NHAXUABAN_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_NHAXUABAN_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 }); cobNSX.DataSource = Bang_NHAXUATBAN; cobNSX.DisplayMember = "TenNXB"; cobNSX.ValueMember = "MaNXB"; cobTheLoai.DataSource = Bang_THELOAI; cobTheLoai.DisplayMember = "TenTL"; cobTheLoai.ValueMember = "MaTL"; dgvSach.DataSource = Bang_SACH; txtMaSach.DataBindings.Add("text", Bang_SACH, "MaSach"); txtTenSach.DataBindings.Add("text", Bang_SACH, "TuaDe"); txtTacGia.DataBindings.Add("text", Bang_SACH, "TacGia"); txtSoLuong.DataBindings.Add("text", Bang_SACH, "SoLuong"); dtNgayNhap.DataBindings.Add("text", Bang_SACH, "NgayNhap"); cobNSX.DataBindings.Add("SelectedValue", Bang_SACH, "MaNSX"); cobTheLoai.DataBindings.Add("SelectedValue", Bang_SACH, "MaTL"); // DS_SACH = this.BindingContext[Bang_SACH]; An_hien_nut_lenh(false); }