Click here to Skip to main content
Search within:




Next

How can handle Large Database
Sign Up to vote bad
good
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
Member 9444634586
Add a Solution

Comments
Söderlund - 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 - 31-Jan-13 7:50am
how can u say that, m insert 121k record as of now.......
Söderlund - 31-Jan-13 7:59am
Are you reading it too, or are you just inserting it?
Abhishek Pant - 31-Jan-13 7:49am
Yes,I also Agree with Soderlund
boogac - 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

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

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

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Christian Graus 499
1 Michael Haephrati 390
2 Prasad_Kulkarni 378
3 OriginalGriff 245
4 Sergey Alexandrovich Kryukov 210
0 Sergey Alexandrovich Kryukov 6,959
1 Prasad_Kulkarni 3,679
2 OriginalGriff 3,384
3 _Amy 3,332
4 CPallini 2,925


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