Drop Down List Field in dataGrid not displaying data (Request Failed)

Question

hello the dropdown list in the field gives me request failed all other columns load fine but the dropdown field not

in the controller public async Task Index() { ViewData["QualitéSign"] = new SelectList(_context.QualitéSigns, "Id", "Id"); ViewData["TypeEnt"] = new SelectList(_context.TypeEnts, "Id", "Id"); var pGIsmartContext = _context.Storefixes.Include(e => e.QualitéSignNavigation).Include(e => e.TypeEntNavigation); ViewBag.DataSource = await _context.Storefixes.Include(e => e.QualitéSignNavigation).Include(e => e.TypeEntNavigation).ToListAsync(); return View(await pGIsmartContext.ToListAsync()); } public ActionResult Delete([FromBody] CRUDModel value) { ViewData["QualitéSign"] = new SelectList(_context.QualitéSigns, "Id", "Id"); ViewData["TypeEnt"] = new SelectList(_context.TypeEnts, "Id", "Id"); //do stuff Storefix Storefix = _context.Storefixes.Where(c => c.Id == int.Parse(value.Key.ToString())).FirstOrDefault(); _context.Storefixes.Remove(Storefix); _context.SaveChanges(); return Json(Storefix); } public ActionResult Insert([FromBody] CRUDModel value) { ViewData["QualitéSign"] = new SelectList(_context.QualitéSigns, "Id", "Id"); ViewData["TypeEnt"] = new SelectList(_context.TypeEnts, "Id", "Id"); ViewBag.Data = new SelectList(_context.QualitéSigns, "Id", "Id").ToList(); //do stuff _context.Storefixes.Add(value.Value); _context.SaveChanges(); return Json(value.Value); } public ActionResult UrlDatasource([FromBody] DataManagerRequest dm) { ViewData["QualitéSign"] = new SelectList(_context.QualitéSigns, "Id", "Id"); ViewData["TypeEnt"] = new SelectList(_context.TypeEnts, "Id", "Id"); IEnumerable DataSource = _context.Storefixes.Include(e => e.QualitéSignNavigation).Include(e => e.TypeEntNavigation).ToList(); DataOperations operation = new DataOperations(); if (dm.Search != null && dm.Search.Count > 0) { DataSource = operation.PerformSearching(DataSource, dm.Search); //Search } if (dm.Sorted != null && dm.Sorted.Count > 0) //Sorting { DataSource = operation.PerformSorting(DataSource, dm.Sorted); } int count = DataSource.Cast().Count(); if (dm.Skip != 0)//Paging { DataSource = operation.PerformSkip(DataSource, dm.Skip); } if (dm.Take != 0) { DataSource = operation.PerformTake(DataSource, dm.Take); } return Json(new { result = DataSource, count = count }); }

Rajapandiyan Settu · Answer

Hi Gat, 
 
Thanks for contacting Syncfusion support. 
 
By analyzing your code example, we found that you did not return the data in expected format from the server to the Dropdown. This is the cause of reported behavior. 
 
In some of the cases, Grid expects the array of data from server instead of result and count object. Which is handled through the RequiresCounts property. If the RequiresCounts property is false, we need to return the array of data from the server. 
 
You can resolve the reported problem by using following highlighted code. 
 
URL Adaptor: https://ej2.syncfusion.com/aspnetcore/documentation/grid/data-binding#handling-on-demand-grid-actions 
 




 
public IActionResult UrlDatasource([FromBody]DataManagerRequest dm) 
{ 
    IEnumerable DataSource = OrdersDetails.GetAllRecords().ToList(); 
     // perform the actions here 
    ----    
    // return the data based on RequiresCount 
    return dm.RequiresCounts ? Json(new { result = DataSource, count = count }) : Json(DataSource); 
} 
 
 
Please get back to us if you need further assistance. 
 
Regards, 
Rajapandiyan S