asp.net-mvc 如何在asp.net MVC 4 Razor中绑定Kendo Grid

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/18465337/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-08 03:07:25  来源:igfitidea点击:

How to bind the Kendo Grid in asp.net MVC 4 Razor

asp.net-mvcasp.net-mvc-4kendo-uikendo-gridkendo-asp.net-mvc

提问by Bhupendra Shukla

I have create the asp.net MVC 4 application where i am using the entity framework and class "Data" is the model.

我已经创建了 asp.net MVC 4 应用程序,我在其中使用了实体框架,类“Data”是模型。

AdventureWorksTrainingEntities _dbContext = new AdventureWorksTrainingEntities();
Data _data = new Data();  //Model

Now i want to display the data of the table to the kendo grid. In the controller, i am using the following code:

现在我想将表格的数据显示到剑道网格中。在控制器中,我使用以下代码:

 public ActionResult Index()
        {
           List<Movie> dataForGrid= _dbContext.Movies.ToList();
           return View(dataForGrid);
        }

Now i have no idea for displaying the data in Kendo Grid (i am new to kendo and MVC). I have also tried the following but not working:

现在我不知道在剑道网格中显示数据(我是剑道和 MVC 的新手)。我也尝试了以下但不起作用:

@model   IEnumerable<MvcApp.Models.Data>
@using Kendo.Mvc.UI 
@{
    ViewBag.Title = "Index";
}

<h2>Grid For Data</h2>
Html.Kendo().Grid<Order>()
    .Name("Grid")
    .DataSource(dataSource => dataSource // Not implemented
)

回答by Bhupendra Shukla

Finally got answer:

终于得到答案:

View:

看法:

@(Html.Kendo().Grid<KendoUI.Models.EmployeeViewModel>()
            .Name("Grid")
            .Columns(columns =>
            {
                columns.Bound(p => p.name).Title("Name");
                columns.Bound(p => p.gender).Title("Gender");
                columns.Bound(p => p.designation).Title("Designation").Width("300px");
                columns.Bound(p => p.department).Title("Department").Width("300px");
            })

            .Editable(editable => editable.Mode(GridEditMode.InLine))
            .Navigatable() 
            .Pageable()
            .Sortable()
            .Scrollable()
            .DataSource(dataSource => dataSource // Configure the grid data source
            .Ajax()
            .Model(model =>
            {
                model.Id(x => x.id);
            })
                .Read(read => read.Action("Employee_Read", "Home")) // Set the action method which will return the data in JSON format  
             )
            )

Controller:

控制器:

 public ActionResult Employee_Read([DataSourceRequest]DataSourceRequest request)
        {
            IQueryable<Bhupendra_employees> Details = _dbContext.Bhupendra_employees;
            DataSourceResult result = Details.ToDataSourceResult(request, p => new EmployeeViewModel
                    {
                        id = p.id,
                        name = p.name,
                        gender = p.gender,
                        designation = p.designation,
                        department = p.Bhupendra_Dept.Dept_Description
                    });
            return Json(result, JsonRequestBehavior.AllowGet);
        }

Model:

模型:

public class EmployeeViewModel
    {
        public Int32 id { get; set; }
        public String name { get; set; }
        public String gender { get; set; }
        public String designation { get; set; }
        public String department { get; set; }
        //public DateTime dob { get; set; }
    }

回答by Monah

if your controller name is Data then you can use the following

如果您的控制器名称是 Data 那么您可以使用以下内容

Your Model

你的模特

 public ActionResult ReadDegrees([DataSourceRequest] DataSourceRequest request)
    {
        ViewBag.Countries = CommonController.CountryList();
        ViewBag.DegreeTypes = CommonController.DegreeTypeList();
        using (var _dbContext= new AdventureWorksTrainingEntities ())
        {
            return Json(_dbContext.Movies.ToList.ToDataSourceResult(request));
        }
    }

Your View Just you need to add the following assuming that your Model has a Key called ID

您的视图 假设您的模型有一个名为 ID 的密钥,您只需添加以下内容

Html.Kendo().Grid<Order>()
.Name("Grid")
.DataSource(dataSource => dataSource
    .Ajax()
    .PageSize(20)
    .Model(model => model.Id(p => p.ID))
    .Read(read => read.Action("ReadDegrees", "Data"))))