Another tip to speed up DataGridView

Steve — Sun, 06 May 2007 10:15:44 -0700

In unbound (non-Virtual) mode it's much faster to add all the rows at the beginning and then fill the cells than it is to add the rows one at a time inside the filling loop.

e.g.

Rather than:

MaxRows = 10000
For i = 0 to MaxRows - 1
  dgv.Rows.Add()
  dgv.Rows(i).Cells(0) = "Some Data"
  dgv.Rows(i).Cells(1) = "Some More Data"
Next i

Use:

MaxRows = 10000
dgv.Rows.Add(MaxRows)
For i = 0 to MaxRows - 1
  dgv.Row(i).Cells(0) = "Some Data"
  dgv.Row(i).Cells(1) = "Some More Data"
Next i

Quick Fixes for SLOW DataGridView

Daniel Read — Wed, 07 Feb 2007 12:58:55 -0800

After learning that you really don't want to try using the DataGridView in unbound mode (just get your data into a DataTable and let binding do the heavy lifting--binding doesn't suck anymore!), I had to next learn that the DataGridView can be really, really slow after you get more than a trivial amount of data in it. Here are a few tips.

developer.* Blogs - Quick Fixes for SLOW DataGridView - Comments

Another tip to speed up DataGridView

Quick Fixes for SLOW DataGridView