private void BindGrid()
{
List <TheCancerProject.Core.Patient> patientList = new List <TheCancerProject.Core.Patient>();
patientList = PatientDAO.RetrieveAll().ToList();
//if (patient != null && patient.TheBiodata != null && !string.IsNullOrWhiteSpace(patient.TheBiodata.HospitalNumber))
//{
// investigationHistoryForPatient = new InvestigationDAO().RetrieveByPatientHospitalNumber(patient.TheBiodata.HospitalNumber);
//}
GridView1.DataSource = patientList;
GridView1.DataBind();
}