public void Hienthi() { lstHS = HocSinhController.getAllDataHS(); DataTable dt = ViewHelper.ToDataTable <HocSinh>(lstHS); dtgHocSinh.DataSource = dt; dtgHocSinh.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dt.Columns["MaHS"].ColumnName = "Mã HS"; dt.Columns["HoTen"].ColumnName = "Họ Tên"; dt.Columns["NgaySinh"].ColumnName = "Ngày Sinh"; dt.Columns["DiaChi"].ColumnName = "Địa Chỉ"; dt.Columns["GioiTinh"].ColumnName = "Giới Tính (Nữ/nam ✓)"; dt.Columns["Sdt"].ColumnName = "SĐT"; dt.Columns["TenPhuHuynh"].ColumnName = "Tên Phụ Huynh"; dt.Columns["SDTphuHuynh"].ColumnName = "SDT Phụ Huynh"; dt.Columns["TenLop"].ColumnName = "Mã Lớp"; int i = 0; foreach (DataGridViewColumn col in dtgHocSinh.Columns) { col.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; col.HeaderCell.Style.Font = new Font("Arial", 12F, FontStyle.Bold, GraphicsUnit.Pixel); dtgHocSinh.Columns[i].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; i++; } try { dtgHocSinh.CurrentCell = dtgHocSinh[CurCl, CurR]; } catch { } dtgHocSinh.Refresh(); }
public frmThaoTacHS(string _MaHS, string _HoTen, string _DiaChi, bool _GioiTinh, string _Sdt, DateTime _NgaySinh, string _TenPhuHuynh, string _SDTphuHuynh, string _TenLop, int state) { InitializeComponent(); _state = state; lstHS = HocSinhController.getAllDataHS(); if (state == 2) { txtID.Enabled = false; } txtID.Text = _MaHS; txtTen.Text = _HoTen; txtDiaChi.Text = _DiaChi; if (_GioiTinh) { radNam.Checked = true; } else { radNu.Checked = true; } dateNgaySinh.Value = _NgaySinh; txtSDT.Text = _Sdt; txtTenPhuHuynh.Text = _TenPhuHuynh; txtSDTphuHuynh.Text = _SDTphuHuynh; ///Thao tac ma lop ///1. Get all ma lop /// using (var db = setupConection.ConnectionFactory()) { if (db.State == ConnectionState.Closed) { db.Open(); } List <Lop> list = db.Query <Lop>("SELECT MaLop,TenLop FROM dbo.Lop").ToList(); for (int i = 0; i < list.Count; i++) { ComboboxItem item = new ComboboxItem(); item.Text = list[i].TenLop.ToString(); item.Value = list[i].MaLop.ToString(); cbClass.Items.Add(item); if (_TenLop == list[i].TenLop) { cbClass.SelectedIndex = i; } } } }