private void ConnectToDb()
{
dBUtilities = new DBUtilities();
DataTable dt = dBUtilities.QueryTable(
"SELECT e.*, p.PositionName " +
"FROM tblEmployees e INNER JOIN tblPosition p " +
"ON e.PositionID = p.PositionID " +
"ORDER BY ID;");
foreach (DataRow row in dt.Rows)
{
ListViewItem item = new ListViewItem(row["ID"].ToString());
item.SubItems.Add(row["FirstName"].ToString());
item.SubItems.Add(row["LastName"].ToString());
item.SubItems.Add(row["MiddleName"].ToString());
item.SubItems.Add(row["PositionName"].ToString());
item.SubItems.Add(row["Gender"].ToString());
string bdate = Convert.ToDateTime(row["BDate"].ToString()).ToString("MMM dd, yyy");
item.SubItems.Add(bdate);
item.SubItems.Add(row["HomeAddress"].ToString());
item.SubItems.Add(row["TellNo"].ToString());
item.SubItems.Add(row["MobileNo"].ToString());
item.SubItems.Add(row["EmailAddress"].ToString());
lstEmployees.Items.Add(item);
}
}
private void loadPositions()
{
try
{
cmbPosition.Items.Clear();
DataTable positions = utilities.QueryTable("SELECT PositionName From tblPosition");
foreach (DataRow row in positions.Rows)
{
cmbPosition.Items.Add(row["PositionName"].ToString());
}
}catch (Exception ex)
{
}
}
