public List <Medications> getAllMedications(int patientID) { clsUtility.Connection = dbTool.getConnectionString(); InfiniEdge.SqlParameterCollection parameters = new InfiniEdge.SqlParameterCollection(); parameters.Add(new SqlParameter("@PatientID", patientID)); List <Medications> tmpMeds = new List <Medications>(); SqlDataReader sqlDR = clsUtility.ExecuteSP_DataReader("getMedication", parameters); try { while (sqlDR.Read()) { Medications tmpM = new Medications(); tmpM.Dosage = Single.Parse(sqlDR["Dosage"].ToString()); tmpM.Measurement = sqlDR["Measurement"].ToString(); tmpM.MedicationDesc = sqlDR["Medication Name"].ToString(); tmpM.MedicationId = Int32.Parse(sqlDR["MedicationId"].ToString()); tmpM.PatientID = Int32.Parse(sqlDR["PatientID"].ToString()); tmpMeds.Add(tmpM); } return(tmpMeds); } finally { sqlDR.Close(); } }