No record showing from grid

[Gencer]

Hi. My scaffolding using Syncfusion Blazor Scaffolding is not working. I searched a lot, but I couldn't find my mistake or deficiency. I request your help.

Notes: Net6, Blazor Webassembly, Entity  Framework 6.04, MS SQL

Controller Code:

using System.Collections;
using System.Collections.Generic;
using Syncfusion.Blazor;
using Newtonsoft.Json;
using System.Linq;
using System;
using Microsoft.AspNetCore.Mvc;
using Microsoft.EntityFrameworkCore;
using genAppEnki.Shared.Models;
using genAppEnki.Server.Data;

namespace genAppEnki.Server.Controllers
{
    public class TblDstServisAltController : ControllerBase
        {
         genAppEnkiDbContext db=new genAppEnkiDbContext();

public DbSet<TblDstServisAlt> GetAllTblDstServisAlt()
        {
try
{
return db.TblDstServisAlt;
}
catch
{
throw;
}
        }

       // POST api/<controller>
        [HttpPost]
        [Route("api/[controller]")]
        public Object Post([FromBody]DataManagerRequest dm)
        {
            IEnumerable DataSource = GetAllTblDstServisAlt().ToList();
            if (dm.Search != null && dm.Search.Count > 0)
            {
                DataSource = DataOperations.PerformSearching(DataSource, dm.Search);  //Search
            }
            if (dm.Sorted != null && dm.Sorted.Count > 0) //Sorting
            {
                DataSource = DataOperations.PerformSorting(DataSource, dm.Sorted);
            }
            if (dm.Where != null && dm.Where.Count > 0) //Filtering
            {
                DataSource = DataOperations.PerformFiltering(DataSource, dm.Where, dm.Where[0].Operator);
            }
            int count = DataSource.Cast<TblDstServisAlt>().Count();
            if (dm.Skip != 0)
            {
                DataSource = DataOperations.PerformSkip(DataSource, dm.Skip);   //Paging
            }
            if (dm.Take != 0)
            {
                DataSource = DataOperations.PerformTake(DataSource, dm.Take);
            }
           return dm.RequiresCounts ?  new { result = DataSource, count = count } : DataSource as object;


        }
[HttpPost]
        [Route("api/TblDstServisAlt/Insert")]
        public void Insert([FromBody]CRUDModel<TblDstServisAlt> Data)
        {
            try
            {
                db.TblDstServisAlt.Add(Data.Value);
                db.SaveChanges();
            }
            catch
            {
                throw;
            }
        }
        [HttpPost]
        [Route("api/TblDstServisAlt/UpdateTblDstServisAlt")]
        public void UpdateTblDstServisAlt([FromBody]CRUDModel<TblDstServisAlt> Data)
        {
            try
            {
                db.Entry(Data.Value).State = EntityState.Modified;
                db.SaveChanges();
            }
            catch
            {
                throw;
            }
        }
        [HttpPost]
        [Route("api/TblDstServisAlt/DeleteTblDstServisAlt")]
        public void DeleteTblDstServisAlt([FromBody]CRUDModel<TblDstServisAlt> Data)
        {
            try
            {
              TblDstServisAlt ord = db.TblDstServisAlt.Find(int.Parse(Data.Key.ToString()));
              db.TblDstServisAlt.Remove(ord);
              db.SaveChanges();
            }
            catch
            {
               throw;
             }
        }


        public class CRUDModel<T> where T : class
        {
 [JsonProperty("action")]
            public string Action { get; set; }
            [JsonProperty("table")]
            public string Table { get; set; }
            [JsonProperty("keyColumn")]
            public string KeyColumn { get; set; }
            [JsonProperty("key")]
            public object Key { get; set; }
            [JsonProperty("value")]
            public T Value { get; set; }
            [JsonProperty("added")]
            public List<T> Added { get; set; }
            [JsonProperty("changed")]
            public List<T> Changed { get; set; }
            [JsonProperty("deleted")]
            public List<T> Deleted { get; set; }
            [JsonProperty("params")]
            public IDictionary<string, object> Params { get; set; }
        }
 }
}

Razor page:

@page "/Servis"

@using genAppEnki.Shared.Models;

@using Syncfusion.Blazor.Data;

@using Syncfusion.Blazor;

@using System.Collections;

