System.Data.OleDb.OleDbConnection dbConnection = null;
string strSQL = "SELECT certID, firstName, lastName, OACert, OCCert, initialCertDate, recertDate1, recertDate2, recertDate3, recertDate4, recertDate5, recertDate5, recertDate6, decertDate, decertReason FROM cert INNER JOIN users ON cert.userID = users.userID ORDER BY lastName ASC, firstName ASC";
System.Data.OleDb.OleDbDataReader dr = null;
System.Data.OleDb.OleDbCommand dbCmd = null;
try
{
   dbConnection = new System.Data.OleDb.OleDbConnection(MyCommon.GetDatabaseString("pts"));
   dbConnection.Open();
   dbCmd = new System.Data.OleDb.OleDbCommand(strSQL, dbConnection);
   dr = dbCmd.ExecuteReader();
   dgCertsAdmin.DataSource = dr;
   dgCertsAdmin.DataBind()
}
finally
{
   if (!dbConnection.Equals(null))
      if (dbConnection.State.Equals(System.Data.ConnectionState.Open))
         dbConnection.Close();
}