5 pts.
 Filling data in datagridview in vs2005 with windows develpment
HI all I have a more than 80000 data in sql server 2008 in a single table. Then i have to show that data in datagridview. But the performance has very slow some time my machine hang. It has taking several minute. So i have to improve this performance could anybody help me. For information i am using dataset for filling data in datagridview.

Software/Hardware used:
ASKED: August 1, 2009  6:56 AM
UPDATED: August 10, 2009  7:11 PM

Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

How about using some type of pagination ?
If you are keeping all rows in memory, it can for sure affect performance.

A google search would return many examples on implementing pagination with VS2005.

Regards,

 63,535 pts.