If you have technical questions, please create a support ticket in the DevExpress Support Center.
import React, {
useCallback, useEffect, useMemo, useReducer,
} from 'react';
import DataGrid, {
Column, DataGridTypes, Editing, Pager,
} from 'devextreme-react/data-grid';
import { LoadPanel } from 'devextreme-react/load-panel';
import 'whatwg-fetch';
import reducer, { State } from './reducer.ts';
import {
saveChange, loadOrders, setChanges, setEditRowKey,
} from './actions.ts';
const initialState: State = {
data: [],
changes: [],
editRowKey: null,
isLoading: false,
};
const loadPanelPosition = { of: '#gridContainer' };
const App = () => {
const [state, dispatch] = useReducer(reducer, initialState);
const changesText = useMemo(() => JSON.stringify(state.changes.map((change) => ({
type: change.type,
key: change.type !== 'insert' ? change.key : undefined,
data: change.data,
})), null, ' '), [state.changes]);
useEffect(() => {
loadOrders(dispatch);
}, []);
const onSaving = useCallback((e: DataGridTypes.SavingEvent) => {
e.cancel = true;
e.promise = saveChange(dispatch, e.changes[0]);
}, []);
const onChangesChange = useCallback((changes: DataGridTypes.DataChange[]) => {
setChanges(dispatch, changes);
}, []);
const onEditRowKeyChange = useCallback((editRowKey) => {
setEditRowKey(dispatch, editRowKey);
}, []);
return (
<React.Fragment>
<LoadPanel
position={loadPanelPosition}
visible={state.isLoading}
/>
<DataGrid
id="gridContainer"
keyExpr="OrderID"
dataSource={state.data}
showBorders
repaintChangesOnly
onSaving={onSaving}>
<Editing
mode="row"
allowAdding
allowDeleting
allowUpdating
changes={state.changes}
onChangesChange={onChangesChange}
editRowKey={state.editRowKey}
onEditRowKeyChange={onEditRowKeyChange}
/>
<Pager visible={true} />
<Column dataField="OrderID" allowEditing={false}></Column>
<Column dataField="ShipName"></Column>
<Column dataField="ShipCountry"></Column>
<Column dataField="ShipCity"></Column>
<Column dataField="ShipAddress"></Column>
<Column dataField="OrderDate" dataType="date"></Column>
<Column dataField="Freight"></Column>
</DataGrid>
<div className="options">
<div className="caption">Options</div>
<div className="option">
<span>Edit Row Key:</span>
<div id="editRowKey">{state.editRowKey === null ? 'null' : state.editRowKey.toString()}</div>
</div>
<div className="option">
<span>Changes:</span>
<div id="changes">{changesText}</div>
</div>
</div>
</React.Fragment>
);
};
export default App;
xxxxxxxxxx
import React, {
useCallback, useEffect, useMemo, useReducer,
} from 'react';
import DataGrid, { Column, Editing, Pager } from 'devextreme-react/data-grid';
import { LoadPanel } from 'devextreme-react/load-panel';
import 'whatwg-fetch';
import reducer from './reducer.js';
import {
saveChange, loadOrders, setChanges, setEditRowKey,
} from './actions.js';
const initialState = {
data: [],
changes: [],
editRowKey: null,
isLoading: false,
};
const loadPanelPosition = { of: '#gridContainer' };
const App = () => {
const [state, dispatch] = useReducer(reducer, initialState);
const changesText = useMemo(
() =>
JSON.stringify(
state.changes.map((change) => ({
type: change.type,
key: change.type !== 'insert' ? change.key : undefined,
data: change.data,
})),
null,
' ',
),
[state.changes],
);
useEffect(() => {
loadOrders(dispatch);
}, []);
const onSaving = useCallback((e) => {
e.cancel = true;
e.promise = saveChange(dispatch, e.changes[0]);
}, []);
const onChangesChange = useCallback((changes) => {
setChanges(dispatch, changes);
}, []);
const onEditRowKeyChange = useCallback((editRowKey) => {
setEditRowKey(dispatch, editRowKey);
}, []);
return (
<React.Fragment>
<LoadPanel
position={loadPanelPosition}
visible={state.isLoading}
/>
<DataGrid
id="gridContainer"
keyExpr="OrderID"
dataSource={state.data}
showBorders
repaintChangesOnly
onSaving={onSaving}
>
<Editing
mode="row"
allowAdding
allowDeleting
allowUpdating
changes={state.changes}
onChangesChange={onChangesChange}
editRowKey={state.editRowKey}
onEditRowKeyChange={onEditRowKeyChange}
/>
<Pager visible={true} />
<Column
dataField="OrderID"
allowEditing={false}
></Column>
<Column dataField="ShipName"></Column>
<Column dataField="ShipCountry"></Column>
<Column dataField="ShipCity"></Column>
<Column dataField="ShipAddress"></Column>
<Column
dataField="OrderDate"
dataType="date"
></Column>
<Column dataField="Freight"></Column>
</DataGrid>
<div className="options">
<div className="caption">Options</div>
<div className="option">
<span>Edit Row Key:</span>
<div id="editRowKey">
{state.editRowKey === null ? 'null' : state.editRowKey.toString()}
</div>
</div>
<div className="option">
<span>Changes:</span>
<div id="changes">{changesText}</div>
</div>
</div>
</React.Fragment>
);
};
export default App;
xxxxxxxxxx
import React from 'react';
import ReactDOM from 'react-dom';
import App from './App.tsx';
ReactDOM.render(
<App />,
document.getElementById('app'),
);
xxxxxxxxxx
import React from 'react';
import { sendRequest } from './utils.ts';
const URL = 'https://js.devexpress.com/Demos/Mvc/api/DataGridWebApi';
export const FETCH_PENDING = 'FETCH_PENDING';
export const FETCH_SUCCESS = 'FETCH_SUCCESS';
export const FETCH_ERROR = 'FETCH_ERROR';
export const SAVING_PENDING = 'SAVING_PENDING';
export const SAVING_SUCCESS = 'SAVING_SUCCESS';
export const SAVING_ERROR = 'SAVING_ERROR';
export const SAVING_CANCEL = 'SAVING_CANCEL';
export const SET_CHANGES = 'SET_CHANGES';
export const SET_EDIT_ROW_KEY = 'SET_EDIT_ROW_KEY';
type dispatchType = React.Dispatch<{ type: any, payload?: any }>;
export async function loadOrders(dispatch: dispatchType) {
dispatch({ type: FETCH_PENDING });
try {
const { data } = await sendRequest(`${URL}/Orders?skip=700`);
dispatch({
type: FETCH_SUCCESS,
payload: {
data,
},
});
} catch (err) {
dispatch({ type: FETCH_ERROR });
throw err;
}
}
export async function saveChange(dispatch: dispatchType, change: { type: any; data: any; key: any; }) {
if (change && change.type) {
let data;
dispatch({ type: SAVING_PENDING });
try {
data = await sendChange(URL, change);
change.data = data;
dispatch({
type: SAVING_SUCCESS,
payload: {
change,
},
});
return data;
} catch (err) {
dispatch({ type: SAVING_ERROR });
throw err;
}
} else {
dispatch({ type: SAVING_CANCEL });
return null;
}
}
async function sendChange(url: string, change: { type: any; data: any; key: any; }) {
switch (change.type) {
case 'insert':
return sendRequest(`${url}/InsertOrder`, 'POST', {
values: JSON.stringify(change.data),
});
case 'update':
return sendRequest(`${url}/UpdateOrder`, 'PUT', {
key: change.key,
values: JSON.stringify(change.data),
});
case 'remove':
return sendRequest(`${url}/DeleteOrder`, 'DELETE', { key: change.key });
default:
return null;
}
}
export function setChanges(dispatch: dispatchType, changes) {
dispatch({
type: SET_CHANGES,
payload: changes,
});
}
export function setEditRowKey(dispatch: dispatchType, editRowKey) {
dispatch({
type: SET_EDIT_ROW_KEY,
payload: editRowKey,
});
}
xxxxxxxxxx
import applyChanges from 'devextreme/data/apply_changes';
import { DataGridTypes } from 'devextreme-react/data-grid';
import {
FETCH_PENDING,
FETCH_SUCCESS,
FETCH_ERROR,
SAVING_PENDING,
SAVING_SUCCESS,
SAVING_ERROR,
SAVING_CANCEL,
SET_CHANGES,
SET_EDIT_ROW_KEY,
} from './actions.ts';
export interface State {
data: any[];
editRowKey: any;
changes: DataGridTypes.DataChange[];
isLoading: boolean;
}
export default function reducer(state: State, { type, payload }) {
let newData;
switch (type) {
case SAVING_SUCCESS:
newData = applyChanges(state.data, [payload.change], { keyExpr: 'OrderID' });
return {
state,
data: newData,
changes: [],
editRowKey: null,
isLoading: false,
};
case SAVING_CANCEL:
return {
state,
changes: [],
editRowKey: null,
};
case SET_CHANGES:
return {
state,
changes: payload,
};
case SET_EDIT_ROW_KEY:
return {
state,
editRowKey: payload,
};
case FETCH_SUCCESS:
return {
state,
payload,
isLoading: false,
};
case FETCH_PENDING:
case SAVING_PENDING:
return {
state,
isLoading: true,
};
case FETCH_ERROR:
case SAVING_ERROR:
return {
state,
isLoading: false,
};
default:
return state;
}
}
xxxxxxxxxx
export async function sendRequest(url: string, method = 'GET', data = {}) {
const params = Object.keys(data)
.map((key) => `${encodeURIComponent(key)}=${encodeURIComponent(data[key])}`)
.join('&');
const result = await fetch(url, {
method,
body: params || null,
headers:
method === 'GET'
? {}
: {
'Content-Type': 'application/x-www-form-urlencoded;charset=UTF-8',
},
credentials: 'include',
});
if (result.ok) {
const text = await result.text();
return text && JSON.parse(text);
}
const json = await result.json();
throw json.Message;
}
xxxxxxxxxx
window.exports = window.exports || {};
window.config = {
transpiler: 'ts',
typescriptOptions: {
module: 'system',
emitDecoratorMetadata: true,
experimentalDecorators: true,
jsx: 'react',
},
meta: {
'react': {
'esModule': true,
},
'typescript': {
'exports': 'ts',
},
'devextreme/time_zone_utils.js': {
'esModule': true,
},
'devextreme/localization.js': {
'esModule': true,
},
'devextreme/viz/palette.js': {
'esModule': true,
},
'openai': {
'esModule': true,
},
},
paths: {
'npm:': 'https://unpkg.com/',
'bundles:': 'bundles/',
'externals:': 'bundles/externals/',
},
defaultExtension: 'js',
map: {
'ts': 'npm:plugin-typescript@8.0.0/lib/plugin.js',
'typescript': 'npm:typescript@4.2.4/lib/typescript.js',
'jszip': 'npm:jszip@3.10.1/dist/jszip.min.js',
'react': 'npm:react@17.0.2/umd/react.development.js',
'react-dom': 'npm:react-dom@17.0.2/umd/react-dom.development.js',
'prop-types': 'npm:prop-types/prop-types.js',
'whatwg-fetch': 'npm:whatwg-fetch@2.0.4/fetch.js',
'rrule': 'npm:rrule@2.6.4/dist/es5/rrule.js',
'luxon': 'npm:luxon@3.4.4/build/global/luxon.min.js',
'es6-object-assign': 'npm:es6-object-assign',
'devextreme': 'npm:devextreme@link:../../packages/devextreme/artifacts/npm/devextreme/cjs',
'devextreme-react': 'npm:devextreme-react@link:../../packages/devextreme-react/npm/cjs',
'devextreme-quill': 'npm:devextreme-quill@1.7.1/dist/dx-quill.min.js',
'devexpress-diagram': 'npm:devexpress-diagram@2.2.5/dist/dx-diagram.js',
'devexpress-gantt': 'npm:devexpress-gantt@4.1.54/dist/dx-gantt.js',
'@devextreme/runtime': 'npm:@devextreme/runtime@3.0.12',
'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/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',
'devextreme-cldr-data': 'npm:devextreme-cldr-data@1.0.3',
// SystemJS plugins
'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.8/standalone.js',
'prettier/parser-html': 'npm:prettier@2.8.8/parser-html.js',
},
packages: {
'devextreme': {
defaultExtension: 'js',
},
'devextreme-react': {
main: 'index.js',
},
'devextreme/events/utils': {
main: 'index',
},
'devextreme/localization/messages': {
format: 'json',
defaultExtension: 'json',
},
'devextreme/events': {
main: 'index',
},
'es6-object-assign': {
main: './index.js',
defaultExtension: 'js',
},
},
packageConfigPaths: [
'npm:@devextreme/*/package.json',
'npm:@devextreme/runtime@3.0.12/inferno/package.json',
],
babelOptions: {
sourceMaps: false,
stage0: true,
react: true,
},
};
System.config(window.config);
xxxxxxxxxx
import { sendRequest } from './utils.js';
const URL = 'https://js.devexpress.com/Demos/Mvc/api/DataGridWebApi';
export const FETCH_PENDING = 'FETCH_PENDING';
export const FETCH_SUCCESS = 'FETCH_SUCCESS';
export const FETCH_ERROR = 'FETCH_ERROR';
export const SAVING_PENDING = 'SAVING_PENDING';
export const SAVING_SUCCESS = 'SAVING_SUCCESS';
export const SAVING_ERROR = 'SAVING_ERROR';
export const SAVING_CANCEL = 'SAVING_CANCEL';
export const SET_CHANGES = 'SET_CHANGES';
export const SET_EDIT_ROW_KEY = 'SET_EDIT_ROW_KEY';
export async function loadOrders(dispatch) {
dispatch({ type: FETCH_PENDING });
try {
const { data } = await sendRequest(`${URL}/Orders?skip=700`);
dispatch({
type: FETCH_SUCCESS,
payload: {
data,
},
});
} catch (err) {
dispatch({ type: FETCH_ERROR });
throw err;
}
}
export async function saveChange(dispatch, change) {
if (change && change.type) {
let data;
dispatch({ type: SAVING_PENDING });
try {
data = await sendChange(URL, change);
change.data = data;
dispatch({
type: SAVING_SUCCESS,
payload: {
change,
},
});
return data;
} catch (err) {
dispatch({ type: SAVING_ERROR });
throw err;
}
} else {
dispatch({ type: SAVING_CANCEL });
return null;
}
}
async function sendChange(url, change) {
switch (change.type) {
case 'insert':
return sendRequest(`${url}/InsertOrder`, 'POST', {
values: JSON.stringify(change.data),
});
case 'update':
return sendRequest(`${url}/UpdateOrder`, 'PUT', {
key: change.key,
values: JSON.stringify(change.data),
});
case 'remove':
return sendRequest(`${url}/DeleteOrder`, 'DELETE', { key: change.key });
default:
return null;
}
}
export function setChanges(dispatch, changes) {
dispatch({
type: SET_CHANGES,
payload: changes,
});
}
export function setEditRowKey(dispatch, editRowKey) {
dispatch({
type: SET_EDIT_ROW_KEY,
payload: editRowKey,
});
}
xxxxxxxxxx
import applyChanges from 'devextreme/data/apply_changes';
import {
FETCH_PENDING,
FETCH_SUCCESS,
FETCH_ERROR,
SAVING_PENDING,
SAVING_SUCCESS,
SAVING_ERROR,
SAVING_CANCEL,
SET_CHANGES,
SET_EDIT_ROW_KEY,
} from './actions.js';
export default function reducer(state, { type, payload }) {
let newData;
switch (type) {
case SAVING_SUCCESS:
newData = applyChanges(state.data, [payload.change], { keyExpr: 'OrderID' });
return {
state,
data: newData,
changes: [],
editRowKey: null,
isLoading: false,
};
case SAVING_CANCEL:
return {
state,
changes: [],
editRowKey: null,
};
case SET_CHANGES:
return {
state,
changes: payload,
};
case SET_EDIT_ROW_KEY:
return {
state,
editRowKey: payload,
};
case FETCH_SUCCESS:
return {
state,
payload,
isLoading: false,
};
case FETCH_PENDING:
case SAVING_PENDING:
return {
state,
isLoading: true,
};
case FETCH_ERROR:
case SAVING_ERROR:
return {
state,
isLoading: false,
};
default:
return state;
}
}
xxxxxxxxxx
export async function sendRequest(url, method = 'GET', data = {}) {
const params = Object.keys(data)
.map((key) => `${encodeURIComponent(key)}=${encodeURIComponent(data[key])}`)
.join('&');
const result = await fetch(url, {
method,
body: params || null,
headers:
method === 'GET'
? {}
: {
'Content-Type': 'application/x-www-form-urlencoded;charset=UTF-8',
},
credentials: 'include',
});
if (result.ok) {
const text = await result.text();
return text && JSON.parse(text);
}
const json = await result.json();
throw json.Message;
}
xxxxxxxxxx
import React from 'react';
import ReactDOM from 'react-dom';
import App from './App.js';
ReactDOM.render(<App />, document.getElementById('app'));
xxxxxxxxxx
<html lang="en">
<head></head>
<body class="dx-viewport">
<div class="demo-container">
<div id="app"></div>
</div>
</body>
</html>
xxxxxxxxxx
#gridContainer {
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;
margin-right: 14px;
}
.option > div {
display: inline-block;
font-weight: bold;
}
Component Properties
-
editing.editRowKey
The key for the row being edited. -
editing.editColumnName
The name or data field of the column being edited. -
editing.changes
Pending row changes.
Bind these properties to state props and set the props to change edit state at runtime. In this demo, we bind the editRowKey and changes properties and use the corresponding on_OptionName_Change event handlers to set the bound props.
Utility Method
- DevExpress.data.applyChanges(data, changes, options)
Applies an array of changes to a source data array.
Event Handlers
-
onSaving / onSaved
Functions that are called before / after pending row changes are saved via the UI or programmatically. -
onEditCanceling / onEditCanceled
Functions that are called before / after editing is canceled and pending row changes are discarded.
Use these functions to perform custom actions. In this demo, the onSaving function sends pending changes to a server. The function's parameter e
contains fields for this capability. To implement the same in your application, follow these steps:
-
Disable built-in edit state management
Set thee.cancel
field to true. -
Send a request to the server
Pending changes are stored in thee.changes
array. This array has only a single element in all edit modes, except for batch. Check if this element is not empty and send it to the server (see thesaveChange
action inactions.js
). -
Apply the same changes to the DataGrid's data source and reset edit state
If the server successfully saves changes, call the applyChanges method to save the same changes in the DataGrid's data source. Assign null to the editRowKey and an empty array to the changes property. This resets edit state (see theSAVING_SUCCESS
handler inreducer.js
).