private void frm_BANDOC_Load(object sender, EventArgs e)
{
Bang_BANDOC = new XL_BANDOC();
Bang_BANDOC.Columns["MaThe"].ReadOnly = true;
dgvDSBD.DataSource = Bang_BANDOC;
txtMaThe.DataBindings.Add("text", Bang_BANDOC, "MaThe");
txtTenBanDoc.DataBindings.Add("text", Bang_BANDOC, "TenBanDoc");
txtDiaChi.DataBindings.Add("text", Bang_BANDOC, "DiaChi");
txtDienThoai.DataBindings.Add("text", Bang_BANDOC, "SoDT");
DS_BANDOC = this.BindingContext[Bang_BANDOC];
DS_BANDOC.PositionChanged += DS_BANDOC_PositionChanged;
An_hien_nut_lenh(false);
}
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);
}
