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
SASS

LESS
- Default
- Bootstrap
- Material
- Launch Theme Builder
- 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:

API REFERENCE

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\" /\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

Description

Support & Learning Resources

Was this demo helpful?

Tell us how we can improve this demo