How can handle Large Database

Question

0.00/5 (No votes)

See more:

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 9444634

Add a Solution

Comments

Per 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.......

Per 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

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Ksh_Sr · Answer 1 · 2013-01-31T01:43:00

Solution 1

refer link below to get basic knowledge of implementing paging in datagridview
http://csharp.net-informations.com/datagridview/csharp-datagridview-paging.htm[^]

Posted 31-Jan-13 1:43am

Ksh_Sr

Comments

[no name] 31-Jan-13 7:48am

even this link also you can go through
http://www.codeproject.com/Articles/16303/DataGrid-Paging-C-Windows-Forms