Foreign key in kendo MVC grid foreign key

[Mahesh]

I am trying to bind the datatable to the MVC grid and using ajax read to get the data. Everything is working as expected until I am trying to convert one of the column to foreignkey column.

Here is my sample code

 @(Html.Kendo().Grid<dynamic>()
                .Name("ReportGrid")
                .Scrollable()
                .Columns(columns =>
                {
                    foreach (var column in Model.TableConfig.MasterColumns)
                    {
                        if (refColumns.Contains(column.ColumnName))
                        {
                            var refData = Model.MetaData.Where(m => m.ColumnName == column.ColumnName).ToList();


                            columns.ForeignKey(column.ColumnName, new SelectList(refData, "DataValue","DataText")).EditorTemplateName("GridForeignKey");


                        }
                        else
                        {
                            columns.Bound(column.ColumnName);
                        }
                        //var c = columns.Bound(column.ColumnName);
                    }                
                })

 

I am getting the below error

 

System.AggregateException: 'One or more errors occurred. ('object' does not contain a definition for 'DataTable ColumnName')'

[Mahesh]

https://www.telerik.com/forums/grid-dynamic-and-foreignkey-(for-dropdown) helped me in resolving issue.

[Anton Mironov]

Hi Mahesh,

Thank you for sharing the resolution approach with the community.

The following demo represents the recommended implementation of the ForeignKey column in a Grid:

• https://demos.telerik.com/aspnet-mvc/grid/foreignkeycolumn

The following article provides the needed documentation for using a ForeignKey column:

• https://docs.telerik.com/aspnet-mvc/html-helpers/data-management/grid/columns/foreignkey-column

 

Kind Regards,
Anton Mironov