public static CustomList<UserGroupList> GetAllUserGroupWithUserCode(string userCode) { ConnectionManager conManager = new ConnectionManager(ConnectionName.SysMan); CustomList<UserGroupList> UserGroupListCollection = new CustomList<UserGroupList>(); String sql = "Exec spUserGroupList'" + userCode + "'"; IDataReader reader = null; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { UserGroupList newUserGroup = new UserGroupList(); newUserGroup.SetData(reader); UserGroupListCollection.Add(newUserGroup); } reader.Close(); return UserGroupListCollection; } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }