We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to save all grid grouping control rows back to the database, and what's the right approach?

Thread ID:

Created:

Updated:

Platform:

Replies:

115711 Jan 31,2014 09:28 AM UTC Feb 3,2014 12:57 PM UTC Windows Forms 1
loading
Tags: GridControl
Gary
Asked On January 31, 2014 09:28 AM UTC

I have a list of objects then I assign that to the datasource of the grid grouping control to display in my form.
In my grid, I let the user change one column by selecting from a dropdownlist of values, that dropdownlist is available for all rows.

I'm new with Syncfusion control, much more with grid. What's the best approach to let users edit the rows:
1.Edit the rows in the grid any order they want, then have a single button to save all rows?
2. Edit each row and save immediately to database and just not use a save button?

What's the advisable way of doing this, and can you please paste a code to loop through each row in the grid if I need to just use a button to save all change?

Thank you, I just need to have the answers asap as the project is only allowed a few days, and any help would be greatly appreciated.

God bless.

Anish George [Syncfusion]
Replied On February 3, 2014 12:57 PM UTC

Hi Riggs,

 

Thank you for using Syncfusion products.

 

We are quite unclear with your query but however we suggest you to use the SaveQueryCellInfo event. All the changes of the cell will be saved in this event. You can get the required row index and column index in this event.

 

C#:

this.gridControl1.SaveCellInfo += new GridSaveCellInfoEventHandler(gridControl1_SaveCellInfo);

void gridControl1_SaveCellInfo(object sender, GridSaveCellInfoEventArgs e)

{

if (e.RowIndex == 5)

{

/// yur code here

}

}

 

You can refer the below KB link for knowing on how to save changes made in grid into the database.

 

http://www.syncfusion.com/support/kb/655/How%20can%20I%20save%20changes%20made%20in%20the%20Grid%20into%20the%20database

 

Please let us know if the provided solution helps you. If not please give us more details regarding this so that we can provide you a solution

 

Regards,

Anish


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;