Backend API
<dx-data-grid
id="grid"
[dataSource]="dataSource"
[repaintChangesOnly]="true"
[showBorders]="true"
>
<dxo-data-grid-scrolling mode="virtual"></dxo-data-grid-scrolling>
<dxo-data-grid-editing
mode="cell"
[refreshMode]="refreshMode"
[allowAdding]="true"
[allowUpdating]="true"
[allowDeleting]="true"
>
</dxo-data-grid-editing>
<dxi-data-grid-column dataField="CustomerID" caption="Customer">
<dxo-data-grid-lookup
[dataSource]="customersData"
valueExpr="Value"
displayExpr="Text"
></dxo-data-grid-lookup>
</dxi-data-grid-column>
<dxi-data-grid-column
dataField="OrderDate"
dataType="date"
></dxi-data-grid-column>
<dxi-data-grid-column dataField="Freight"></dxi-data-grid-column>
<dxi-data-grid-column dataField="ShipCountry"></dxi-data-grid-column>
<dxi-data-grid-column
dataField="ShipVia"
caption="Shipping Company"
dataType="number"
>
<dxo-data-grid-lookup
[dataSource]="shippersData"
valueExpr="Value"
displayExpr="Text"
></dxo-data-grid-lookup>
</dxi-data-grid-column>
<dxo-data-grid-summary>
<dxi-data-grid-total-item column="CustomerID" summaryType="count">
</dxi-data-grid-total-item>
<dxi-data-grid-total-item
column="Freight"
summaryType="sum"
valueFormat="#0.00"
>
</dxi-data-grid-total-item>
</dxo-data-grid-summary>
</dx-data-grid>
<div class="options">
<div class="caption">Options</div>
<div class="option">
<span>Refresh Mode:</span>
<dx-select-box
[(value)]="refreshMode"
[items]="refreshModes"
[inputAttr]="{ 'aria-label': 'Refresh Mode' }"
>
</dx-select-box>
</div>
<div id="requests">
<div>
<div class="caption">Network Requests</div>
<dx-button id="clear" text="Clear" (onClick)="clearRequests()">
</dx-button>
</div>
<ul>
@for(request of requests; track request) {
<li>{{ request }}</li>
}
</ul>
</div>
</div>
import { bootstrapApplication } from '@angular/platform-browser';
import {
ChangeDetectorRef, Component, enableProdMode, provideZoneChangeDetection,
} from '@angular/core';
import { HttpClient, HttpParams, provideHttpClient, withFetch } from '@angular/common/http';
import { lastValueFrom, Observable } from 'rxjs';
import { DxDataGridModule, DxSelectBoxModule, DxButtonModule } from 'devextreme-angular';
import { CustomStore } from 'devextreme-angular/common/data';
import { formatDate } from 'devextreme-angular/common/core/localization';
if (!/localhost/.test(document.location.host)) {
enableProdMode();
}
const URL = 'https://js.devexpress.com/Demos/NetCore/api/DataGridWebApi';
@Component({
selector: 'demo-app',
templateUrl: './app.component.html',
styleUrls: ['./app.component.css'],
preserveWhitespaces: true,
imports: [
DxDataGridModule,
DxSelectBoxModule,
DxButtonModule,
],
})
export class AppComponent {
dataSource: CustomStore;
requests: string[] = [];
refreshModes = ['full', 'reshape', 'repaint'];
refreshMode = 'reshape';
customersData = {
paginate: true,
store: new CustomStore({
key: 'Value',
loadMode: 'raw',
load: () => this.sendRequest(`${URL}/CustomersLookup`),
}),
};
shippersData = new CustomStore({
key: 'Value',
loadMode: 'raw',
load: () => this.sendRequest(`${URL}/ShippersLookup`),
});
constructor(private http: HttpClient, private changeDetectorRef: ChangeDetectorRef) {
this.dataSource = new CustomStore({
key: 'OrderID',
load: () => this.sendRequest(`${URL}/Orders`),
insert: (values) => this.sendRequest(`${URL}/InsertOrder`, 'POST', {
values: JSON.stringify(values),
}),
update: (key, values) => this.sendRequest(`${URL}/UpdateOrder`, 'PUT', {
key,
values: JSON.stringify(values),
}),
remove: (key) => this.sendRequest(`${URL}/DeleteOrder`, 'DELETE', {
key,
}),
});
}
async sendRequest(url: string, method = 'GET', data = {}) {
this.logRequest(method, url, data);
const httpParams = new HttpParams({ fromObject: data });
const httpOptions = {
withCredentials: true,
[method === 'GET' ? 'params' : 'body']: httpParams,
};
let request: Observable<Object>;
switch (method) {
case 'GET':
request = this.http.get(url, httpOptions);
break;
case 'PUT':
request = this.http.put(url, httpParams, httpOptions);
break;
case 'POST':
request = this.http.post(url, httpParams, httpOptions);
break;
case 'DELETE':
request = this.http.delete(url, httpOptions);
break;
}
try {
const result = await lastValueFrom<any>(request);
return method === 'GET' ? result.data : {};
} catch (e) {
throw e.error.Message;
}
}
logRequest(method: string, url: string, data: object): void {
const args = Object.keys(data || {}).map((key) => `${key}=${data[key]}`).join(' ');
const time = formatDate(new Date(), 'HH:mm:ss');
this.requests.unshift([time, method, url.slice(URL.length), args].join(' '));
this.changeDetectorRef.detectChanges();
}
clearRequests() {
this.requests = [];
}
}
bootstrapApplication(AppComponent, {
providers: [
provideZoneChangeDetection({ eventCoalescing: true, runCoalescing: true }),
provideHttpClient(withFetch()),
],
});
::ng-deep #grid {
height: 440px;
}
.options {
padding: 20px;
margin-top: 20px;
background-color: rgba(191, 191, 191, 0.15);
}
.caption {
margin-bottom: 10px;
font-weight: 500;
font-size: 18px;
}
.option {
margin-bottom: 10px;
}
.option > span {
position: relative;
top: 2px;
margin-right: 10px;
}
::ng-deep .option > .dx-widget {
display: inline-block;
vertical-align: middle;
}
::ng-deep #requests .caption {
float: left;
padding-top: 7px;
}
::ng-deep #requests > div {
padding-bottom: 5px;
}
::ng-deep #requests > div::after {
content: "";
display: table;
clear: both;
}
::ng-deep #requests #clear {
float: right;
}
::ng-deep #requests ul {
list-style: none;
max-height: 100px;
overflow: auto;
margin: 0;
}
::ng-deep #requests ul li {
padding: 7px 0;
border-bottom: 1px solid #ddd;
}
::ng-deep #requests ul li:last-child {
border-bottom: none;
}
<!DOCTYPE html>
<html lang="en">
<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=5.0" />
<link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/26.1.5/css/dx.light.css" />
</head>
<body class="dx-viewport">
<div class="demo-container">
<demo-app>Loading...</demo-app>
</div>
<script src="https://cdn.jsdelivr.net/npm/zone.js@0.16.2/bundles/zone.umd.js"></script>
<script src="./bundle.js" type="module"></script>
</body>
</html>
using DevExtreme.AspNet.Data;
using DevExtreme.AspNet.Mvc;
using Newtonsoft.Json;
using System;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Net.Http.Formatting;
using System.Web.Http;
using DevExtreme.MVC.Demos.Models.Northwind;
namespace DevExtreme.MVC.Demos.Controllers {
[Route("api/DataGridWebApi/{action}", Name = "DataGridWebApi")]
public class DataGridWebApiController : ApiController {
InMemoryNorthwindContext _nwind = new InMemoryNorthwindContext();
[HttpGet]
public HttpResponseMessage Orders(DataSourceLoadOptions loadOptions) {
return Request.CreateResponse(DataSourceLoader.Load(_nwind.Orders, loadOptions));
}
[HttpPost]
public HttpResponseMessage InsertOrder(FormDataCollection form) {
var values = form.Get("values");
var newOrder = new Order();
JsonConvert.PopulateObject(values, newOrder);
Validate(newOrder);
if(!ModelState.IsValid)
return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState.GetFullErrorMessage());
_nwind.Orders.Add(newOrder);
_nwind.SaveChanges();
return Request.CreateResponse(HttpStatusCode.Created, newOrder);
}
[HttpPut]
public HttpResponseMessage UpdateOrder(FormDataCollection form) {
var key = Convert.ToInt32(form.Get("key"));
var values = form.Get("values");
var order = _nwind.Orders.First(o => o.OrderID == key);
JsonConvert.PopulateObject(values, order);
Validate(order);
if(!ModelState.IsValid)
return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState.GetFullErrorMessage());
_nwind.SaveChanges();
return Request.CreateResponse(HttpStatusCode.OK, order);
}
[HttpDelete]
public void DeleteOrder(FormDataCollection form) {
var key = Convert.ToInt32(form.Get("key"));
var order = _nwind.Orders.First(o => o.OrderID == key);
_nwind.Orders.Remove(order);
_nwind.SaveChanges();
}
// additional actions
[HttpGet]
public HttpResponseMessage OrderDetails(int orderID, DataSourceLoadOptions loadOptions) {
return Request.CreateResponse(DataSourceLoader.Load(
from i in _nwind.Order_Details
where i.OrderID == orderID
select new {
Product = i.Product.ProductName,
Price = i.UnitPrice,
i.Quantity,
Sum = i.UnitPrice * i.Quantity
},
loadOptions
));
}
[HttpGet]
public HttpResponseMessage ShippersLookup(DataSourceLoadOptions loadOptions) {
var lookup = from i in _nwind.Shippers
orderby i.CompanyName
select new {
Value = i.ShipperID,
Text = i.CompanyName
};
return Request.CreateResponse(DataSourceLoader.Load(lookup, loadOptions));
}
[HttpGet]
public HttpResponseMessage CustomersLookup(DataSourceLoadOptions loadOptions) {
var lookup = from i in _nwind.Customers
let text = i.CompanyName + " (" + i.Country + ")"
orderby i.CompanyName
select new {
Value = i.CustomerID,
Text = text
};
return Request.CreateResponse(DataSourceLoader.Load(lookup, loadOptions));
}
}
}
using System;
using System.Collections.Generic;
using System.Data.Entity;
namespace DevExtreme.MVC.Demos.Models.Northwind {
public class InMemoryNorthwindContext : InMemoryDataContext<Order> {
readonly NorthwindContext _nwind = new NorthwindContext();
public DbSet<Customer> Customers => _nwind.Customers;
public DbSet<Order_Detail> Order_Details => _nwind.Order_Details;
public ICollection<Order> Orders => ItemsInternal;
public DbSet<Shipper> Shippers => _nwind.Shippers;
protected override IEnumerable<Order> Source => _nwind.Orders;
protected override int GetKey(Order item) => item.OrderID;
protected override void SetKey(Order item, int key) => item.OrderID = key;
}
}