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); } }
public frmAddEmployee() { InitializeComponent(); utilities = new DBUtilities(); loadPositions(); }
public frmLogin() { InitializeComponent(); utilities = new DBUtilities(); }
public formAddPosition() { InitializeComponent(); utilities = new DBUtilities(); }