public static List <string> execute(string first_name, string last_name, string connection) { List <string> result = new List <string>(); //List<string> result = new List<string>(); OdbcConnection db = new OdbcConnection(); db.ConnectionString = "FIL=MS Access;DSN=" + connection; try { db.Open(); //Select all patients with future appointments //SELECT PATIENTS.PatientID, PATIENTS.LastName, PATIENTS.FirstName, APPOINTMENTS."Time", APPOINTMENTS."Date" FROM PATIENTS, APPOINTMENTS WHERE PATIENTS.PatientID = APPOINTMENTS.PatientID AND(APPOINTMENTS."Date" > CURDATE()) ORDER BY APPOINTMENTS."Date" DESC OdbcCommand query = new OdbcCommand("SELECT PATIENTS.PatientID, PATIENTS.LastName, PATIENTS.FirstName, APPOINTMENTS.\"Time\", APPOINTMENTS.\"Date\" FROM PATIENTS, APPOINTMENTS WHERE PATIENTS.PatientID = APPOINTMENTS.PatientID AND(PATIENTS.FirstName = '" + first_name + "') AND(PATIENTS.LastName = '" + last_name + "')AND (APPOINTMENTS.\"Date\" > CURDATE()) ORDER BY APPOINTMENTS.\"Date\" DESC", db); OdbcDataReader reader = query.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { result.Add(reader.GetString(4) + " " + reader.GetTime(3).ToString()); } } } catch (Exception ex) { MessageBox.Show("Couldn't connect to database, error: " + ex, "Connection Error", MessageBoxButtons.OK); return(result); } finally { db.Close(); } return(result); }