void NhanDuLieu() { dsLop.Clear(); string strSelect = "Select * From Lop"; Mypublic.OpenData(strSelect, dsLop, "Lop"); dgvLop.DataSource = dsLop; dgvLop.DataMember = "Lop"; }
private void frmLop_Load(object sender, EventArgs e) { string strSelect = "Select * From Lop"; Mypublic.OpenData(strSelect, dsLop, "Lop", daLop); bsLop.DataSource = dsLop; bsLop.DataMember = "Lop"; cboLop.DisplayMember = "TenLop"; cboLop.ValueMember = "MSLop"; txtMSLop.MaxLength = 8; txtTenLop.MaxLength = 40; txtVitri.ReadOnly = true; txtVitri.BackColor = Color.White; GanDuLieu(); DieuKhienKhiBinhThuong(); }
private void frmSinhVienTheoLop_Load(object sender, EventArgs e) { string strSelect = "Select MSLop, TenLop From Lop"; Mypublic.OpenData(strSelect, dsLop, "Lop"); cboLop.DataSource = dsLop.Tables["Lop"]; cboLop.DisplayMember = "TenLop"; cboLop.ValueMember = "MSLop"; dsQuyenSD.Tables.Add("DSQuyenSD"); dsQuyenSD.Tables["DSQuyenSD"].Columns.Add("QuyenSD"); dsQuyenSD.Tables["DSQuyenSD"].Rows.Add("User"); dsQuyenSD.Tables["DSQuyenSD"].Rows.Add("AdminLop"); dsQuyenSD.Tables["DSQuyenSD"].Rows.Add("AdminKhoa"); cboQuyenSD.DataSource = dsQuyenSD; cboQuyenSD.DisplayMember = "DSQuyenSD.QuyenSD"; cboQuyenSD.ValueMember = "DSQuyenSD.QuyenSD"; txtHoLot.MaxLength = 30; txtTen.MaxLength = 30; txtMSSV.MaxLength = 8; NhanDuLieu(); dvSinhVien.Table = dsSinhVien.Tables["SinhVien"]; dvSinhVien.RowFilter = "MSLop like'" + cboLop.SelectedValue + "'"; dgvSinhVien.DataSource = dvSinhVien; dgvSinhVien.Width = 790; dgvSinhVien.AllowUserToAddRows = false; dgvSinhVien.AllowUserToDeleteRows = false; dgvSinhVien.Columns[0].Width = 85; dgvSinhVien.Columns[0].HeaderText = "Mã số"; dgvSinhVien.Columns[1].Width = 140; dgvSinhVien.Columns[1].HeaderText = "Họ lót"; dgvSinhVien.Columns[2].Width = 60; dgvSinhVien.Columns[2].HeaderText = "Tên"; dgvSinhVien.Columns[3].Width = 50; dgvSinhVien.Columns[3].HeaderText = "Phái"; dgvSinhVien.Columns[4].Width = 100; dgvSinhVien.Columns[4].HeaderText = "Ngày sinh"; dgvSinhVien.Columns[5].Width = 90; dgvSinhVien.Columns[5].HeaderText = "MS Lớp"; dgvSinhVien.Columns[6].Width = 100; dgvSinhVien.Columns[6].HeaderText = "Mật khẩu"; dgvSinhVien.Columns[7].Width = 100; dgvSinhVien.Columns[7].HeaderText = "Quyền SD"; dgvSinhVien.EditMode = DataGridViewEditMode.EditProgrammatically; dgvSinhVien.CellFormatting += new DataGridViewCellFormattingEventHandler(this.dgvSinhVien_CellFormatting); GanDuLieu(); DieuKhienKhiBinhThuong(); }
void NhanDuLieu() { string strSelect = "Select * From SinhVien"; Mypublic.OpenData(strSelect, dsSinhVien, "SinhVien"); }