Slowness of the GridView

Question

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 30000 in about 2months time!! Is there a more efficient way to handle this scenario?

Manikavelu Velayutham · Answer

you should not bind all the 5000 rows in a single datagrid surely it will slow down for binding all the values. Instead implement paging concept in datagrid. Dont use the default paging in dotnet. Use the custom paging concept in your page so that if your page size is 25 only those 25 rows should be transferred from database to frontend. If you find this post useful mark this post as accepted answer.