We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Edit grid with Foreign Keys

Thread ID:





131156 Jun 23,2017 09:51 PM UTC Aug 14,2017 12:13 PM UTC ASP.NET Core 6
Tags: Grid
Asked On June 23, 2017 09:51 PM UTC

I have a grid that is using a data source with a foreign key (department column). When I try to edit the last record (Name4) the values change to the first record in the grid and even if I change the values nothing gets updated. The drop down option when editing the record is working, but the selection is not being saved.

My Razor code for the grid is:

@model IEnumerable<XXXCore.Models.Employee>

    ViewData["Title"] = "Index";


    <a asp-action="Create">Create New</a>

 <ej-grid id="FlatGrid" allow-sorting="true" allow-paging="true" allow-reordering="true"  datasource="ViewBag.DataSource1">
     <e-edit-settings allow-adding="true" allow-editing="true" allow-deleting="true" edit-mode="@(EditMode.Normal)"></e-edit-settings>
     <e-toolbar-settings show-toolbar="true" toolbar-items="@(new List<string>() {"add","edit","delete","update","cancel" })"></e-toolbar-settings>  
        <e-column field="Name" header-text="Name" text-align="Left" width="70"></e-column>
        <e-column field="LastName" header-text="Last Name" text-align="Left" width="80"></e-column>
        <e-column field="DOB" header-text="Birth Date" text-align="Left" width="80" format="{0:dd/MM/yyyy}"></e-column>
        <e-column field="DepartmentID" datasource="(IEnumerable<object>)ViewBag.DataSource2"  
                header-text="Department" foreign-key-field="ID" foreign-key-value="Name" text-align="Left" 
                  width="80" edit-type="@(EditingType.Dropdown)"></e-column>

The controller code is:

        // GET: Employees
        public async Task<IActionResult> Index()
            ViewBag.DataSource1 = await _context.Employees.ToListAsync();
            ViewBag.DataSource2 = await _context.Departments.ToListAsync();
            return View();

What am I missing ? thanks in advance.

Jayaprakash Kamaraj [Syncfusion]
Replied On June 26, 2017 05:40 AM UTC

Hi Juan, 

Thank you for contacting Syncfusion support. 

The editing is performed based on the primary key column but you have missed to refer isPrimaryKey property in column. So, please set isPrimaryKey property for primary key column and refer to the following help document, Knowledgebase document and code example 

    <e-column field="OrderID" header-text="Order ID" is-primary-key="true" type="number" validation-rules='new Dictionary<string, object>() { {"required",true}, {"number",true} }' text-align="Right" width="75"></e-column> 
    <e-column field="CustomerID" header-text="Customer ID" type="string" validation-rules='new Dictionary<string, object>() { {"required",true}, {"minlength",3} }' width="80"></e-column> 
    <e-column field="EmployeeID_FirstName" header-text="Employee ID" type="string" datasource="ViewBag.data" edit-type="@(EditingType.Dropdown)" text-align="Right" width="75"></e-column> 
    <e-column field="Verified" header-text="Verified" default-value="false" edit-type="Boolean"  type="boolean" width="110"  text-align="Left"></e-column> 


Jayaprakash K. 

Replied On June 27, 2017 06:43 PM UTC

it is working now thank you very much

Jayaprakash Kamaraj [Syncfusion]
Replied On June 28, 2017 08:37 AM UTC

Hi Juan, 
We are happy that the problem has been solved. 
Please get back to us if you need any further assistance.   
Jayaprakash K. 

Replied On August 13, 2017 03:00 PM UTC

This scenario is working but I am having a new issue. I am using a master detail grid to assign roles to an user.  I am trying to populate the table AspNetUserRoles which has to columns as the primary key (UserId and Role Id).

I am doing something similar to :


I an getting the records in the detail but they are not being displayed in the screen. When I add a record it works and the new record is added to the AspNetUserRoles table in the database, but when I refresh the child grid shows the new row but all the cells are empty.

What is the way to handle a many to may relation  in a master detail grid?

Replied On August 13, 2017 03:19 PM UTC

One of the issues I see in this case is that you can not use the  is-primary-key="true" in two columns.

Alan Sangeeth S [Syncfusion]
Replied On August 14, 2017 12:13 PM UTC

Hi Juan, 

We are unable to reproduce the issue “Detail grid not populated with two primarykey columns” in our end. We have prepared a sample based on your requirement and the same can be downloaded from below link. 

Could you please share the below details so that we could provide you solution as early as possible? 
1.       Complete Grid code example. 
2.       Screenshot of the issue. 
3.       Please replicate the issue in above sample and send us back 

Alan Sangeeth S 


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon