Grid Asp.Net Core Razor Page - Crud operation

[Aguzz]

Hi all,
I followed several examples on this forum on "how to use the grid with the razor page", but it doesn't work.

The test project is attached.

If I use the example using the datasource binding, the grid fills up,
If I use <e-data-manager> the events don't fired and the grid "no record to display"... how can I solve this problem?

Thank you

Attachment: testgridsyncfusion_82cf9f18.zip

[Hariharan J V]

Hi Aguzz, 

Greetings from the Syncfusion support,  

We have validated your query provided information and we have modified the sample with CRUD operation on EJ2 Grid in Razor. Please refer the below sample for more information. 

Sample link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/testgridsyncfusion_82cf9f18-505232711.zip 

Regards, 

Hariharan 

[Aguzz]

Hi, thanks for the quick answer.
I tested your example and now the Crud operation works well,
But I wanted to tell you, that if you enable allowSorting = "true" in your example it doesn't work

Thanks again

Hello

[Thavasianand Sankaranarayanan]

Hi Aguzz, 

We have validated your query. While using remote data you need to handle the on demand actions in server side. Please find the below code snippet and sample for more information. 

Index.cshtml.cs 

public JsonResult OnPostDataSource([FromBody]DataManagerRequest dm) 

        { 

            IEnumerable DataSource = OrdersDetails.GetAllRecords(); 

            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); 

            } 

            if (dm.Where != null && dm.Where.Count > 0) //Filtering 

            { 

                DataSource = operation.PerformFiltering(DataSource, dm.Where, dm.Where[0].Operator); 

            } 

            int count = DataSource.Cast<OrdersDetails>().Count(); 

            if (dm.Skip != 0) 

            { 

                DataSource = operation.PerformSkip(DataSource, dm.Skip);   //Paging 

            } 

            if (dm.Take != 0) 

            { 

                DataSource = operation.PerformTake(DataSource, dm.Take); 

            } 

            return dm.RequiresCounts ? new JsonResult(new { result = DataSource, count = count }) : new JsonResult(DataSource); 

    } 

Sample: https://www.syncfusion.com/downloads/support/forum/145785/ze/145785-razorpage-_ondemand-581387817 

Please get back to us, if you need further assistance. 

Regards, 

Thavasianand S. 

[Aguzz]

Thank you, now works well.

[Hariharan J V]

Hi Aguzz, 

  

 We are happy to hear that your requirement has been achieved. 

  

Regards, 

Hariharan