@using Syncfusion.Blazor.Grids;

<SfGrid ID="Grid" @ref="@Grid" TValue="TblDstServisAlt" Height="315" AllowSorting="true" AllowPaging="true" AllowFiltering="true" Toolbar="@(new List<string>() { "Add", "Edit","Update","Delete","Cancel" , "ExcelExport" ,"PdfExport"})" AllowSelection="true" AllowExcelExport="true" AllowPdfExport="true">

  <SfDataManager Url="/api/TblDstServisAlt/Post" InsertUrl="/api/TblDstServisAlt/Insert" UpdateUrl="/api/TblDstServisAlt/UpdateTblDstServisAlt" RemoveUrl="/api/TblDstServisAlt/DeleteTblDstServisAlt" Adaptor="Adaptors.UrlAdaptor" ></SfDataManager>

   <GridPageSettings PageSize="7"></GridPageSettings>

<GridFilterSettings Type="Syncfusion.Blazor.Grids.FilterType.Menu"></GridFilterSettings>

<GridEditSettings AllowAdding="true" AllowDeleting="true" AllowEditing="true" Mode="EditMode.Dialog"></GridEditSettings>

<GridSelectionSettings Type="Syncfusion.Blazor.Grids.SelectionType.Multiple"></GridSelectionSettings>

<GridEvents OnToolbarClick="ToolbarClick" TValue="TblDstServisAlt"></GridEvents>

    <GridColumns>

    <GridColumn Field="ServisAltKn" HeaderText="ServisAltKn" IsPrimaryKey="true" IsIdentity="true"></GridColumn>

    <GridColumn Field="ServisKn" HeaderText="ServisKn" Type="ColumnType.Number" IsIdentity="true"></GridColumn>

    <GridColumn Field="FormNo" HeaderText="FormNo" Type="ColumnType.String" IsIdentity="true"></GridColumn>

    <GridColumn Field="FirmaKn" HeaderText="FirmaKn" Type="ColumnType.Number" IsIdentity="true"></GridColumn>

    <GridColumn Field="KullaniciKisiKn" HeaderText="KullaniciKisiKn" Type="ColumnType.Number" IsIdentity="true"></GridColumn>

    <GridColumn Field="ServisBaslangic" HeaderText="ServisBaslangic" Type="ColumnType.DateTime" IsIdentity="true"></GridColumn>

<GridColumn Field="ServisBitis" HeaderText="ServisBitis" Type="ColumnType.DateTime"></GridColumn>

    <GridColumn Field="YapilacakIs" HeaderText="YapilacakIs" Type="ColumnType.String" IsIdentity="true"></GridColumn>

    <GridColumn Field="YapilanIs" HeaderText="YapilanIs" Type="ColumnType.String" IsIdentity="true"></GridColumn>

<GridColumn Field="ServisNotu" HeaderText="ServisNotu" Type="ColumnType.String"></GridColumn>

<GridColumn Field="ServisYontemi" HeaderText="ServisYontemi" Type="ColumnType.String"></GridColumn>

<GridColumn Field="Bitti" HeaderText="Bitti" Type="ColumnType.Boolean"></GridColumn>

<GridColumn Field="ImzalayanKisiKn" HeaderText="ImzalayanKisiKn" Type="ColumnType.Number"></GridColumn>

    </GridColumns>

</SfGrid>

@code{

  SfGrid<TblDstServisAlt> Grid { get; set; }

  public void ToolbarClick(Syncfusion.Blazor.Navigations.ClickEventArgs args)

{

  if (args.Item.Id == "Grid_pdfexport")

  {

    this.Grid.PdfExport();

  }

  if (args.Item.Id =="Grid_excelexport")

  {

    this.Grid.ExcelExport();

  }

}

}

[Renjith Singh Rajendran]

Hi Gencer,

Greetings from Syncfusion support.

We are not clear about the exact scenario you are facing this issue. Could you please bind the “OnActionFailure” event to Grid. This event will be triggered for every failure action in Grid. Please share the details you get in the “args” of this event handler for further analysis. 

Reference: https://blazor.syncfusion.com/documentation/datagrid/events#onactionfailure

Also share with us the Syncfusion version details and details of any exception occurred when rendering grid. The provided information will help us analyze the problem, and provide you a solution as early as possible.

Regards,

Renjith R