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(); 
 }

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 

Thanks Mike,

8 Bands is a large number when you pull data from joined tables in database - I agree with you on that one, i haven't seen many queries that join more than 8 tables.

When you populate your own UltraDataSource with adhoc data or your data has a recursive relationship you can very easily have very large number of bands. In my application I have a recursive parent/child relationship with many levels of nesting, and each parent level requires creation of a new band.

I guess I'll stick with unbind, populate and bind again approach for now.