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

ASP.NET Core Grid ForeignKey Column Binding

Loading Demo...

EXAMPLE
VIEW SOURCE
Edit in Telerik REPL
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

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

HtmlHelper
TagHelper
Files:
                    foreignkeycolumnbinding.cshtml
                
                    ForeignKeyColumnControllerBinding.cs
                
                    ProductViewModel.cs
                
                    CategoryViewModel.cs
                
                    ForeignkeycolumnBinding_TagHelper.cshtml

Also available for:

CLIENT-SIDE API SERVER-SIDE API

kendo.syncReady(function(){jQuery("#grid").kendoGrid({"groupable":{"enabled":true},"columns":[{"title":"Product name","field":"ProductName","filterable":{"messages":{"title":"Show items with value that","buttonTitle":"{0} filter column settings"},"checkAll":false},"encoded":true,"editor":"\r\n\u003cinput data-val=\"true\" data-val-required=\"The Product name field is required.\" id=\"ProductName\" name=\"ProductName\" title=\"ProductName\" type=\"text\" value=\"\" /\u003e\u003cscript\u003ekendo.syncReady(function(){jQuery(\"#ProductName\").kendoTextBox({});});\u003c/script\u003e \u003cspan class=\"field-validation-valid\" data-valmsg-for=\"ProductName\" data-valmsg-replace=\"true\"\u003e\u003c/span\u003e"},{"title":"Category","width":"200px","field":"CategoryID","filterable":{"messages":{"title":"Show items with value that","buttonTitle":"{0} filter column settings"},"checkAll":false},"encoded":true,"editor":null,"dataSource":{"transport":{"read":{"url":"/aspnet-core/grid/categories"}}},"dataValueField":"CategoryID","dataTextField":"CategoryName"},{"title":"Unit price","width":"200px","field":"UnitPrice","format":"{0:C}","filterable":{"messages":{"title":"Show items with value that","buttonTitle":"{0} filter column settings"},"checkAll":false},"encoded":true,"editor":"\n\n\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%\" title=\"UnitPrice\" type=\"text\" value=\"\" /\u003e\u003cscript\u003ekendo.syncReady(function(){jQuery(\"#UnitPrice\").kendoNumericTextBox({\"format\":\"c\",\"max\":2147483647,\"min\":0});});\u003c/script\u003e\n\n\n\u003cspan class=\"field-validation-valid\" data-valmsg-for=\"UnitPrice\" data-valmsg-replace=\"true\"\u003e\u003c/span\u003e"},{"width":"150px","command":[{"text":"Delete","name":"destroy"}]}],"pageable":{"buttonCount":10},"filterable":{"messages":{"title":"Show items with value that","buttonTitle":"{0} filter column settings"}},"scrollable":{"height":"400px"},"editable":{"confirmation":"Are you sure you want to delete this record?","confirmDelete":"Delete","cancelDelete":"Cancel","mode":"incell","create":true,"update":true,"destroy":true,"template":null},"toolbar":[{"text":"Add new record","name":"create"}],"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-core/grid/foreignkeycolumn_read"},"prefix":"","update":{"url":"/aspnet-core/grid/foreignkeycolumn_update"},"create":{"url":"/aspnet-core/grid/foreignkeycolumn_create"},"destroy":{"url":"/aspnet-core/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

The ForeignKey column functionality of the Telerik UI for ASP.NET Core Grid component is primarily used for matching the value of a bound property to a desired text field from a collection that is external for the Data Grid. The ForeignKey column approach follows the convention of the SQL ForeignKey functionality that is used for linking two tables based on a foreign key.

This demo shows how to implement a foreign key column which fetches its values from a DataSource in the ASP.NET Core Data Grid which hosts the Telerik UI for ASP.NET Core DropDownList component as an editor for modifying the data.

For more information about the ForeignKey column capabilities, refer to the official Telerik UI for ASP.NET Core Data Grid product documentation on the available column settings.

Additional Apps

This Grid example is part of unique collection of hundreds of ASP.NET Core demos, with which you can see all Telerik ASP.NET Core 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 Telerik REPL for ASP.NET Core or ThemeBuilder.

ASP.NET Core Grid ForeignKey Column Binding

Description

Additional Apps

Support & Learning Resources

Additional Resources