New to Telerik UI for ASP.NET MVC? Download free 30-day trial

ASP.NET MVC Grid Custom Data Source

Loading Demo...

EXAMPLE
VIEW SOURCE
Change Theme
default
Default Theme

Main

Main Dark

Nordic

Ocean Blue

Ocean Blue A11Y

Purple

Turquoise
Bootstrap Theme

Main

Bootstrap 3

Bootstrap 3 Dark

Main Dark

Nordic

Turquoise

Turquoise Dark

Urban

Vintage
Material Theme

Main

Arctic

Lime Dark

Main Dark

Material 2

Material 2 Dark

Nova
Classic Theme

Main

Green

Green Dark

Lavender

Lavender Dark

Main Dark

Metro

Metro Dark

Moonlight

Opal

Opal Dark

Silver

Silver Dark

Uniform
Fluent Theme

Main
Launch Theme Builder

                        custom_datasource.cshtml
                    
                        Custom_DataSourceController.cs

Also available for:

CLIENT-SIDE API SERVER-SIDE API

(typeof KendoLicensing === 'object' && KendoLicensing.setScriptKey(''));kendo.syncReady(function(){jQuery("#Grid").kendoGrid({"columns":[{"title":"Product name","headerAttributes":{"data-field":"ProductName","data-title":"Product name","aria-haspopup":"menu"},"field":"ProductName","encoded":true,"editor":"\u003cinput data-val=\"true\" data-val-remote=\"\u0026#39;Product name\u0026#39; is invalid.\" data-val-remote-additionalfields=\"*.ProductName\" data-val-remote-url=\"/aspnet-mvc/grid/isproductname_available\" data-val-required=\"The Product name field is required.\" id=\"ProductName\" name=\"ProductName\" title=\"ProductName\" /\u003e\u003cscript\u003e\r\n\tkendo.syncReady(function(){jQuery(\"#ProductName\").kendoTextBox({});});\r\n\u003c/script\u003e\u003cspan class=\"field-validation-valid\" data-valmsg-for=\"ProductName\" data-valmsg-replace=\"true\"\u003e\u003c/span\u003e"},{"title":"Unit price","headerAttributes":{"data-field":"UnitPrice","data-title":"Unit price","aria-haspopup":"menu"},"width":"140px","field":"UnitPrice","format":"{0:C}","encoded":true,"editor":"\u003cinput data-val=\"true\" data-val-number=\"The field Unit price must be a number.\" data-val-range=\"The field Unit price must be between 0 and 2147483647.\" data-val-range-max=\"2147483647\" data-val-range-min=\"0\" data-val-required=\"The Unit price field is required.\" id=\"UnitPrice\" name=\"UnitPrice\" style=\"width:100%\" type=\"text\" value=\"0\" /\u003e\u003cscript\u003e\r\n\tkendo.syncReady(function(){jQuery(\"#UnitPrice\").kendoNumericTextBox({\"enable\":true,\"min\":0,\"max\":2147483647,\"format\":\"c\"});});\r\n\u003c/script\u003e\u003cspan class=\"field-validation-valid\" data-valmsg-for=\"UnitPrice\" data-valmsg-replace=\"true\"\u003e\u003c/span\u003e"},{"title":"Units in stock","headerAttributes":{"data-field":"UnitsInStock","data-title":"Units in stock","aria-haspopup":"menu"},"width":"140px","field":"UnitsInStock","encoded":true,"editor":"\u003cinput data-val=\"true\" data-val-number=\"The field Units in stock must be a number.\" data-val-range=\"The field Units in stock must be between 0 and 2147483647.\" data-val-range-max=\"2147483647\" data-val-range-min=\"0\" data-val-required=\"The Units in stock field is required.\" id=\"UnitsInStock\" name=\"UnitsInStock\" style=\"width:100%\" type=\"text\" value=\"0\" /\u003e\u003cscript\u003e\r\n\tkendo.syncReady(function(){jQuery(\"#UnitsInStock\").kendoNumericTextBox({\"enable\":true,\"min\":-2147483648,\"max\":2147483647,\"format\":\"n0\",\"decimals\":0});});\r\n\u003c/script\u003e\u003cspan class=\"field-validation-valid\" data-valmsg-for=\"UnitsInStock\" data-valmsg-replace=\"true\"\u003e\u003c/span\u003e"},{"title":"Discontinued","headerAttributes":{"data-field":"Discontinued","data-title":"Discontinued","aria-haspopup":"menu"},"width":"100px","field":"Discontinued","encoded":true,"editor":"\u003cinput data-role=\"checkbox\" id=\"Discontinued\" name=\"Discontinued\" type=\"checkbox\" value=\"true\"\u003e\u003c/input\u003e\u003cinput name=\"Discontinued\" type=\"hidden\" value=\"false\"\u003e\u003c/input\u003e\u003cscript\u003e\r\n\tkendo.syncReady(function(){jQuery(\"#Discontinued\").kendoCheckBox({\"checked\":false});});\r\n\u003c/script\u003e\u003cspan class=\"field-validation-valid\" data-valmsg-for=\"Discontinued\" data-valmsg-replace=\"true\"\u003e\u003c/span\u003e"},{"headerAttributes":{"data-title":"\u0026nbsp;"},"width":"110px","command":[{"name":"destroy","buttonType":"ImageAndText","text":"Delete"}]}],"pageable":{"buttonCount":10},"sortable":{"mode":"single"},"scrollable":{"height":"200px"},"editable":{"confirmation":"Are you sure you want to delete this record?","confirmDelete":"Delete","cancelDelete":"Cancel","mode":"incell","readonly":false,"template":null,"create":true,"update":true,"destroy":true},"toolbar":{"items":[{"name":"create","buttonType":"ImageAndText","text":"Add"},{"name":"save","buttonType":"ImageAndText"},{"name":"cancel","buttonType":"ImageAndText"}]},"dataSource":{"transport":{"read":{"url":"https://demos.telerik.com/service/v2/core/Products","contentType":"application/json"},"update":{"url":"https://demos.telerik.com/service/v2/core/Products/Update","contentType":"application/json"},"create":{"url":"https://demos.telerik.com/service/v2/core/Products/Create","contentType":"application/json"},"destroy":{"url":"https://demos.telerik.com/service/v2/core/Products/Destroy","contentType":"application/json"},"parameterMap":parameterMap},"pageSize":20,"page":0,"groupPaging":false,"total":0,"schema":{"model":{"id":"ProductID","fields":{"ProductID":{"type":"number"},"ProductName":{"type":"string"},"UnitPrice":{"type":"number"},"UnitsInStock":{"type":"number"},"Discontinued":{"type":"boolean"},"LastSupply":{"type":"date"},"UnitsOnOrder":{"type":"number"},"Category":{"type":"object"},"CategoryID":{"type":"number","defaultValue":null},"QuantityPerUnit":{"type":"string"}}}},"batch":true},"navigatable":true,"height":"500px"});});

Description

The ASP.NET MVC DataGrid enables you to bypass the built-in data processing and handle operations such paging, sorting, filtering, and grouping yourself.

This demo shows how to bind the Data Grid to a custom data source when none of the built-in types are suitable. To make the connection to the remote endpoint and process the data properly, the data source requires information about the web service URLs, the request type, the response data type, and the structure (schema) of the response.

For more information about the data-binding capabilities, refer to the official Telerik UI for ASP.NET MVC Data Grid product documentation on the available data-binding approaches.

Additional Apps

This Grid example is part of a unique collection of hundreds of ASP.NET MVC demos, with which you can see all Telerik ASP.NET MVC components and their features in action. View the source code of the demos from the library or directly adapt, and edit them and their theme appearance in the ThemeBuilder.

ASP.NET MVC Grid Custom Data Source

Description

Additional Apps

Support & Learning Resources

Additional Resources