How to update a column value of multiple rows in one go?

[Lukas Lapinskas]

I'm learning Syncfusion's Grid component and need to be able to update a column's value across multiple rows in one move. 

Now I know there is a bulk update I can do, but this requires me to click on each row and enter the same value MULTIPLE times, and then click the Update button and confirm the update.

What I want is to select multiple rows and enter that new value ONCE and click something to update ALL the values across the rows.

How can I do this? I hope the distinction is clear.

[Sivaranjani Rajasekaran]

Hi Lukas Lapinskas,

Greetings from Syncfusion support!

Syncfusion’s Batch Editing mode, combined with the AutoFill feature, allows you to quickly update a column’s value across multiple rows in one go, without manually editing each row.

How It Works:

1. Enable Batch Editing : This allows multiple edits to be made before submitting changes. To enable batch editing mode,  editSettings.mode property to Batch.
2. Enable AutoFill : The AutoFill feature in the Syncfusion ASP.NET Core Grid allows you to copy the data of selected cells and paste it into other cells by simply dragging the autofill icon of the selected cells to the desired cells. This feature provides a convenient way to quickly populate data in a grid. This feature is enabled by defining enableAutoFill property as true.
3. Commit Changes  :  Click the Update button or call the batchSave method to save all updates at once.
   

Code Example : 

<ejs-grid 
id="Grid" dataSource="@ViewBag.DataSource" height="273" 
enableAutoFill="true" 
allowSelection="true" 
toolbar="@(new List<string>() { "Add", "Update","Cancel" })">

<e-grid-editSettings allowAdding="true" allowDeleting="true" allowEditing="true" mode="Batch">
</e-grid-editSettings>

For more detailed information about batch editing please refer to the documentation link below

Documentation link : 

1. Batch Editing : https://ej2.syncfusion.com/aspnetcore/documentation/grid/editing/batch-editing
2. 
   
3. AutoFill : https://ej2.syncfusion.com/aspnetcore/documentation/grid/clipboard#autofill

Please get back to us if you need further assistance.

Regards,

Sivaranjani R

[Lukas Lapinskas]

Thanks, this will do. I'm curious is there any other components to speed up the process of making such edits?

[Joseph Christ Nithin Issack]

Hi Lukas,

Glad to hear this solution works for you!

To better understand your exact requirement, could you provide more details on what you're looking for? Are you asking for:

1. A different UI element (e.g., a popup, form, or external control) to apply values to multiple rows?
2. A different Syncfusion component that might better fit your workflow?
3. A more automated way (e.g., programmatic updates, clipboard paste, or custom buttons) to apply bulk edits?
4. If possible, could you share a video demo explaining your requirement? This will help us clearly understand your needs and suggest the best solution.
5. Also, could you let us know the Syncfusion package version you are using? This will help us provide a solution compatible with your setup.

[Lukas Lapinskas]

Joseph, thanks for jumping in. 

I was curious about a different Syncfusion component that might better for my workflow. I don't know how I'd make a video demo to explain my requirement, but I can explain it in text. I have a database table that has a lot of data in it. I want to essentially be able to view and edit that data as quickly as possible on the web page. Is there another, better component that can do this?

I am using Syncfusion.EJ2.AspNet.Core v28.2.11 NuGet package in my app. 

[Joseph Christ Nithin Issack]

Hi Lukas,

Given that you are working with a large dataset and require a fast and efficient way to view and edit data, the Syncfusion EJ2 DataGrid is generally the most suitable choice. To enhance performance, you might consider enabling enable Virtual Scrolling or Infinite Scrolling for seamless navigation through large datasets. Additionally, Batch Editing can help optimize the editing experience by allowing multiple changes to be made before committing them to the server, reducing unnecessary requests.

To better understand your specific requirements and recommend the most appropriate approach, could you kindly provide the following details?

• The type of data binding used in your application (e.g., remote or local data binding). If remote data binding is used, please specify the adaptor you are working with.
• A sample dataset (or a general description of your data structure) to help us assess the best component and configuration for your needs.