显示项目列表。在我的情况下用户列表
问题描述:
我一直在尝试列出我的数据库中的所有用户,但我很难。我是MVC3的新手帮助。 :)显示项目列表。在我的情况下用户列表
这是我在UserList
using System;
using System.Data.Entity;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.ComponentModel.DataAnnotations;
using MVCDemo.Models.DB;
using MVCDemo.Models.ViewModel;
namespace MVCDemo.Models.ViewModel
{
public class UserList
{
public string FirstName { get; set; }
public string LastName { get; set; }
public string ContactNumber { get; set; }
public string Address { get; set; }
public string Email { get; set; }
public string Username { get; set; }
public string Password { get; set; }
}
public class Users
{
private DeveloperReportEntities dre = new DeveloperReportEntities();
public UserList _userList = new UserList();
public Users()
{
DB.Users_Tbl userTBL = new DB.Users_Tbl();
_userList.FirstName = userTBL.FirstName;
_userList.LastName = userTBL.LastName;
_userList.Email = userTBL.Email;
_userList.Address = userTBL.Address;
_userList.ContactNumber = userTBL.ContactNo;
_userList.Username = userTBL.Username;
_userList.Password = userTBL.Password;
}
}
}
这是应该通过这里进行控制:AdminController
public class AdminController : Controller
{
//
// GET: /Admin/
public ActionResult AdminHomePage()
{
return View();
}
public ActionResult ViewAll()
{
return View();
}
}
在我的解决方案资源管理器中,我有一个samplemodel.edmx在模型文件夹
答
首先,Users
类应封装User
的List
。下面是它应该是什么样子:
/Controllers/Admin/AdminController.cs
public class User
{
public string FirstName { get; set; }
public string LastName { get; set }
}
public class AdminController : Controller
{
//
// GET: /Admin/
public ActionResult AdminHomePage()
{
return View();
}
public ActionResult ViewAll()
{
var userTBL = new DB.Users_Tbl();
var users = userTBL.Select(u => new User { FirstName = u.FirstName, LastName = u.LastName };
return View(users);
}
}
/Views/Admin/ViewAll.cshtml
@model List<User>
<ul>
@foreach(var user in Model)
{
<li>@user.FirstName @user.LastName</li>
}
</ul>
在你ViewAll操作方法,你还没有调用Users类的构造函数。因此,如果要存储这些详细信息,则需要为Users类和inoder创建对象以保存对数据库的更改,您需要调用context.SaveChanges();方法 – 2013-02-23 07:24:26