Data Validation
Documentation
The DataGrid widget is able to validate data input within grid cells using predefined or custom validation rules. In this example, a validation rule is assigned to each column using its validationRules option. These rules do not allow an end user to enter invalid data into grid cells.
Feel free to share demo-related thoughts here.
If you have technical questions, please create a support ticket in the DevExpress Support Center.
Thank you!
We appreciate your feedback.
We appreciate your feedback.
$(function(){
$("#gridContainer").dxDataGrid({
dataSource: employees,
keyExpr: "ID",
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" }]
}
]
});
});
<!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.4.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/19.1.5/css/dx.common.css" />
<link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/19.1.5/css/dx.light.css" />
<script src="https://cdn3.devexpress.com/jslib/19.1.5/js/dx.all.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>
var employees = [{
"ID": 1,
"FirstName": "John",
"LastName": "Heart",
"Phone": "(213) 555-9392",
"Position": "CEO",
"Email": "jheart@dx-email.com",
"Address": "351 S Hill St."
}, {
"ID": 2,
"FirstName": "Olivia",
"LastName": "Peyton",
"Phone": "(310) 555-2728",
"Position": "Sales Assistant",
"Email": "oliviap@dx-email.com",
"Address": "807 W Paseo Del Mar"
}, {
"ID": 3,
"FirstName": "Robert",
"LastName": "Reagan",
"Phone": "(818) 555-2387",
"Position": "CMO",
"Email": "robertr@dx-email.com",
"Address": "4 Westmoreland Pl."
}, {
"ID": 4,
"FirstName": "Greta",
"LastName": "Sims",
"Phone": "(818) 555-6546",
"Position": "HR Manager",
"Email": "gretas@dx-email.com",
"Address": "1700 S Grandview Dr."
}, {
"ID": 5,
"FirstName": "Brett",
"LastName": "Wade",
"Phone": "(626) 555-0358",
"Position": "IT Manager",
"Email": "brettw@dx-email.com",
"Address": "1120 Old Mill Rd."
}, {
"ID": 6,
"FirstName": "Sandra",
"LastName": "Johnson",
"Phone": "(562) 555-2082",
"Position": "Controller",
"Email": "sandraj@dx-email.com",
"Address": "4600 N Virginia Rd."
}, {
"ID": 7,
"FirstName": "Kevin",
"LastName": "Carter",
"Phone": "(213) 555-2840",
"Position": "Shipping Manager",
"Email": "kevinc@dx-email.com",
"Address": "424 N Main St."
}, {
"ID": 8,
"FirstName": "Cynthia",
"LastName": "Stanwick",
"Phone": "(818) 555-6655",
"Position": "HR Assistant",
"Email": "cindys@dx-email.com",
"Address": "2211 Bonita Dr."
}, {
"ID": 9,
"FirstName": "Kent",
"LastName": "Samuelson",
"Phone": "(562) 555-9282",
"Position": "Ombudsman",
"Email": "kents@dx-email.com",
"Address": "12100 Mora Dr"
}, {
"ID": 10,
"FirstName": "Taylor",
"LastName": "Riley",
"Phone": "(310) 555-7276",
"Position": "Network Admin",
"Email": "taylorr@dx-email.com",
"Address": "7776 Torreyson Dr"
}];