Your search did not match any results.
Data Grid

Real-Time Updates

The DataGrid component is optimized for real-time updates. You should bind it to a DataSource that contains a store and use the push(changes) method to update the store's data. The rows with changed data are rerendered (see the DataGrid's repaintChangesOnly property). The DataSource object also provides properties that control its behavior when it receives a push. For example, reshapeOnPush is set to true in this demo to allow summaries to be recalculated.

Grids in the detail sections are updated in real time as well. All the grids share the same ordersStore that receives pushes, but it is filtered to show only a specific product's orders for each grid.

Backend API
Copy to CodeSandBox
Apply
Reset
<template> <div> <DxDataGrid :ref="dataGridRefName" :data-source="productsDataSource" :repaint-changes-only="true" :two-way-binding-enabled="false" :column-auto-width="true" :show-borders="true" > <DxPaging :page-size="10"/> <DxColumn data-field="ProductName" data-type="string" /> <DxColumn data-field="UnitPrice" data-type="number" format="currency" /> <DxColumn data-field="OrderCount" data-type="number" /> <DxColumn data-field="Quantity" data-type="number" /> <DxColumn data-field="Amount" data-type="number" format="currency" /> <DxSummary> <DxTotalItem column="ProductName" summary-type="count" /> <DxTotalItem column="Amount" summary-type="sum" display-format="{0}" value-format="currency" /> <DxTotalItem column="OrderCount" summary-type="sum" display-format="{0}" /> </DxSummary> <DxMasterDetail :enabled="true" template="productDetail" /> <template #productDetail="{ data: detail }"> <DxDataGrid :data-source="getDetailGridDataSource(detail.data)" :column-auto-width="true" :repaint-changes-only="true" :two-way-binding-enabled="false" :show-borders="true" > <DxPaging :page-size="5"/> <DxColumn data-field="OrderID" data-type="number" /> <DxColumn data-field="ShipCity" data-type="string" /> <DxColumn data-field="OrderDate" data-type="datetime" format="yyyy/MM/dd HH:mm:ss" /> <DxColumn data-field="UnitPrice" data-type="number" format="currency" /> <DxColumn data-field="Quantity" data-type="number" /> <DxColumn :allow-sorting="true" :calculate-cell-value="getAmount" caption="Amount" format="currency" data-type="number" /> <DxSummary> <DxTotalItem column="OrderID" summary-type="count" /> <DxTotalItem column="Quantity" summary-type="sum" display-format="{0}" /> <DxTotalItem column="Amount" summary-type="sum" display-format="{0}" value-format="currency" /> </DxSummary> </DxDataGrid> </template> </DxDataGrid> <div class="options"> <div class="caption">Options</div> <div class="option"> <span>Update frequency:</span> <DxSlider :min="10" :step="10" :max="5000" v-model:value="updatesPerSecond" > <DxTooltip :enabled="true" format="#0 per second" show-mode="always" position="top" /> </DxSlider> </div> </div> </div> </template> <script> import { DxDataGrid, DxColumn, DxSummary, DxTotalItem, DxMasterDetail, DxPaging, } from 'devextreme-vue/data-grid'; import { DxSlider, DxTooltip } from 'devextreme-vue/slider'; import { productsStore, ordersStore, getOrderCount, addOrder, } from './data.js'; export default { components: { DxDataGrid, DxColumn, DxSummary, DxTotalItem, DxMasterDetail, DxPaging, DxSlider, DxTooltip, }, data() { return { updatesPerSecond: 100, dataGridRefName: 'dataGrid', productsDataSource: { store: productsStore, reshapeOnPush: true, }, }; }, created() { setInterval(() => { if (getOrderCount() > 500000) { return; } for (let i = 0; i < this.updatesPerSecond / 20; i += 1) { addOrder(); } }, 50); }, methods: { getDetailGridDataSource(product) { return { store: ordersStore, reshapeOnPush: true, filter: ['ProductID', '=', product.ProductID], }; }, getAmount(order) { return order.UnitPrice * order.Quantity; }, }, }; </script> <style scoped> .options { padding: 20px; margin-top: 20px; background-color: rgba(191, 191, 191, 0.15); } .caption { font-size: 18px; font-weight: 500; } .option { margin-top: 10px; display: flex; align-items: center; } .option > span { position: relative; top: 2px; margin-right: 10px; } .option > .dx-widget { width: 500px; display: inline-block; vertical-align: middle; } </style>
import { createApp } from 'vue'; import App from './App.vue'; createApp(App).mount('#app');
<!DOCTYPE html> <html> <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" /> <link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/22.2.6/css/dx.light.css" /> <script src="https://unpkg.com/core-js@2.6.12/client/shim.min.js"></script> <script src="https://unpkg.com/systemjs@0.21.3/dist/system.js"></script> <script type="text/javascript" src="config.js"></script> <script type="text/javascript"> System.import("./index.js"); </script> </head> <body class="dx-viewport"> <div class="demo-container"> <div id="app"> </div> </div> </body> </html>
import ArrayStore from 'devextreme/data/array_store'; const cities = ['Los Angeles', 'Denver', 'Bentonville', 'Atlanta', 'Reno', 'Beaver', 'Malibu', 'Phoenix', 'San Diego', 'Little Rock', 'Pasadena', 'Boise', 'San Jose', 'Chatsworth', 'San Fernando', 'South Pasadena', 'San Fernando Valley', 'La Canada', 'St. Louis']; const orders = []; const products = []; for (let i = 1; i <= 100; i += 1) { products.push({ ProductID: i, ProductName: `Product ${i}`, UnitPrice: Math.floor(Math.random() * 1000) + 1, Quantity: 0, Amount: 0, OrderCount: 0, }); } export const productsStore = new ArrayStore({ key: 'ProductID', data: products, }); export const ordersStore = new ArrayStore({ key: 'OrderID', data: orders, }); export function getOrderCount() { return orders.length; } export function addOrder() { const product = products[Math.round(Math.random() * 99)]; const order = { OrderID: orders.length ? orders[orders.length - 1].OrderID + 1 : 20001, ShipCity: cities[Math.round(Math.random() * (cities.length - 1))], ProductID: product.ProductID, UnitPrice: product.UnitPrice, OrderDate: new Date(), Quantity: Math.round(Math.random() * 20) + 1, }; ordersStore.push([{ type: 'insert', data: order }]); productsStore.push([{ type: 'update', key: order.ProductID, data: { OrderCount: product.OrderCount + 1, Quantity: product.Quantity + order.Quantity, Amount: product.Amount + order.UnitPrice * order.Quantity, }, }]); }
window.config = { transpiler: 'plugin-babel', meta: { '*.vue': { loader: 'vue-loader', }, 'devextreme/localization.js': { 'esModule': true, }, }, paths: { 'npm:': 'https://unpkg.com/', }, map: { 'vue': 'npm:vue@3.2.47/dist/vue.esm-browser.js', 'vue-loader': 'npm:dx-systemjs-vue-browser@1.0.15/index.js', 'mitt': 'npm:mitt/dist/mitt.umd.js', 'rrule': 'npm:rrule@2.6.4/dist/es5/rrule.js', 'luxon': 'npm:luxon@1.28.0/build/global/luxon.min.js', 'es6-object-assign': 'npm:es6-object-assign@1.1.0', 'devextreme': 'npm:devextreme@22.2.6/cjs', 'devextreme-vue': 'npm:devextreme-vue@22.2.6', 'jszip': 'npm:jszip@3.7.1/dist/jszip.min.js', 'devextreme-quill': 'npm:devextreme-quill@1.5.20/dist/dx-quill.min.js', 'devexpress-diagram': 'npm:devexpress-diagram@2.1.72/dist/dx-diagram.js', 'devexpress-gantt': 'npm:devexpress-gantt@4.1.43/dist/dx-gantt.js', '@devextreme/runtime': 'npm:@devextreme/runtime@3.0.11', 'inferno': 'npm:inferno@7.4.11/dist/inferno.min.js', 'inferno-compat': 'npm:inferno-compat/dist/inferno-compat.min.js', 'inferno-create-element': 'npm:inferno-create-element@7.4.11/dist/inferno-create-element.min.js', 'inferno-dom': 'npm:inferno-dom/dist/inferno-dom.min.js', 'inferno-hydrate': 'npm:inferno-hydrate@7.4.11/dist/inferno-hydrate.min.js', 'inferno-clone-vnode': 'npm:inferno-clone-vnode/dist/inferno-clone-vnode.min.js', 'inferno-create-class': 'npm:inferno-create-class/dist/inferno-create-class.min.js', 'inferno-extras': 'npm:inferno-extras/dist/inferno-extras.min.js', 'plugin-babel': 'npm:systemjs-plugin-babel@0.0.25/plugin-babel.js', 'systemjs-babel-build': 'npm:systemjs-plugin-babel@0.0.25/systemjs-babel-browser.js', // Prettier 'prettier/standalone': 'npm:prettier@2.8.4/standalone.js', 'prettier/parser-html': 'npm:prettier@2.8.4/parser-html.js', }, packages: { 'devextreme-vue': { main: 'index.js', }, 'devextreme': { defaultExtension: 'js', }, 'devextreme/events/utils': { main: 'index', }, 'devextreme/events': { main: 'index', }, 'es6-object-assign': { main: './index.js', defaultExtension: 'js', }, }, packageConfigPaths: [ 'npm:@devextreme/*/package.json', 'npm:@devextreme/runtime@3.0.11/inferno/package.json', ], babelOptions: { sourceMaps: false, stage0: true, }, }; System.config(window.config);