kendo grid mvc 4使用json [英] kendo grid mvc 4 using json

问题描述

我正在使用kendo网格

我的控制器在这里将实体传递给我的模型然后在视图中调用

i am using kendo grid
my controller is here am passing the entity to my model then calling in view

public ActionResult samplem1([DataSourceRequest]DataSourceRequest request)
        {
   
            var t=GetCustomers().ToDataSourceResult(request);

            return Json(t, JsonRequestBehavior.AllowGet);
        }
        private static IEnumerable<Northwindproduct> GetCustomers()
        {
            var northwind = new KaushikEntities();
            var purchCount = northwind.tblEmployees.Count();
            return northwind.tblEmployees.Select(product => new Northwindproduct
            {
                id = product.Id,
                Name = product.Name,
                Gender = product.Gender,
                City = product.City

            });
        }



@( Html.Kendo().Grid<KendoUIMvcApplication2.Models.Northwindproduct>()
   .Name("grid")
      .DataSource(dataSource => dataSource
          .Ajax()
                  .Model(model => model.Id(product => product.id))
                  .Read(read => read.Action("samplem1", "Home") 
          )
      )
      .Columns(columns =>
      {
          columns.Bound(product => product.City);
          columns.Bound(product => product.Name);
          columns.Bound(product => product.Gender);
      })
      .Pageable()
      .Sortable()
)

i需要数据显示在一个kendo网格中，但我得到的数据是

i need the data to display in a kendo grid but am getting data as

{"Data":[{"id":1,"Name":"Mark","Gender":"Male","City":"London","DateOfBirth":"\/Date(-62135568000000)\/"},{"id":2,"Name":"John","Gender":"Male","City":"Chennai","DateOfBirth":"\/Date(-62135568000000)\/"},{"id":3,"Name":"Mary","Gender":"Female","City":"New York","DateOfBirth":"\/Date(-62135568000000)\/"},{"id":4,"Name":"Mike","Gender":"Male","City":"Sydeny","DateOfBirth":"\/Date(-62135568000000)\/"},{"id":5,"Name":"Scott","Gender":"Male","City":"London","DateOfBirth":"\/Date(-62135568000000)\/"}],"Total":5,"AggregateResults":null,"Errors":null}

推荐答案

在.DataSource中，请提及pagesize

.PageSize（10）

Inside the .DataSource please mention the pagesize
.PageSize(10)

1.使用命名空间

使用Kendo.Mvc.UI;

使用Kendo.Mvc.Extensions;



2.Http获得通行证某些视图，其中有网格视图

public ActionResult samplem1（）

{

返回查看（）;

}



[HttpPost]

public ActionResult samplem1Post（[DataSourceRequest] DataSourceRequest request）

$

var GetResult = _revenue.GetFromDatabase（）;

DataSourceResult result = GetResult。 ToDataSourceResult（request）;

返回Json（结果）; }







@（Html.Kendo（）。网格（模特）

.Name（grid）

.DataSource（dataSource => dataSource

.Ajax（）

。读取（读取） => read.Action（samplem1Post，Home）

）

）

.Columns（columns =>

{

columns.Bound（product => product.City）;

columns.Bound（product => product.Name）;

columns.Bound（product => product.Gender）;

}）

.Pageable（）

.Sortable（）

）

1.Use the Namespaces
using Kendo.Mvc.UI;
using Kendo.Mvc.Extensions;

2.Http get pass to certain view where grid view is there
public ActionResult samplem1()
{
return View();
}

[HttpPost]
public ActionResult samplem1Post([DataSourceRequest]DataSourceRequest request)
{
var GetResult = _revenue.GetFromDatabase();
DataSourceResult result = GetResult. ToDataSourceResult(request);
return Json(result); }



@( Html.Kendo().Grid(Models)
.Name("grid")
.DataSource(dataSource => dataSource
.Ajax()
.Read(read => read.Action("samplem1Post ", "Home")
)
)
.Columns(columns =>
{
columns.Bound(product => product.City);
columns.Bound(product => product.Name);
columns.Bound(product => product.Gender);
})
.Pageable()
.Sortable()
)

public ActionResult samplem1([DataSourceRequest]DataSourceRequest request)
        {

            var t=GetCustomers().ToDataSourceResult(request);

            return Json(t, JsonRequestBehavior.AllowGet);
        }
        private static IEnumerable<Northwindproduct> GetCustomers()
        {
            var northwind = new KaushikEntities();
            var purchCount = northwind.tblEmployees.Count();
            return northwind.tblEmployees.Select(product => new Northwindproduct
            {
                id = product.Id,
                Name = product.Name,
                Gender = product.Gender,
                City = product.City

            });
        }



@( Html.Kendo().Grid<KendoUIMvcApplication2.Models.Northwindproduct>()
   .Name("grid")
      .DataSource(dataSource => dataSource
          .Ajax()
                  .Model(model => model.Id(product => product.id))
                  .Read(read => read.Action("samplem1", "Home")
          )
      )
      .Columns(columns =>
      {
          columns.Bound(product => product.City);
          columns.Bound(product => product.Name);
          columns.Bound(product => product.Gender);
      })
      .Pageable()
      .Sortable()
)

这篇关于kendo grid mvc 4使用json的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！