//Updates the table with medical history information of logged in patient
private void butNote_Click(object sender, EventArgs e)
{
lblTable.Text = "Medical History";
string[] NoteCol = new string[] { "date", "symptom_Name", "symptom_Desc" };
dtTable.DataSource = SQLQuery.SelectTable(NoteCol, "Medical_History", "pId = '" + ID + "'");
}
//Updates the table with prescription information of logged in patient
private void butPrescr_Click(object sender, EventArgs e)
{
lblTable.Text = "Prescriptions";
string[] PrescrCol = new string[] { "date", "presc_Name", "presc_instructions" };
dtTable.DataSource = SQLQuery.SelectTable(PrescrCol, "Prescriptions", "pId = '" + ID + "'");
}