Batch update gridview cells value

[Anu]

is there a way to batch update cell value of a gridview.

I have a situation where i have to loop thru each row and then update one cell value, as shown below. But it becomes really slow when i have large number of records on the grid, so is there any batch update that can be applied. My interface is with a textbox field above the grid and when the user enter text and press apply it has to apply that text to all records on the grid (it could be 100 - 10000 reocords on the grid depending one the search)

foreach (GridViewRowInfo row in radGV_.Rows)
       {
           row.Cells["BName"].Value = txtBName.Text;
       }

[Emanuel Varga]

Hello anu,

Please add a gridView.BeginUpdate() ... gridView.EndUpdate() or

using (gridView.DeferRefresh()
{
       foreach (GridViewRowInfo row in radGV_.Rows)
       {
           row.Cells["BName"].Value = txtBName.Text;
       }
}

Best Regards,
Emanuel Varga

[Alexander]

Hello Anu,

Thank you for the solution, Emanuel.

Indeed, the DeferRefresh method of RadGridView can be used to create a batch update. It should improve the performance of the update operation.

Best regards,
Alexander
the Telerik team