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