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

ForeignKey column binding

Loading Demo...

EXAMPLE
VIEW SOURCE
Edit in Theme Builder
Change Theme
default
Themes & Swatches

SASS

LESS

Launch Theme Builder
Default Theme

Main

Main Dark

Nordic

Ocean Blue

Purple

Turquoise
Bootstrap Theme

Main

Main Dark

Nordic

Urban

Vintage
Material Theme

Main

Arctic

Lime Dark

Main Dark

Nova
Classic Theme

Main

Main Dark

Opal

Silver
- Black
- Blue Opal
- Bootstrap v3
- Default
- Fiori
- Flat
- High Contrast
- Material
- Material Black
- Metro
- Metro Black
- Moonlight
- Nova
- Office 365
- Silver
- Uniform

                        foreignkeycolumnbinding.cshtml
                    
                        ForeignKeyColumnBindingController.cs

Also available for:

CLIENT-SIDE API SERVER-SIDE API

Drag a column header and drop it here to group by that column

kendo.syncReady(function(){jQuery("#grid").kendoGrid({"columns":[{"title":"Product name","headerAttributes":{"data-field":"ProductName","data-title":"Product\u0026#32;name"},"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/validation/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":"Category","headerAttributes":{"data-field":"CategoryID","data-title":"Category"},"width":"200px","field":"CategoryID","encoded":true,"editor":null,"dataSource":{"transport":{"read":{"url":"/aspnet-mvc/grid/categories"}}},"dataValueField":"CategoryID","dataTextField":"CategoryName"},{"title":"Unit price","headerAttributes":{"data-field":"UnitPrice","data-title":"Unit\u0026#32;price"},"width":"200px","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"},{"width":"150px","command":[{"name":"destroy","buttonType":"ImageAndText","text":"Delete"}]}],"groupable":{"enabled":true},"pageable":{"buttonCount":10},"filterable":true,"scrollable":{"height":"200px"},"editable":{"confirmation":"Are you sure you want to delete this record?","confirmDelete":"Delete","cancelDelete":"Cancel","mode":"incell","template":null,"create":true,"update":true,"destroy":true},"toolbar":{"command":[{"name":null,"buttonType":"ImageAndText","text":"Add new record"}]},"dataSource":{"type":(function(){if(kendo.data.transports['aspnetmvc-ajax']){return 'aspnetmvc-ajax';} else{throw new Error('The kendo.aspnetmvc.min.js script is not included.');}})(),"transport":{"read":{"url":"/aspnet-mvc/grid/foreignkeycolumn_read"},"prefix":"","update":{"url":"/aspnet-mvc/grid/foreignkeycolumn_update"},"create":{"url":"/aspnet-mvc/grid/foreignkeycolumn_create"},"destroy":{"url":"/aspnet-mvc/grid/foreignkeycolumn_destroy"}},"pageSize":20,"page":1,"groupPaging":false,"total":0,"error":errorHandler,"schema":{"data":"Data","total":"Total","errors":"Errors","model":{"id":"ProductID","fields":{"ProductID":{"editable":false,"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":1},"QuantityPerUnit":{"type":"string"}}}}}});});

Description

In this demo we showcase how to implement foreign key column which fetches its values from a DataSource in the ASP.NET MVC Grid, hosting dropdown list editor for data editing.

ForeignKey column binding

Themes & Swatches

Description

Support & Learning Resources