public static string[] GetMedicationNames(string prefixText, int count) { PatientInfoDAL Pat_Info = new PatientInfoDAL(); List<string> Pat_List = new List<string>(); Pat_Info = new PatientInfoDAL(); Pat_List.Clear(); DataTable Pat_Names = Pat_Info.get_MedicationNames(prefixText); foreach (DataRow dr in Pat_Names.Rows) { Pat_List.Add(AjaxControlToolkit.AutoCompleteExtender.CreateAutoCompleteItem(dr[0].ToString(), dr[1].ToString())); } return Pat_List.ToArray(); }
public static string[] GetMedicationNames(string prefixText, int count) { PatientInfoDAL Pat_Info = new PatientInfoDAL(); List<string> Med_List = new List<string>(); Pat_Info = new PatientInfoDAL(); Med_List.Clear(); DataTable Med_Names = Pat_Info.get_MedicationNames(prefixText.Trim()); if (Med_Names.Rows.Count > 0) { foreach (DataRow dr in Med_Names.Rows) { Med_List.Add(AjaxControlToolkit.AutoCompleteExtender.CreateAutoCompleteItem(dr[0].ToString(), dr[1].ToString())); } } else { Med_List.Add(AjaxControlToolkit.AutoCompleteExtender.CreateAutoCompleteItem("No Medication Found..","0")); } return Med_List.ToArray(); }