Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# SQL-Server
hi Frnds!!!
 

i developed application in C# ,and Create Database in SQL server - 2008.
 
problem in load windows form.(Form contain DataGrid View for display Record)
 
application is work absolutely fine upto 15000-20000 record, but if data like 120000 - 150000 then Form Load Speed is too slow.
 
In short performance issues while Form Load, How can Handle this issues??? any solution like paging, virtual Mode etc!!!!.
Posted 31-Jan-13 1:39am
Comments
Söderlund at 31-Jan-13 7:44am
   
There is no answer to this because you are not supposed to insert 150k records into a gridview.
No one will read through 150k records so i think you should group your data instead.
Member 9444634 at 31-Jan-13 7:50am
   
how can u say that, m insert 121k record as of now.......
Söderlund at 31-Jan-13 7:59am
   
Are you reading it too, or are you just inserting it?
Abhishek Pant at 31-Jan-13 7:49am
   
Yes,I also Agree with Soderlund
boogac at 31-Jan-13 7:52am
   
yes grouping data must be the answer,i suppose..i am not sure if paging will make it faster anyway ?

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

refer link below to get basic knowledge of implementing paging in datagridview
http://csharp.net-informations.com/datagridview/csharp-datagridview-paging.htm[^]
  Permalink  
Comments
CodeMaster_Noob at 31-Jan-13 7:48am
   
even this link also you can go through
http://www.codeproject.com/Articles/16303/DataGrid-Paging-C-Windows-Forms

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 310
1 Sergey Alexandrovich Kryukov 202
2 Richard MacCutchan 160
3 PhilLenoir 154
4 Sharmanuj 146
0 Sergey Alexandrovich Kryukov 5,999
1 OriginalGriff 5,115
2 CPallini 2,473
3 Richard MacCutchan 1,597
4 Abhinav S 1,505


Advertise | Privacy | Mobile
Web02 | 2.8.140814.1 | Last Updated 31 Jan 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100