$(function(){
function isNotEmpty(value) {
return value !== undefined && value !== null && value !== "";
}
var store = new DevExpress.data.CustomStore({
key: "OrderNumber",
load: function (loadOptions) {
var deferred = $.Deferred(),
args = {};
[
"skip",
"take",
"requireTotalCount",
"requireGroupCount",
"sort",
"filter",
"totalSummary",
"group",
"groupSummary"
].forEach(function(i) {
if (i in loadOptions && isNotEmpty(loadOptions[i]))
args[i] = JSON.stringify(loadOptions[i]);
});
$.ajax({
url: "https://js.devexpress.com/Demos/WidgetsGalleryDataService/api/orders",
dataType: "json",
data: args,
success: function(result) {
deferred.resolve(result.data, {
totalCount: result.totalCount,
summary: result.summary,
groupCount: result.groupCount
});
},
error: function() {
deferred.reject("Data Loading Error");
},
timeout: 5000
});
return deferred.promise();
}
});
$("#gridContainer").dxDataGrid({
dataSource: store,
showBorders: true,
remoteOperations: true,
paging: {
pageSize: 12
},
pager: {
showPageSizeSelector: true,
allowedPageSizes: [8, 12, 20]
},
columns: [{
dataField: "OrderNumber",
dataType: "number"
}, {
dataField: "OrderDate",
dataType: "date"
}, {
dataField: "StoreCity",
dataType: "string"
}, {
dataField: "StoreState",
dataType: "string"
}, {
dataField: "Employee",
dataType: "string"
}, {
dataField: "SaleAmount",
dataType: "number",
format: "currency"
}]
}).dxDataGrid("instance");
});
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>DevExtreme Demo</title>
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0" />
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<script>window.jQuery || document.write(decodeURIComponent('%3Cscript src="js/jquery.min.js"%3E%3C/script%3E'))</script>
<link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/20.2.6/css/dx.common.css" />
<link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/20.2.6/css/dx.light.css" />
<script src="https://cdn3.devexpress.com/jslib/20.2.6/js/dx.all.js"></script>
<script src="index.js"></script>
<link rel="stylesheet" type="text/css" href="styles.css" />
</head>
<body class="dx-viewport">
<div class="demo-container">
<div id="gridContainer"></div>
</div>
</body>
</html>