Save changes from sfdatagrid to database using entity framework

[Mariusz Juszkiewicz]

I have sfdatagrid bound to entity framework. How do i save or update changes to database with ef.

[Saravanan Ayyanar]

Hi Mariusz Juszkiewicz, 

 

Thank you for using Syncfusion controls. 

 

You can save the changes and you add the new row by below mentioned events. 

 

Save Data changes

You can save the data changes by CurrentCellEndEdit event.    C#:  private void SfDataGrid1_CurrentCellEndEdit(object sender, Syncfusion.WinForms.DataGrid.Events.CurrentCellEndEditEventArgs e)   {       MessageBox.Show("CurrentCellEndEdit");       //You can add your entity codes here to save the data.   }

Add New Row

You can save the add new row changes by RecordsCollectionChanged event.    C#:  private void Records_CollectionChanged(object sender, System.Collections.Specialized.NotifyCollectionChangedEventArgs e)   {       if (e.Action == System.Collections.Specialized.NotifyCollectionChangedAction.Add)       {           var record = e.NewItems[0] as RecordEntry;           //You can add your entity codes here to add the data .       }   }

 

Sample Link: 

https://www.syncfusion.com/downloads/support/directtrac/general/ze/DataGridSample-761686277 

 

You can refer the Entity Framework connection from below UG documentation,  

  

UG link: https://help.syncfusion.com/windowsforms/datagrid/databinding#binding-data-from-ado-net-entity-framework  

  

For more details refer below links,  

  

Link1: https://www.codeproject.com/Questions/345111/Inserting-new-row-into-DataGridView-nd-Updating-DB  

  

Link2: https://social.msdn.microsoft.com/Forums/vstudio/en-US/e24917b1-6d5c-423b-917a-0920967dbdf2/save-datagrid-changes-on-db-entity-framework-6?forum=wpf  

  

Please let us know, if you need further assistance on this.  

 

Regards, 

Saravanan A.