private void TrinhDo_Load(object sender, EventArgs e) { trinhdo = new BusinessLayer.TrinhDoBsn(); txtMaTD.Enabled = false; btnSave.Enabled = false; btnCancel.Enabled = false; SqlDataAdapter da; chuyenmon =new BusinessLayer.ChuyenMonBsn(); da = chuyenmon.GetDataAdapter(); da.Fill(ds, "ChuyenMon"); cbbTenCM.DataSource =ds; //Nội dung sẽ hiển thị lên combobox cbbTenCM.DisplayMember = "ChuyenMon.TenChuyenMon"; //Giá trị nhận được ứng với từng nội dung được chọn trên combobox cbbTenCM.ValueMember = "ChuyenMon.MaChuyenMon"; dt = trinhdo.Select(); curRecord = 0; totalRecord = dt.Rows.Count - 1; fillControls(dt, 0); //txtTenCM.Text = cbbTenCM.SelectedValue.ToString(); dgrvTrinhdo.DataSource = dt.DefaultView; this.Cursor = Cursors.Default; }
private void TrinhDo_Load(object sender, EventArgs e) { trinhdo = new BusinessLayer.TrinhDoBsn(); txtMaTD.Enabled = false; btnSave.Enabled = false; btnCancel.Enabled = false; SqlDataAdapter da; chuyenmon = new BusinessLayer.ChuyenMonBsn(); da = chuyenmon.GetDataAdapter(); da.Fill(ds, "ChuyenMon"); cbbTenCM.DataSource = ds; //Nội dung sẽ hiển thị lên combobox cbbTenCM.DisplayMember = "ChuyenMon.TenChuyenMon"; //Giá trị nhận được ứng với từng nội dung được chọn trên combobox cbbTenCM.ValueMember = "ChuyenMon.MaChuyenMon"; dt = trinhdo.Select(); curRecord = 0; totalRecord = dt.Rows.Count - 1; fillControls(dt, 0); //txtTenCM.Text = cbbTenCM.SelectedValue.ToString(); dgrvTrinhdo.DataSource = dt.DefaultView; this.Cursor = Cursors.Default; }
// public void fillDataControl(Control ctrl) { foreach (Control ctrlChild in ctrl.Controls) { if (ctrlChild.Name.Equals("cbbChucvu")) { chucvu = new BusinessLayer.ChucVuBsn(); da = chucvu.GetDataAdapter(); da.Fill(ds, "ChucVu"); cbbChucvu.DataSource = ds; cbbChucvu.DisplayMember = "ChucVu.TenCV"; cbbChucvu.ValueMember = "ChucVu.MaCv"; } if (ctrlChild.Name.Equals("cbbMucluong")) { luong = new BusinessLayer.LuongBns(); da = luong.GetDataAdapter(); da.Fill(ds, "Luong"); cbbMucluong.DataSource = ds; cbbMucluong.DisplayMember = "Luong.Luong"; cbbMucluong.ValueMember = "Luong.MaLuong"; } if (ctrlChild.Name.Equals("cbbTrinhdo")) { trinhdo = new BusinessLayer.TrinhDoBsn(); da = trinhdo.GetDataAdapter(); da.Fill(ds, "TrinhDo"); cbbTrinhdo.DataSource = ds; cbbTrinhdo.DisplayMember = "TrinhDo.LoaiTrinhDo"; cbbTrinhdo.ValueMember = "TrinhDo.MaTrinhDo"; } if (ctrlChild.Name.Equals("cmbChuyenMon")) { chuyenmon = new BusinessLayer.ChuyenMonBsn(); da = chuyenmon.GetDataAdapter(); da.Fill(ds, "ChuyenMon"); cmbChuyenMon.DataSource = ds; cmbChuyenMon.DisplayMember = "ChuyenMon.TenChuyenMon"; cmbChuyenMon.ValueMember = "ChuyenMon.MaChuyenMon"; } if (ctrlChild.Name.Equals("cbbMaphong")) { phong = new BusinessLayer.PhongBsn(); da = phong.GetDataAdapter(); da.Fill(ds, "Phong"); cbbMaphong.DataSource = ds; cbbMaphong.DisplayMember = "Phong.TenPhong"; cbbMaphong.ValueMember = "Phong.MaPhong"; } if (ctrlChild.Name.Equals("cbbGioitinh")) { cbbGioitinh.DataSource = new BindingSource(gioitinh, null); cbbGioitinh.DisplayMember = "key"; cbbGioitinh.ValueMember = "value"; } fillDataControl(ctrlChild); } }
// public void fillDataControl(Control ctrl) { foreach (Control ctrlChild in ctrl.Controls) { if (ctrlChild.Name.Equals("cbbChucvu")) { chucvu = new BusinessLayer.ChucVuBsn(); da = chucvu.GetDataAdapter(); da.Fill(ds, "ChucVu"); cbbChucvu.DataSource = ds; cbbChucvu.DisplayMember = "ChucVu.TenCV"; cbbChucvu.ValueMember = "ChucVu.MaCv"; } if (ctrlChild.Name.Equals("cbbMucluong")) { luong = new BusinessLayer.LuongBns(); da = luong.GetDataAdapter(); da.Fill(ds, "Luong"); cbbMucluong.DataSource = ds; cbbMucluong.DisplayMember = "Luong.Luong"; cbbMucluong.ValueMember = "Luong.MaLuong"; } if (ctrlChild.Name.Equals("cbbTrinhdo")) { trinhdo = new BusinessLayer.TrinhDoBsn() ; da = trinhdo.GetDataAdapter(); da.Fill(ds, "TrinhDo"); cbbTrinhdo.DataSource = ds; cbbTrinhdo.DisplayMember = "TrinhDo.LoaiTrinhDo"; cbbTrinhdo.ValueMember = "TrinhDo.MaTrinhDo"; } if (ctrlChild.Name.Equals("cmbChuyenMon")) { chuyenmon = new BusinessLayer.ChuyenMonBsn() ; da = chuyenmon.GetDataAdapter(); da.Fill(ds, "ChuyenMon"); cmbChuyenMon.DataSource = ds; cmbChuyenMon.DisplayMember = "ChuyenMon.TenChuyenMon"; cmbChuyenMon.ValueMember = "ChuyenMon.MaChuyenMon"; } if (ctrlChild.Name.Equals("cbbMaphong")) { phong = new BusinessLayer.PhongBsn(); da = phong.GetDataAdapter(); da.Fill(ds, "Phong"); cbbMaphong.DataSource = ds; cbbMaphong.DisplayMember = "Phong.TenPhong"; cbbMaphong.ValueMember = "Phong.MaPhong"; } if (ctrlChild.Name.Equals("cbbGioitinh")) { cbbGioitinh.DataSource = new BindingSource(gioitinh, null); cbbGioitinh.DisplayMember = "key"; cbbGioitinh.ValueMember = "value"; } fillDataControl(ctrlChild); } }