Your search did not match any results.
Data Grid

OData Service


This example demonstrates how to configure the DataGrid widget to display remote data accessed using the OData protocol. Specify the data store type and remote data service URL, define data shaping options, and configure grid columns.

Copy to CodePen
$(function(){ $("#gridContainer").dxDataGrid({ showBorders: true, dataSource: { store: { type: "odata", url: "" }, select: [ "Product_ID", "Product_Name", "Product_Cost", "Product_Sale_Price", "Product_Retail_Price", "Product_Current_Inventory" ], filter: ["Product_Current_Inventory", ">", 0] }, columns: [ "Product_ID", { dataField: "Product_Name", width: 250 }, { caption: "Cost", dataField: "Product_Cost", dataType: "number", format: "currency" }, { dataField: "Product_Sale_Price", caption: "Sale Price", dataType: "number", format: "currency" }, { dataField: "Product_Retail_Price", caption: "Retail Price", dataType: "number", format: "currency" }, { dataField: "Product_Current_Inventory", caption: "Inventory" } ] }); });
<!DOCTYPE html> <html xmlns=""> <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=""></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="" /> <link rel="stylesheet" type="text/css" href="" /> <script src=""></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>