private void ShowTable() { using (DataTable table = new DataTable())// gv.getAll(id, pass)) { table.Columns.Add("MAGV", typeof(string)); table.Columns.Add("TENGV", typeof(string)); table.Columns.Add("GIOITINH", typeof(string)); table.Columns.Add("NGSINH", typeof(DateTime)); table.Columns.Add("DIACHI", typeof(string)); table.Columns.Add("SDT", typeof(string)); table.Columns.Add("EMAIL", typeof(string)); table.Columns.Add("TRINHDO", typeof(string)); table.Columns.Add("BANGCAP", typeof(string)); table.Columns.Add("NGAYVL", typeof(DateTime)); table.Columns.Add("HESO", typeof(double)); DataTable newTable = gv.getAll(AccountHelper.getAccountId(), AccountHelper.getAccoutPassword()); string tempGioiTinh = ""; foreach (DataRow row in newTable.Rows) { if (row.Field <int>(2) == 0) { tempGioiTinh = "nữ"; } else { tempGioiTinh = "nam"; } table.Rows.Add( row.Field <string>(0), row.Field <string>(1), tempGioiTinh, row.Field <DateTime>(3), row.Field <string>(4), row.Field <string>(5), row.Field <string>(6), row.Field <string>(7), row.Field <string>(8), row.Field <DateTime>(9), row.Field <double>(10)); } dataGridView1.DataSource = table; } }
void InitGiangVien() { GiangVien gv = new GiangVien(); DataTable dt = gv.getAll(AccountHelper.getAccountId(), AccountHelper.getAccoutPassword()); dtGiangVien = new DataTable(); dtGiangVien.Columns.Add("TENGV", typeof(string)); dtGiangVien.Columns.Add("MAGV", typeof(string)); var rowsTarget = dtGiangVien.Rows; var rows = dt.Rows; for (int i = 0; i < rows.Count; i++) { rowsTarget.Add(rows[i].Field <string>(1), rows[i].Field <string>(0)); } PopulateGiangVien(); }