Save changes from sfdatagrid to database using entity framework

Thread ID:	Created:	Updated:	Platform:	Replies:
150912	Jan 24,2020 04:51 AM UTC	Jan 27,2020 02:23 PM UTC	WinForms	1

Subscribe to this post

Tags: SfDataGrid

Mariusz Juszkiewicz

Asked On January 24, 2020 04:51 AM UTC

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

Reply | Reply with quote

Saravanan Ayyanar [Syncfusion]

Replied On January 27, 2020 02:23 PM UTC

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.

Reply | Reply with quote

CONTACT US

Save changes from sfdatagrid to database using entity framework

Thread ID:

Created:

Updated:

Platform:

Replies:

Please sign in to access our forum

CONTACT US