Filling data in datagridview in vs2005 with windows develpment
Home > IT Answers > Development > Filling data in datagridview in vs2005 with w...
Visualpro
5 pts.
0
Q:
Filling data in datagridview in vs2005 with windows develpment
VB.NET 2005, VB.NET, DataGridView, Visual Studio 2005, SQL Server 2008
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.
ASKED: Aug 1 2009  6:56 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Visualpro
5 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Last Answered: Aug 1 2009  6:56 AM GMT by Visualpro   5 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Carlosdl   29820 pts.  |   Aug 10 2009  7:11PM GMT

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,

 
0