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) { } }