将实体数据绑定到dx数据网格时获取数据绑定错误 [英] Getting data binding error while binding entity data to dx data grid
本文介绍了将实体数据绑定到dx数据网格时获取数据绑定错误的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我创建了一个角度js应用程序来显示devextreme gridview中的数据。
但是我在绑定数据到dxdatagrid的js中得到数据绑定错误。
我尝试过：
我的Index.cshtml
！DOCTYPE html>
< html ng-app =myApp>
< head>
< title>配置dxDataGrid - Angular Approach< / title>
< meta charset =utf-8/>
< script type =text / javascriptsrc =http://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js>< / script>
< script type =text / javascriptsrc =http://ajax.aspnetcdn.com/ajax/globalize/0.1.1/globalize.min.js>< / script>
< script type =text / javascriptsrc =https://ajax.googleapis.com/ajax/libs/angularjs/1.3.16/angular.min.js>< / script>
< script type =text / javascriptsrc =http://ajax.googleapis.com/ajax/libs/angularjs/1.3.16/angular-sanitize.min.js>< /脚本>
< script src =// cdnjs.cloudflare.com/ajax/libs/angular.js/1.2.20/angular-route.min.js\"></script>
< link rel =stylesheettype =text / csshref =http://cdn3.devexpress.com/jslib/15.2.4/css/dx.common.css/>
< link rel =stylesheettype =text / csshref =http://cdn3.devexpress.com/jslib/15.2.4/css/dx.light.css/>
< script src =〜/ Scripts / dx.all.js>< / script>
@ *< script type =text / javascriptsrc =http://cdn3.devexpress.com/jslib/15.2.4/js/dx.webappjs.js>< / script> * @
< link href =〜/ Content / Site.css =stylesheet/>
< script src =〜/ Scripts / data.js>< / script>
< link href =〜/ Content / dx.light.css =stylesheet/>
< link href =〜/ Content / dx.common.css =stylesheet/>
< script type =text / javascript>
var myApp = angular.module（'myApp'，['dx']）;
myApp.controller（defaultCtrl，function（$ scope）{
var orders = new DevExpress.data.CustomStore（{
load：function（）{
var def = $ .Deferred（）;
$ .getJSON（'/ Home / Get_AllData'）
.success（function（resolvedScreenshots）{
def.resolve（resolvedScreenshots）;
}）
.error（function（）{
def.reject（数据加载错误）;
}）;
//超时：5000
返回def.promise （）;
}
}）;
$ scope.gridSettings = {
dataSource：{
store：orders
}，
/ / dataSource：new DevExpress.data.DataSource（{
// load：function（）{
// var def = $ .Deferred（）;
// $ http（{
//方法：'GET'，
// url：'/ Home / Get_AllData'
//}}。成功（函数（数据） ）{
// def.resolve（data）;
//}）;
//返回def.promise（）;
//}
//}），
// dataSource：employees，
列：[
MP，MPOrigin，POE， MPValidity，Status，Comments，TAG，Actions，Closed，ReqSelection，ReqIPT，ReqGroup，TRSForecast，CurrentForecast，
CreatedForecast ，ToBeCreatedForecast
]，
remoteOperations：{
排序：true，
分页：true
}，
分页：{
pageSize ：25
}，
columnAutoWidth：true，
pager：{
showPageSizeSelector：true，
allowedPageSizes：[25,50,100]，
showInfo ：true
}，
headerFilter：{visible：true}，
height：700，
wi dth：1000，
loadPanel：{
enabled：true
}，
滚动：{
模式：虚拟
}，
filterRow：{
visible：true
}，
// onContentReady：function（e）{
// $（＃gridContainer .dx-scrollable）。dxScrollable（{ showScrollbar：'always'}）;
//}，
groupPanel：{
visible：true，
}，
//编辑：{
// editMode：'row'，
// editEnabled：true，
// removeEnabled：true，
// insertEnabled：true
//}
}
} ）;
< / script>
< / head>
< body ng-controller =defaultCtrl>
< div dx-data-grid =gridSettings>< / div>
< / body>
< / html>
我的Controller.cs
public JsonResult Get_AllData（）
{
var prod = new List< Object>（）;
使用（KPICenterEntities db = new KPICenterEntities（））
{
var product = db.vw_100_QUERY_FOR_XLS_WEEK_IN_PROGRESS_016_Forecast_Follow_Current_Data.Take（100）.ToList（）;
foreach（产品中的var p）
{
var thing = new
{
MP = p.txt_MP，
MPOrigin = p.txt_MP_Origin，
POE = p.txt_POE，
MPValidity = p.txt_MPValidity，
Status = p.txt_Delta，
Comments = p.txt_Comments，
TAG = p.txt_TAG，
Actions = p.txt_Actions，
Closed = p.bit_Closed，
ReqSelection = p.txt_Req_Section，
ReqIPT = p.txt_Req_IPT，
ReqGroup = p.txt_Req_Group，
TRSForecast = p.int_TRS_Forecast，
CurrentForecast = p.int_Current_Forecast，
CreatedForecast = p.int_Created_Forecast，
ToBeCreatedForecast = p.int_ ToBeCreated_Forecast，
};
prod.Add（thing）;
}
}
返回Json（prod，JsonRequestBehavior.AllowGet）;
//使用（KPICenterEntities Obj = new KPICenterEntities（））
// {
// List< tb_dat_IP_KPICenter_Forecast> Emp = Obj.tb_dat_IP_KPICenter_Forecast.ToList（）;
//返回Json（Emp，JsonRequestBehavior.AllowGet）;
//}
}
解决方案
范围）{
var orders = new DevExpress.data.CustomStore（{
load：function（）{
var def =
.Deferred（）;
< blockquote> .getJSON（'/ Home / Get_AllData'）
.success（function（resolvedScreenshots）{
def.resolve（resolvedScreenshots）;
}）
.error（function（ ）{
def.reject（数据加载错误）;
}）;
//超时：5000
返回def.promise（）;
}
}）;
Hi,
I have created one angular js application to display the data in the devextreme gridview.
But i am getting data binding error in js on binding data to dxdatagrid.
What I have tried:
My Index.cshtml
!DOCTYPE html>
<html ng-app="myApp">
<head>
<title>Configuring dxDataGrid - Angular Approach</title>
<meta charset="utf-8" />
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
<script type="text/javascript" src="http://ajax.aspnetcdn.com/ajax/globalize/0.1.1/globalize.min.js"></script>
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/angularjs/1.3.16/angular.min.js"></script>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/angularjs/1.3.16/angular-sanitize.min.js"></script>
<script src="//cdnjs.cloudflare.com/ajax/libs/angular.js/1.2.20/angular-route.min.js"></script>
<link rel="stylesheet" type="text/css" href="http://cdn3.devexpress.com/jslib/15.2.4/css/dx.common.css" />
<link rel="stylesheet" type="text/css" href="http://cdn3.devexpress.com/jslib/15.2.4/css/dx.light.css" />
<script src="~/Scripts/dx.all.js"></script>
@*<script type="text/javascript" src="http://cdn3.devexpress.com/jslib/15.2.4/js/dx.webappjs.js"></script>*@
<link href="~/Content/Site.css" rel="stylesheet" />
<script src="~/Scripts/data.js"></script>
<link href="~/Content/dx.light.css" rel="stylesheet" />
<link href="~/Content/dx.common.css" rel="stylesheet" />
<script type="text/javascript">
var myApp = angular.module('myApp', ['dx']);
myApp.controller("defaultCtrl", function ($scope) {
var orders = new DevExpress.data.CustomStore({
load: function () {
var def = $.Deferred();
$.getJSON('/Home/Get_AllData')
.success(function (resolvedScreenshots) {
def.resolve(resolvedScreenshots);
})
.error(function () {
def.reject("Data Loading Error");
});
//timeout: 5000
return def.promise();
}
});
$scope.gridSettings = {
dataSource: {
store: orders
},
//dataSource: new DevExpress.data.DataSource({
// load: function () {
// var def = $.Deferred();
// $http({
// method: 'GET',
// url: '/Home/Get_AllData'
// }).success(function (data) {
// def.resolve(data);
// });
// return def.promise();
// }
//}),
//dataSource: employees,
columns: [
"MP", "MPOrigin","POE", "MPValidity", "Status", "Comments", "TAG", "Actions", "Closed", "ReqSelection", "ReqIPT", "ReqGroup", "TRSForecast", "CurrentForecast",
"CreatedForecast", "ToBeCreatedForecast"
],
remoteOperations: {
sorting: true,
paging: true
},
paging: {
pageSize: 25
},
columnAutoWidth: true,
pager: {
showPageSizeSelector: true,
allowedPageSizes: [25, 50, 100],
showInfo: true
},
headerFilter: { visible: true },
height: 700,
width: 1000,
loadPanel: {
enabled: true
},
scrolling: {
mode: "virtual"
},
filterRow: {
visible: true
},
//onContentReady: function(e) {
// $("#gridContainer .dx-scrollable").dxScrollable({ showScrollbar: 'always' });
//},
groupPanel: {
visible: true,
},
//editing: {
// editMode: 'row',
// editEnabled: true,
// removeEnabled: true,
// insertEnabled: true
//}
}
});
</script>
</head>
<body ng-controller="defaultCtrl">
<div dx-data-grid="gridSettings"></div>
</body>
</html>
My Controller.cs
public JsonResult Get_AllData()
{
var prod = new List<Object>();
using (KPICenterEntities db = new KPICenterEntities())
{
var product = db.vw_100_QUERY_FOR_XLS_WEEK_IN_PROGRESS_016_Forecast_Follow_Current_Data.Take(100).ToList();
foreach (var p in product)
{
var thing = new
{
MP = p.txt_MP,
MPOrigin = p.txt_MP_Origin,
POE = p.txt_POE,
MPValidity = p.txt_MPValidity,
Status = p.txt_Delta,
Comments = p.txt_Comments,
TAG = p.txt_TAG,
Actions = p.txt_Actions,
Closed = p.bit_Closed,
ReqSelection = p.txt_Req_Section,
ReqIPT = p.txt_Req_IPT,
ReqGroup = p.txt_Req_Group,
TRSForecast = p.int_TRS_Forecast,
CurrentForecast = p.int_Current_Forecast,
CreatedForecast = p.int_Created_Forecast,
ToBeCreatedForecast = p.int_ToBeCreated_Forecast,
};
prod.Add(thing);
}
}
return Json(prod, JsonRequestBehavior.AllowGet);
//using (KPICenterEntities Obj = new KPICenterEntities())
//{
// List<tb_dat_IP_KPICenter_Forecast> Emp = Obj.tb_dat_IP_KPICenter_Forecast.ToList();
// return Json(Emp, JsonRequestBehavior.AllowGet);
//}
}
解决方案
scope) { var orders = new DevExpress.data.CustomStore({ load: function () { var def =
.Deferred();
.getJSON('/Home/Get_AllData') .success(function (resolvedScreenshots) { def.resolve(resolvedScreenshots); }) .error(function () { def.reject("Data Loading Error"); }); //timeout: 5000 return def.promise(); } });
这篇关于将实体数据绑定到dx数据网格时获取数据绑定错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
