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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Changing Multiple Cell Values in Code on a GDBG

Thread ID:





108876 May 16,2013 08:34 PM UTC May 20,2013 05:33 AM UTC WinForms 1
Tags: GridControl
Frank Carr
Asked On May 16, 2013 08:34 PM UTC

In my WinForms app I'm displaying the results of a search in a GDBG. The specs call for giving users the ability to update a column (integer value) in the results individually or in bulk. Where I'm encountering a problem is how to handle the bulk update. I loop through the grid like so...
Dim RowCnt As Integer = gridMain.Model.RowCount
For Cntr = 1 To RowCnt
gridMain(Cntr, 6).CellValue = CInt(textQuantity.Text)
But, the row goes into edit mode and only the first row is updated. The edit icon is showing on the row. How do I tell the grid to ignore row editing functionality when the bulk update is occurring?

Ragamathulla B [Syncfusion]
Replied On May 20, 2013 05:33 AM UTC

Hi Frank,


Thank you for your interest in sync fusion products,


You can update the bulk data’s in to the grid. Please refer to the following code. Which illustrates the same.



                   grid.Binder.DirectSaveCellInfo = true;



                        foreach (GridRangeInfo range in ranges)


                            for (int i = range.Top; i <= range.Bottom; i++)


                                double currentValue = Convert.ToDouble(grid[i, range.Left].CellValue);

                                currentValue += value;

                                grid[i, range.Left].CellValue = Convert.ChangeType(currentValue, grid[i, range.Left].CellValueType);






                        grid.Binder.DirectSaveCellInfo = false;




Hope this will be helpful for your reference.




Let me know if you have any further concerns.



Ragamathullah B.


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.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

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