Loading data to Gridview

Question

0.00/5 (No votes)

See more:

Hi Friends,

I am loading more than 20K data in Gridview and JQuery filter and sorting options applied to gridview.
SQL Query returns the values in 1.sec.
But to load the data to gridview it is taking more time.

Now i am loading 1000 per load and displaying and reloading next set by again firing the query.

Kindly guide me to display all the records at one time in Gridview.

Posted 22-Jul-14 20:56pm

Arunprasath Natarajan

Add a Solution

Comments

Thanks7872 23-Jul-14 3:06am

There is no magic way to improve the speed. It will take time to load all the data. Further, it makes no sense to show 20K data at a time.

Arunprasath Natarajan 23-Jul-14 3:11am

Agreed, but it is our clients requirement.

Thanks7872 23-Jul-14 3:14am

That doesn't mean that its possible. Its by design.

Kornfeld Eliyahu Peter 23-Jul-14 3:50am

Can't be - client may want a grid that enables him to see 20K records, but that does not means that you have to send all it to the client...

nilesh sawardekar 23-Jul-14 4:08am

did you tried to load listview instead of grid...

2 solutions

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)

_Amy · Answer 1 · 2014-07-22T22:38:00

Solution 1

You should try Load on demand data in GridView on scroll using ASP.Net and jQuery AJAX[^]

--Amy

Posted 22-Jul-14 22:38pm

_Amy

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 2 · 2014-07-22T22:50:00

Solution 2

I would suggest you to go for Custom Paging. This would fetch only the number of rows per page, not all the rows.

See - Custom Paging in ASP.Net GridView using SQL Server Stored Procedure[^].

Posted 22-Jul-14 22:50pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)