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 for the prompt response.

Here is very simple sample code I put together that illustrates the problem. Without resetting DataSource it runs for ~8 seconds. When you first set DataSource to null, do your changes and set it back to ultraDataSource it takes less than a second.

//ultraGrid1.DataSource = null;

this.ultraGrid1.BeginUpdate();
this.ultraGrid1.SuspendRowSynchronization();
try
{
    UltraDataRow row = ultraDataSource1.Rows.Add(new object[] { "Data1", "Data2", "Data3", "Data4", "Data5" });
   
    for (int i = 0; i < 30; i++)
    {
        UltraDataBand band = ultraDataSource1.Band.ChildBands.Add(i.ToString());
        //don't know if there is an easier way to inherit parent band's columns
        foreach (UltraDataColumn column in ultraDataSource1.Band.Columns)
            band.Columns.Add(column.Key, column.DataType);

        UltraDataRow row2 = row.GetChildRows(band).Add(new object[] { "BandA", "Data2", "Data3", "Data4", "Data5" });               
    }

    //ultraGrid1.DataSource = ultraDataSource1;
}
finally
{
    this.ultraGrid1.ResumeRowSynchronization();
    this.ultraGrid1.EndUpdate();
}