How to perform Batch Update in Sql

[KINS]

I have an Grid with Batch Mode.I would like to know how to send Batch of record to sql sever and perform the CRUD operation in single request.

[Vignesh Natarajan]

Hi Ismail,  

 

Thanks for contacting Syncfusion support.  

 

Query: “I have an Grid with Batch Mode.I would like to know how to send Batch of record to sql sever and perform the CRUD operation in single request” 

 

We have analyzed your query and we suggest you to achieve your requirement using OnBatchSave event of the Grid.  OnBatchSave event will be triggered when all the batch changes are saved (either by clicking the Update button or calling EndEdit() method) in Grid. In the event arguments, we can find the batch changes like inserted, deleted / updated records.  

 

Using these value we suggest you to make request to your sql server and update the changes. Refer the below code example.  

 

<SfGrid DataSource="@Orders" Toolbar="@(new List<string>() { "Add", "Delete", "Update", "Cancel" })"> 

    <GridEvents OnBatchSave="BatchSaveHandler" TValue="Order"></GridEvents> 

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

    <GridColumns> 

        <GridColumn Field=@nameof(Order.OrderID) HeaderText="Order ID" IsPrimaryKey="true" TextAlign="TextAlign.Right" Width="120"></GridColumn> 

        <GridColumn Field=@nameof(Order.CustomerID) HeaderText="Customer Name" Width="150"></GridColumn> 

        <GridColumn Field=@nameof(Order.OrderDate) HeaderText=" Order Date" Format="d" Type="ColumnType.Date" TextAlign="TextAlign.Right" Width="130"></GridColumn> 

        <GridColumn Field=@nameof(Order.Freight) HeaderText="Freight" Format="C2" TextAlign="TextAlign.Right" Width="120"></GridColumn> 

    </GridColumns> 

</SfGrid> 

  

@code{ 

    public List<Order> Orders { get; set; } 

    public void BatchSaveHandler(BeforeBatchSaveArgs<Order> args) 

    { 

        var ChangedRecords = args.BatchChanges.ChangedRecords; 

        var InsertedRecords = args.BatchChanges.AddedRecords; 

        var DeletedRecords = args.BatchChanges.DeletedRecords; 

        // Here you can customize your code 

    } 

  

Refer our UG documentation for your reference 

 

https://blazor.syncfusion.com/documentation/datagrid/events/#onbatchsave  

 

Please get back to us if you have further queries.   

 

Regards, 

Vignesh Natarajan 

[KINS]

Thanks for providing example.

Can you please advise how to send updated list (which is coming from grid) to database via api..

[Vignesh Natarajan]

Hi Ismail,  

 

Thanks for the update. 

 

Query: “Can you please advise how to send updated list (which is coming from grid) to database via api..” 

 

We need some more details about your requirement to validate further at our end. So kindly share the following details.  

 

1. Share the details about the Grid datasource.
2. How you have bound data to Grid (i.e.) using datasource property or using DataManager and adaptor?
3.  Share more details about your API service (WebAPI, OData, ODataV4 etc).

 

Above requested details will be very helpful in understanding your requirement and provide solution as early as possible.   

 

Regards, 

Vignesh Natarajan  

[KINS]

Please see my below points

1.I have bind data in grid using ADO.net (output is list)

2.I am going to use Web API by post method

[KINS]

Awaiting for reply

[Vignesh Natarajan]

Hi Ismail,  

 

Sorry for the delay in getting back to you.  

 

Query: “Can you please advise how to send updated list (which is coming from grid) to database via api..” 

 

We have analyzed your query and we have achieved your requirement by sending the entire batch changes object to the WebAPI using a intermediate service. Refer the below code example.  

 

@page "/" 

@inject OrderService OrderData; 

@using APIService.Data 

@using Syncfusion.Blazor.Grids 

  

  

<SfGrid @ref="Grid" TValue="Order" DataSource="@Orders" AllowFiltering="true" Toolbar="@(new List<string> { "Add", "Edit", "Delete", "Update", "Cancel", "Search" })" AllowSorting="true" AllowPaging="true"> 

    <GridEvents OnBatchSave="OnSave" TValue="Order"></GridEvents> 

    . . . . . . 

</SfGrid> 

@code{ 

    public List<Order> Orders { get; set; } 

    SfGrid<Order> Grid { get; set; } 

    protected override async Task OnInitializedAsync() 

    { 

        Orders = await OrderData.GetPeople(); 

    } 

  

    public async Task OnSave(BeforeBatchSaveArgs<Order> Args) 

    { 

        await OrderData.UpdateBatchChanges(Args.BatchChanges); 

        Grid.Refresh(); 

    } 

 

    [OrderService.cs] 

 

    public async Task<HttpResponseMessage> UpdateBatchChanges(BatchChanges<Order> value) 

    { 

        //value.OrderID = random.Next(); 

        return await _httpClient.PostAsync($"{baseUrl}api/Default", getStringContentFromObject(value)); 

    } 

    private StringContent getStringContentFromObject(object obj) 

    { 

        var serialized = JsonConvert.SerializeObject(obj); 

        var stringContent = new StringContent(serialized, Encoding.UTF8, "application/json"); 

        return stringContent; 

    } 

    [DefaultController.cs] 

    // POST: api/Default1 

    [HttpPost] 

    public object Post([FromBody] BatchChanges<Order> value) 

    { 

        //update your changes here 

        foreach (var changed in value.ChangedRecords) 

        { 

            db.UpdateOrder(changed); 

        } 

        foreach (var changed in value.AddedRecords) 

        { 

            db.AddOrder(changed); 

        } 

        foreach (var changed in value.DeletedRecords) 

        { 

            db.DeleteOrder(changed.OrderID); 

        } 

        return value; 

    } 

} 

 

 

For your convenience we have attached the sample which can be download from below  

 

Sample: https://www.syncfusion.com/downloads/support/forum/164685/ze/APIService146604802  

 

Note: Kindly change the connectionstring in OrderContext,.cs file based on the NORTHWND.MDF file in APP_Data folder. 

 

Please get back to us if you have further queries.  

 

regards, 

Vignesh Natarajan 

[KINS]

Thanks for support...

[Vignesh Natarajan]

Hi Ismail,  

Thanks for the update.  

We are glad to hear that you have achieved your requirement using our solution. 

Please get back to us if you have further queries.  

Regards, 

Vignesh Natarajan