public static List<string> GetState(string prefixText) { try { DataTable dt = new DataTable(); SearchResumeREBAL searchResumeBAL = new SearchResumeREBAL(); dt = searchResumeBAL.GetStateBAL(prefixText); List<string> rolename = new List<string>(); for (int i = 0; i < dt.Rows.Count; i++) { rolename.Add(dt.Rows[i][1].ToString()); } return rolename; } catch (Exception) { throw; } }