如何从控制器Action Method查看查询结果？ [英] How to display Query result from controller Action Method to view?

问题描述

Here is my controller code..

public class DetailsController : Controller
    {
        //
        // GET: /Details/
                 

        List<Employee> employees = new List<Employee>();
        List<Department> departments = new List<Department>();
 
        public ActionResult Index()
        {
            employees.Add(new Employee { DepartmentID = 1, EmployeeID = 1, EmployeeName = "Kailas" });
            employees.Add(new Employee { DepartmentID = 2, EmployeeID = 2, EmployeeName = "Dipak" });
            employees.Add(new Employee { DepartmentID = 2, EmployeeID = 3, EmployeeName = "Pramod" });
            employees.Add(new Employee { DepartmentID = 1, EmployeeID = 4, EmployeeName = "Prakash" });
            employees.Add(new Employee { DepartmentID = 3, EmployeeID = 5, EmployeeName = "Pranav" });
            employees.Add(new Employee { DepartmentID = 4, EmployeeID = 6, EmployeeName = "Dipesh" });

            departments.Add(new Department { DepartmentID = 1, DepartmentName = "IT" });
            departments.Add(new Department { DepartmentID = 1, DepartmentName = "BA" });
            departments.Add(new Department { DepartmentID = 1, DepartmentName = "CS" });
            departments.Add(new Department { DepartmentID = 1, DepartmentName = "MBA" });
            departments.Add(new Department { DepartmentID = 1, DepartmentName = "Comm" });

            var list = (from e in employees
                        join d in departments
                        on e.DepartmentID equals d.DepartmentID
                        select new { 
                            EmployeeName = e.EmployeeName,
                            DepartmentName = d.DepartmentName
                        }).ToList();

            return View(list);
        }
	}

推荐答案

阅读MVC上的任何入门教程或阅读有关MVC的任何书籍这些基本主题将被涵盖。论坛不是一个从头学习东西的好地方。

Read any "getting started" tutorial on MVC or read any book on MVC and these basic topics will be covered. A forum is not a good place to learn something from scratch.

你有匿名对象而不是那个通过更改下面的linq类型传递给某些类，如


@model IEnumerable< mvc4webapp.models.employee.employeeviewmodel>

< br $>


@foreach（型号中的var项目）

{

}

员工姓名	部门名称
@ item.EmployeeName	@ item.DepartmentName

在这里我创建了对象对象类，并且我已经在其中定义了部门名称。



之后使用以下代码可以定义你的观点。



ie



@model IEnumerable< mvc4webapp.models.employee.employeeviewmodel>





@foreach（型号中的var项目）

{

}

员工姓名	部门名称
@ item.EmployeeName	@item .DepartmentName

所以上面的代码你可以很好地运行它，如果你需要更多帮助，那就开始学习基本的mvc



http://www.c-sharpcorner.com/UploadFile/deveshomar/simple-way-of / [ ^ ]

Hi,

you have pass anonymous object rather then that pass in some of the class like by changing below linq type as

@model IEnumerable<mvc4webapp.models.employee.employeeviewmodel>


@foreach (var item in Model)
{
}

Employee Name	Department Name
@item.EmployeeName	@item.DepartmentName

here i have create object object class and i have define department name in it.

after that with below code you can define your view.

i.e

@model IEnumerable<mvc4webapp.models.employee.employeeviewmodel>


@foreach (var item in Model)
{
}

Employee Name	Department Name
@item.EmployeeName	@item.DepartmentName

so with above code you can run it very well and if you need more help then start leaning with basic mvc

http://www.c-sharpcorner.com/UploadFile/deveshomar/simple-way-of-binding-list-of-objects-to-view-using-mvc/[^]

这篇关于如何从控制器Action Method查看查询结果？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！