Child Grid Issues. (Urgent)

Question

I have sent this to a rep as well as followed every step on your guide with no results.My grid does not load child entries. I also need to be able to CRUD child entries from the grid.

e-grid-pagesettings> e-grid-filterSettings> e-data-manager> e-grid-editSettings>

e-grid-column>

Brandon Workman · Answer

I'm very close to going in another direction because of the lack of support for issues that should not be having issues. This ticket has got one day or I'm done with Syncfusion.

Hariharan J V · Answer

Hi Brandon, Thanks for contacting Syncfusion support. By default, UrlAdaptor expects the response object as result and count pair set but in the provided information(ReturnProcess) does not contain result and count pair so that it display no records to display message in child grid. As per your requirement(child grid with urladaptor) we have created a sample for your reference. Kindly refer to the below code example and sample for more information.

public IActionResult UrlDatasource([FromBody]Data dm) { var val = OrdersDetails.GetAllRecords(); var Data = val.ToList(); if (dm.Where != null) { Data = OrdersDetails.GetAllRecords().Where(or => or.EmployeeID == dm.Where[0].value).ToList(); fetch child grid data(filter child grid data based on parent) } int count = Data.Count(); if (dm.skip != 0) Data = Data.Skip(dm.skip).ToList(); if (dm.take != 0) Data = Data.Take(dm.take).ToList(); return dm.requiresCounts ? Json(new { result = Data, count = count }) : Json(Data); } Sample : http://www.syncfusion.com/downloads/support/directtrac/general/ze/Grid-child-grid-url-core622989472 Help documentation : https://ej2.syncfusion.com/javascript/documentation/data/adaptors.html#url-adaptor Please get back to us if you need further assistance. Regards, Hariharan

Brandon Workman · Answer

Hello,Thank you for the help you have provided. I currently have a few more questions.I would like to get ProcessName as a list from a datasource..IE ViewBag.Data = GetAllProcessNames().ToList();The Process Name field would then give the values in the list.My second issue is that is it required to show the primary keys in order to delete items? If I hide them it will not delete.Same with adding items, when adding a child it requires me to find the parent Id and manually enter it in, is there a way around that?My last question applies to checkboxes. Is there a way to have the input as a checkbox instead of typing true/false?My code Thanks.Attachment: OtherIssues_9c7891b.zip

Hariharan J V · Answer

Hi Brandon, Thanks for your update. Query1: is it required to show the primary keys in order to delete items? No, There is no need to show the primary key columns in Grid. We have created a sample for your reference in the below sample we have set visible property as false for the primaryKey column and delete operations are working fine at our sample. Please refer to the below code example and sample for more information. Sample : http://www.syncfusion.com/downloads/support/directtrac/general/ze/Grid-childgrid-CRUD664663177 Query2: when adding a child it requires me to find the parent Id and manually enter it in, is there a way around that? We have analyzed your requirement and you can achieve this by using the below way. In the below code example we have get the parent id value in actionBegin event and then applied the parent id for the child grid Employee field. Kindly refer to the below code example for more information Help documentation: https://ej2.syncfusion.com/documentation/grid/api-grid.html?lang=typescript#actionbegin Query3: Is there a way to have the input as a checkbox instead of typing true/false? We have analyzed your requirement and you can achieve this by using the below way. In the below sample, we have applied editType as ‘booleanedit’ for the Verified columns in Grid so it display checkbox while perform the CRUD operation in Grid. Kindly refer to the below code example for more information. Regards, Hariharan

Brandon Workman · Answer

You missed one of my questionsI would like to get ProcessName as a list from a datasource..IE ViewBag.Data = GetAllProcessNames().ToList();{ field: 'ProcessType', headerText: 'Process Name', width: 120, editType: 'dropdownedit' },A custom selectlist for my grid options.Thanks

Hariharan J V · Answer

Hi Brandon, Query: I would like to get ProcessName as a list from a datasource.. We have validated your query and you can achieve your requirement by using below method. Here, we have assigned viewbag dataSource as a list to dropdown editing column. Please find the below code example and sample for your reference. [code example] [index.cshtml]

[HomeController.cs] ... ... namespace TestSample.Controllers { public class HomeController : Controller { public IActionResult Index() { ViewBag.DataSource = OrdersDetails.GetAllRecords().ToList(); ViewBag.DropdownData = OrdersDetails1.GetAllRecords().ToList(); //dropdown data as a list return View(); } } public class OrdersDetails { ... } We have prepared a sample based on your requirement. Please find the sample in below link. Sample link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/TestSample-ViewBagListDataSorce1824968133 Please get back to us if you need further assistance. Regards, Hariharan

Brandon Workman · Answer

I was looking to do this on my child grid with the JS solution you provided me. This syntax does not work in this situation.Please look at my code.

Hariharan J V · Answer

Hi Brandon, Thanks for your update. As per your suggestion we have provided the solution in JavaScript. In the below sample we have applied custom dataSource for DropDown by using the edit params property of columns in Grid. Kindly refer to the below code example and updated sample for more information.

Chad Church · Answer

Subject: RE: Update 

Yeah those are the only issues I’m having. Just getting those DropDowns to work properly in the JS code. Like I said I followed it to the T but it’s just giving me that empty list. For the most part I’m not having any other issues currently. 

I would like to speak to somebody about the last solution posted on the forum because it’s not working at all. 
  
  
{ field: 'ProcessType', headerText: 'ProcessType', width: 120, editType: 'dropdownedit', edit: { params: {dataSource: @Html.Raw(Json.Serialize(@ViewBag.d)), } } }, 
  
ViewBag.d = _context.ALL_PROCESSNAMES.ToList().Select(x => x.Name); 
  
I’ve tried this multiple ways including a static list and nothing will show up. 

  
  Brandon S. Workman

Madhu Sudhanan P · Answer

Hi Brandon, Thanks for your update. We have validated the provided information and we suggest you to use the below way to resolve the reported problem. In the below sample we have applied custom dataSource(static list) for dropdown in Grid. Please refer to the below code example and sample for more information.

. . . .

Brandon Workman · Answer

I'm having trouble using the regular code Is there a way I can use the code below to fix this? It's the same error as doing it with JS. That or is there a way to target the grid with JS and have the dropdown data pushed?Thanks for your help so far.

Madhu Sudhanan P · Answer

Hi Brandon Workman, We have checked your query and you can achieve your requirement by using EditType and its params. We have prepared a simple sample based on your query. Please refer the below example code, sample link and documentation link. [Index.cshtml]

. . . . .

Sample : http://www.syncfusion.com/downloads/support/directtrac/general/ze/Dropdownedit-189131439 Documentation : https://ej2.syncfusion.com/aspnetcore/documentation/grid/edit.html#cell-edit-type-and-its-params Regards, Madhu Sudhanan P