adding rows is very slow?

[Louis]

I'm trying to add 40 rows in a grid programmaticly like this :

try
{
this.Cursor = Cursors.WaitCursor;
grdSearchResults.SuspendUpdate();

//remove all filters
foreach (GridViewDataColumn dc in grdSearchResults.MasterGridViewTemplate.Columns)
  dc.Filter.StringValue = string.Empty;

//add new pax to current manifest
for (int i = 0; i < nb; i++)
  paxList.AddNew();

UpdateScreenState();

grdSearchResults.Rows[paxList.Count - nb].IsCurrent = true;
grdSearchResults.Columns[0].IsCurrent = true;
grdSearchResults.GridElement.ScrollToRow(0);
if (grdSearchResults.CurrentCell != null)
  ((GridDataCellElement)grdSearchResults.CurrentCell).BeginEdit();
}
catch (Exception exc)
{
  ExceptionPolicy.HandleException(exc, "Client Policy");
}
finally
{
  this.Cursor = Cursors.Default;
  grdSearchResults.ResumeUpdate();
}

when adding let say 30 rows (nb=30) the grid is extremely slow. Is there something i should do to fasten things up?

I've tried using 

grdSearchResults.GridElement.BeginUpdate();

instead of SuspendUpdate but the grid throws an argument out of range exception stating that Value is out of range???

[Julian Benkov]

Hello Louis ,

You can replace the Suspend/Resume Update functions with the Begin/End Update functions of the RadGridView GridElement.

Please refer to the codeblock below:

try
{
this.Cursor = Cursors.WaitCursor;
grdSearchResults.GridElement.BeginUpdate();

//remove all filters
foreach (GridViewDataColumn dc in grdSearchResults.MasterGridViewTemplate.Columns)
  dc.Filter.StringValue = string.Empty;

//add new pax to current manifest
for (int i = 0; i < nb; i++)
  paxList.AddNew();

UpdateScreenState();

grdSearchResults.Rows[paxList.Count - nb].IsCurrent = true;
grdSearchResults.Columns[0].IsCurrent = true;
grdSearchResults.GridElement.ScrollToRow(0);
if (grdSearchResults.CurrentCell != null)
  ((GridDataCellElement)grdSearchResults.CurrentCell).BeginEdit();
}
catch (Exception exc)
{
  ExceptionPolicy.HandleException(exc, "Client Policy");
}
finally
{
  this.Cursor = Cursors.Default;
  grdSearchResults.GridElement.EndUpdate();
}

I hope this was helpful. If you have any additional questions, please contact us again.

Regards,
Julian Benkov
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Louis]

I've tried what you said but it throws me an exception stating that value is not between minimum and maximum ?? i will open a supprot ticket and paste a picture of the error.

[Dwight]

Hello Louis,

Please, find the answer to your question in the support area.

Regards,
Evtim
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Jared]

Since this post is old I thought I'd add what I did to solve this exact problem.  The .BeginUpdate() / .EndUpdate() calls certainly worked.  But now those methods are on the grid object themselves.  So in the OP's code the two calls would look like this:

grdSearchResults.BeginUpdate();

grdSearchResults.EndUpdate();

This really helped improve performance while I was programmatically creating rows.   

[George]

Hi Jared,

Thank you for providing the community with an update on the specific scenario. Indeed, the Begin/EndUpdate methods are on the control itself and on the MasterTemplate as well:

this.Grid.MasterTemplate.BeginUpdate();
this.Grid.MasterTemplate.EndUpdate();

Regards,
George
Telerik