$(() => {
const store = DevExpress.data.AspNet.createStore({
key: 'ProductID',
loadUrl: 'https://js.devexpress.com/Demos/Mvc/api/ListData/Orders',
});
const listData = new DevExpress.data.DataSource({
store,
paginate: true,
pageSize: 1,
sort: 'ProductName',
group: 'Category.CategoryName',
filter: ['UnitPrice', '>', 15],
});
const formatCurrency = new Intl.NumberFormat('en-US', {
style: 'currency',
currency: 'USD',
minimumFractionDigits: 2,
maximumFractionDigits: 2,
}).format;
$('#list').dxList({
dataSource: listData,
itemTemplate(data) {
const price = formatCurrency(data.UnitPrice);
return $('<div>')
.append($('<div>').text(data.CategoryName))
.append($('<div>').text(data.ProductName))
.append($('<b>').text(price));
},
grouped: true,
collapsibleGroups: true,
selectionMode: 'multiple',
showSelectionControls: true,
pageLoadMode: 'scrollBottom',
height: 600,
});
});
<!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.6/css/dx.light.css" />
<script src="https://cdn3.devexpress.com/jslib/22.2.6/js/dx.all.js"></script>
<script src="https://unpkg.com/devextreme-aspnet-data@2.9.0/js/dx.aspnet.data.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="list"></div>
</div>
</body>
</html>
using DevExtreme.AspNet.Data;
using DevExtreme.AspNet.Mvc;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Net.Http;
using System.Web.Http;
using DevExtreme.MVC.Demos.Models.Northwind;
namespace DevExtreme.MVC.Demos.Controllers.ApiControllers {
public class ListDataController : ApiController {
NorthwindContext _nwind = new NorthwindContext();
[HttpGet]
public HttpResponseMessage Get(DataSourceLoadOptions loadOptions) {
return Request.CreateResponse(
DataSourceLoader.Load(_nwind.Products.Include("Category"), loadOptions)
);
}
}
}