$(() => {
function isNotEmpty(value) {
return value !== undefined && value !== null && value !== '';
}
const store = new DevExpress.data.CustomStore({
key: 'OrderNumber',
load(loadOptions) {
const deferred = $.Deferred();
const args = {};
[
'skip',
'take',
'requireTotalCount',
'requireGroupCount',
'sort',
'filter',
'totalSummary',
'group',
'groupSummary',
].forEach((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(result) {
deferred.resolve(result.data, {
totalCount: result.totalCount,
summary: result.summary,
groupCount: result.groupCount,
});
},
error() {
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/22.2.5/css/dx.light.css" />
<script src="https://cdn3.devexpress.com/jslib/22.2.5/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>