Help us shape the 2021 DevExtreme Roadmap. Take our 5 minute survey.
Dismiss
Free Trial Buy
    Your search did not match any results.
    Data Grid

    Data Validation

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

    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.

    See more Hide details
    Prev Demo Next Demo

    jQuery

    Angular

    Vue

    React

    AngularJS

    ASP.NET Core

    ASP.NET MVC

    Copy to CodePen
    Apply
    Reset
    $(function(){ const url = "https://js.devexpress.com/Demos/Mvc/api/DataGridEmployeesValidation"; $("#gridContainer").dxDataGrid({ dataSource: DevExpress.data.AspNet.createStore({ key: "ID", loadUrl: url, insertUrl: url, updateUrl: url, deleteUrl: url, onBeforeSend: function(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: function(params) { return $.ajax({ url: "https://js.devexpress.com/Demos/Mvc/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"> <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/20.2.4/css/dx.common.css" /> <link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/20.2.4/css/dx.light.css" /> <script src="https://cdn3.devexpress.com/jslib/20.2.4/js/dx.all.js"></script> <script src="https://unpkg.com/devextreme-aspnet-data@2.7.1/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>