Lost all changes after search or export data

[Fereydoon Karimi]

I've used DataGrid with below EditSettings:

       {

                allowEditing: true,

                allowAdding: true,

                allowDeleting: true,

                mode: 'Batch',

                newRowPosition: 'Bottom',

                showConfirmDialog: false,

                showDeleteConfirmDialog: false,

                allowNextRowEdit: true,

            }

When I try to export data (Excel, Pdf, CSV) or use the search box, all changes (Added, Deleted, Edited rows) have been gone!

[Balaji Sekar]

Hi Fereydoon, 

 

Greetings from the Syncfusion support. 

 

We have validated your query with provided the information and we suspect that you have export the Grid with CRUD actions(Add/Edit/Delete) changes in the Grid using Batch editing. In Batch edit, we can perform the bulk add, edit and delete operations in Grid UI when we save that changes to the Grid using update toolbar button it will affect the Grid’s dataSource until then we can see that change in Grid’s UI alone it is cause of the reported problem(you have export the Grid before save the changes to Grid’s dataSource). 

 

We have video demonstration of CRUD operations with Exporting(Excel/PDF/CSV) as given below. 

 

Video link: https://www.syncfusion.com/downloads/support/forum/163349/ze/Grid-Batch-Export-1831653697.zip 

 

Sample link: https://codesandbox.io/s/242946-vue-timepicker-modified-timepikcer-forked-t2r9o?file=/src/App.vue 

 

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

 

Regards, 

Balaji Sekar 

[Fereydoon Karimi]

Yes, you right about exporting data. but II have this problem with the search. When I edit some data and use the search box, all changes have been gone!

[Balaji Sekar]

Hi Fereydoon, 

Based on your query we suspect that you have perform the Search operation before save the changes into Grid’s dataSource(changes apply on Grid UI alone). By default in EJ2 Grid, perform the search operation based on Grid’s dataSource since you lose the changes in the Grid component. We suggest you to save the updated value into grid’s dataSource then you will perform the Search operation with updated value. 

If you facing same problem, please share the replicated sample with video demonstration to us that will help to validate further. 

Regards, 

Balaji Sekar