In my winforms app, i have a datagridview that takes about 0.8 seconds to be populated with +/- 5000rows - if all columns are textbox columns.
One of the columns is an integer column, so I decided to change that column to an ImageColumn and in the Cell_formatting event of the grid.
It works. However, the datagridview now takes almost 5 seconds to populate itself!! and sorting columns just becomes too time consuming. 5 seconds now may not seem like a lot, but the rows will grow to about 30,000 in about 2months time!!
Is there a more efficient way to handle this scenario?