显示项目列表。在我的情况下用户列表

问题描述:

我一直在尝试列出我的数据库中的所有用户,但我很难。我是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在模型文件夹

+0

在你ViewAll操作方法,你还没有调用Users类的构造函数。因此,如果要存储这些详细信息,则需要为Users类和inoder创建对象以保存对数据库的更改,您需要调用context.SaveChanges();方法 – 2013-02-23 07:24:26

首先,Users类应封装UserList。下面是它应该是什么样子:

/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>