server side paging and filtering with efcore

[issam]

Hi,

i am looking for some guidance or a simple example on how to use the grid control in batch editing mode 

using efcore controller on the backend performing efficient  server side skip / take and filtering .

thanks .

[Vignesh Natarajan]

Hi Issam,  

 

Greetings from Syncfusion support. 

 

Query: “i am looking for some guidance or a simple example on how to use the grid control in batch editing mode using efcore controller on the backend performing efficient  server side skip / take and filtering .” 

 

We have validated the your query and we suggest you to achieve your requirement using ODataV4 Adaptor and BatchEditing. For your convenience we have prepared a sample which can be downloaded from below  

Sample: https://www.syncfusion.com/downloads/support/forum/156340/ze/BatchEditing-908976471  

 

Refer the below code example for your reference 

 

<SfGrid @ref="Grid" TValue="Order" AllowPaging="true" Query="@QueryData" Toolbar="@(new List<string>() { "Add", "Edit", "Delete", "Cancel", "Update" })"> 

    <SfDataManager Url="http://localhost:9876/odata/" Adaptor="Adaptors.ODataV4Adaptor"></SfDataManager> 

    <GridPageSettings PageSize="2"></GridPageSettings> 

    <GridEvents OnActionFailure="ActionFailureHandler" TValue="Order"></GridEvents> 

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

    <GridColumns> 

        <GridColumn Field=@nameof(Order.Id) IsPrimaryKey="true" IsIdentity="true" Width="150"></GridColumn> 

        <GridColumn Field=@nameof(Order.Subject) Width="180"></GridColumn>         

        <GridColumn Field=@nameof(Order.Location) Width="200"></GridColumn> 

    </GridColumns> 

</SfGrid> 

 

 

 

Note: Please change the connectionstring of schedule.mdf (in App_Data folder) file in ScheduleDataContent.cs file in RestFul_services project. Run both project as startup.  

 

Refer our UG documentation for your reference 

 

https://blazor.syncfusion.com/documentation/datagrid/data-binding/#binding-with-odata-v4-services  

https://blazor.syncfusion.com/documentation/datagrid/editing/#batch 

 

Kindly get back to us if you have further queries.   

 

Regards, 

Vignesh Natarajan