Hi,

I am calling "grid.UpdateData()" method after modifying data from code behind. It is taking too much time. My code as below:

for (int i = 0; i < grid.Rows.Count; i++)
{
UltraGridRow row = this.Rows[i];
row.Cells[this.ActiveCell.Column].Value = this.ActiveCell.Value;
}

grid.UpdateData();

So here if I am updating 80k records then this for loop takes ~10sec and "grid.UpdateData()" method takes ~80sec.

Is it usual?

Or is there any better way to implement it?

Thanks,

Sunil 

Hi Sunil,

The grid is a user interface control. It's designed for user interaction. So if you are performing a mass update on your data in code, it doesn't make a lot of sense to do it through the grid. You'd be better off modifying your data source directly instead of going through the UI.

Of course, if you do that, the grid will get notifications from the data source, so you probably want to turn those off so the grid doesn't respond to each one individually and slow things down. 

 grid.BeginUpdate();
 grid.SuspendRowSynchronization();
try
 {
     // Loop through the data source and update the data here. 
 }
 finally
 {
     grid.ResumeRowSynchronization();
     grid.EndUpdate(); 
 }