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;
}
}
}
}
