//View expanded patient info on new page
 private void buttonMoreInfo_Click(object sender, EventArgs e)
 {
     if (PatientsMoreInfo != null)
     {
         PatientMoreInfo moreInfo = new PatientMoreInfo(PatientsMoreInfo, false);
         moreInfo.Show();
     }
 }
        private void buttonPatientSearch_Click(object sender, EventArgs e)
        {
            ConnectDB EMRDatabase = new ConnectDB();

            Patients = EMRDatabase.Select(SSN);  //retrieve by SSN

            PatientsMoreInfo[0]  = Patients[0][0];
            PatientsMoreInfo[1]  = Patients[1][0];
            PatientsMoreInfo[2]  = Patients[11][0];
            PatientsMoreInfo[3]  = Patients[4][0];
            PatientsMoreInfo[4]  = Patients[6][0];
            PatientsMoreInfo[5]  = Patients[5][0];
            PatientsMoreInfo[6]  = Patients[7][0];
            PatientsMoreInfo[7]  = Patients[2][0];
            PatientsMoreInfo[8]  = Patients[9][0];
            PatientsMoreInfo[9]  = Patients[8][0];
            PatientsMoreInfo[10] = Patients[3][0];
            PatientsMoreInfo[11] = Patients[10][0];
            PatientMoreInfo moreInfo = new PatientMoreInfo(PatientsMoreInfo, true);

            moreInfo.Show();
        }