如何在 MVC ASP.NET 选择列表编辑中组合两个字段

Question

在我的情况下，在选择列表中显示我只需要添加用户名字 用户姓氏附近 Asp.net MVC

ViewBag.StoreAccountManager = new SelectList(db.USERS, "UsersId", "UsersFirstName", STORE.StoreAccountManager);

Answer 1

首先创建一个新类型

class MyUsers
{
public int id { get; set; }
public string name { get; set; }
};

然后像这样使用它

var query = from u in db.Users
select new MyUsers
{
id = u.UsersId,
name = u.UsersFirstName+ " " + u.UsersFirstName
};
List<MyUsers> list = query.ToList();
ViewBag.StoreAccountManager = new SelectList(db.USERS, "id", "name", STORE.StoreAccountManager);