JavaScript/jQuery Data Grid - Data Validation

The JavaScript DataGrid allows you to validate user input. You can apply pre-defined validation rules or custom rules to individual columns.

Backend API

$(() => { const url = 'https://js.devexpress.com/Demos/NetCore/api/DataGridEmployeesValidation'; $('#gridContainer').dxDataGrid({ dataSource: DevExpress.data.AspNet.createStore({ key: 'ID', loadUrl: url, insertUrl: url, updateUrl: url, deleteUrl: url, onBeforeSend(method, ajaxOptions) { ajaxOptions.xhrFields = { withCredentials: true }; }, }), repaintChangesOnly: true, columnAutoWidth: true, showBorders: true, paging: { enabled: false, }, editing: { mode: 'batch', allowUpdating: true, allowAdding: true, }, columns: [{ dataField: 'FirstName', validationRules: [{ type: 'required' }], }, { dataField: 'LastName', validationRules: [{ type: 'required' }], }, { dataField: 'Position', validationRules: [{ type: 'required' }], }, { dataField: 'Phone', validationRules: [{ type: 'required' }, { type: 'pattern', message: 'Your phone must have "(555) 555-5555" format!', pattern: /^$\d{3}$ \d{3}-\d{4}$/i, }], }, { dataField: 'Email', validationRules: [{ type: 'required', }, { type: 'email', }, { type: 'async', message: 'Email address is not unique', validationCallback(params) { return $.ajax({ url: 'https://js.devexpress.com/Demos/NetCore/RemoteValidation/CheckUniqueEmailAddress', type: 'POST', dataType: 'json', contentType: 'application/json', data: JSON.stringify({ id: params.data.ID, email: params.value, }), }); }, }], }, ], }); });

<!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml" 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" /> <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/25.1.6/css/dx.light.css" /> <script src="js/dx.all.js?v=25.1.6"></script> <script src="https://unpkg.com/devextreme-aspnet-data@5.0.0/js/dx.aspnet.data.js"></script> <script src="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="gridContainer"></div> </div> </body> </html>

In this demo, the following rules are used:

required
Specifies that cells should not be empty.
pattern
Specifies a pattern that cell values should match.
email
Specifies that cell values match the Email pattern.
async
Specifies custom validation parameters that are used to validate a value on the server.

For more information on these and other validation rules, refer to the following documentation section: Validation Rules.