首页 > 解决方案 > 如何在 CLASS 而不是 Code-Behind 中编写此 LIST?

问题描述

我在代码隐藏中有这种工作方法,它可以获取用户及其角色:

//code-behind working fine
private void DisplayUserAndRolesInGrid()
{
    using (myDB dataContext = new myDB())
    {
        var UserRole = (from u in dataContext.aspnet_Users.Include("aspnet_Roles")
                        from r in u.aspnet_Roles
                        where r != null
                        select new { User = u, Role = r }).ToList();
        grdUserRoles.DataSource = UserRole.ToArray();
        grdUserRoles.DataBind();
    }
}

但我需要将它放在一个中并返回一个列表,所以我做了以下错误(我想我需要以某种方式修改这一行:public List<aspnet_Roles> GetUserAndRoles()):

//in a Class with error
public class UsersClass
{
    public List<aspnet_Roles> GetUserAndRoles()
    {
        List<aspnet_Roles> UserRoles = new List<aspnet_Roles>();
        using (myDB dataContext = new myDB())
        {
            UserRoles = (from u in dataContext.aspnet_Users.Include("aspnet_Roles")
                            from r in u.aspnet_Roles
                            where r != null
                            select new { User = u, Role = r }).ToList();
        }
        return UserRoles;
    }
}

在此处输入图像描述

任何帮助表示赞赏。请我坚持这一点。

标签: c#asp.netlistlinqcode-behind

解决方案


推荐阅读