How to call update, delete methods in the grid.

[chris johansson]

I have a grid with batch edit mode. Currently when i make some changes and click update, it doesn't actually update and it stays green highlighted even after i click yes to save changes. I think something may have affected this. Also how do i override the methods so when i click update or delete etc. it will make certain calls to the database with the updated data. I attached my grid code.

               

                   

                   

                   

                   

                   

                   

                       

                       

                       

                           

                               

                                   

                                   

                                       

                                           

Address

                                       

                                       

                                           

@((context2 as FDILocationAddress).locationAddress)

                                       

                                   

                                   

                               

                           

                       

                       

                           

                                @{var currItem = (context as FDIChemicalOrderLine);

                                   

                                       

                                       

                                           

                                               

Item Number	Search Name

                                           

                                           

                                               

@((context2 as FDIItemID).itemid)

@((context2 as FDIItemID).NameAlias)

                                           

                                       

                                       

                                   

                                }

                           

                       

                       

                   

               

[Rahul Narayanasamy]

Hi Chris, 

Greetings from Syncfusion. 

Query: How to call update, delete methods in the grid. - I have a grid with batch edit mode. - how do i override the methods so when i click update the data 

We have validated your query and you want to save the edited data in batch edit mode using external method. You can achieve your requirement by using EndEdit method of the Grid. Here, we have save the edited data using EndEdit method in button click. Find the below code snippets for your reference. 

 

<button @onclick="Update">Update</button> 

 

<SfGrid @ref="Grid" DataSource="@Orders" AllowPaging="true" Toolbar="@(new List<string>() { "Add", "Delete", "Update", "Cancel" })" Height="315"> 

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

    <GridColumns> 

        . . . 

   </GridColumns> 

</SfGrid> 

 

@code{ 

    SfGrid<Order> Grid; 

    . . . 

   public void Update() 

    { 

        Grid.EndEdit(); 

    } 

} 

If it does not meet your requirement, then could you please share more information about your requirement. it will be helpful to validate and provide a better solution. 

• Full Grid code snippets.
• More detail about your requirement.
• Syncfusion NuGet version details.

Regards, 

Rahul 

[chris johansson]

So what I want to do is call a method that these base menu options initialized by the grid call. The toolbar events. This is because when I click update or delete, I'm going to call the database to update each time etc.. Also for some reason before when I clicked update, it would change from highlighted green color to regular background but it is not doing this anymore so the base update is not working properly anymore and i'm not sure why.

18.2.0.58 sync fusion package. i created another ticket with my code attached.

   

                   

                   

                   

                   

                   

                   

                       

                       

                       

                           

                               

                                   

                                   

                                       

                                           

Address

                                       

                                       

                                           

@((context2 as FDILocationAddress).locationAddress)

                                       

                                   

                                   

                               

                           

                       

                       

                           

                                @{var currItem = (context as FDIChemicalOrderLine);

                                   

                                       

                                       

                                           

                                               

Item Number	Search Name

                                           

                                           

                                               

@((context2 as FDIItemID).itemid)

@((context2 as FDIItemID).NameAlias)

                                           

                                       

                                       

                                   

                                }

                           

                       

                       

                   

               

[Rahul Narayanasamy]

Hi Chris, 

 

Thanks for the update. 

 

We have analyzed the provided code example and found that you have not defined the PrimaryKey column in Grid. To Perform CRUD action in Grid, IsPrimaryKey property must be defined to any one of the available column whose value is unique. Based on the primarykey value only changes will be saved in Grid. So we suggest you to define the IsPrimaryKey property to any one of the column whose value is unique. Refer our UG documentation for your reference  

  

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

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

 

To save the changes in Database using OnBatchSave event of the Grid. This event will be triggered when saving all the changes (as a whole) in Grid. In the event argument we can get the changes performed in Grid, like changed record, added record, deleted records etc. Using these value, you can update the changes in Database.  

  

Refer the below code example.   

  

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

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

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

. . . . . .  

</SfGrid>  

   

@code{  

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

    public void OnSave(BeforeBatchSaveArgs<Order> Args)  

    {  

        var BatchChanges = Args.BatchChanges;  

        if(BatchChanges.AddedRecords.Count > 0)  

        {  

            //Insert data into your database  

        }  

        if(BatchChanges.ChangedRecords.Count > 0)  

        {  

            //update changes into your database  

        }  

        if(BatchChanges.DeletedRecords.Count > 0)  

        {  

            //delete record from your database  

        }  

    }  

  

Refer our UG documentation for your reference  

  

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

Please let us know if you have any concerns. 

Regards, 

Rahul 

[chris johansson]

awesome that worked thanks alot

[Rahul Narayanasamy]

HI Chris, 

 

Thanks for the update. 

 

We are happy to hear that the provided solution was helpful to achieve your requirement. 

 

Please get back to us if you need further assistance. 

 

Regards, 

Rahul