How to get 10 results only in listview with datapager

Question

0.00/5 (No votes)

See more:

I have a listview with datapager with page size 10 in which i list data from DB.I have noticed when using data pager entire result from the table are taken by query and it slow downs the system.How can i achieve to get only first 10 result from db and then using paging next 10 results etc.Please help

Posted 7-Oct-14 2:11am

Namith Krishnan E

Add a Solution

Comments

[no name] 7-Oct-14 8:17am

You write a query to get the first 10 based on whatever criteria you have available in your database, then you would query the next 10 based on the same criteria, etc.

Namith Krishnan E 7-Oct-14 8:20am

then how can i create paging?

[no name] 7-Oct-14 8:49am

What does that have to do with your question? You already have paging you just didn't like it for some reason.

Namith Krishnan E 9-Oct-14 3:01am

i have paging and working file.But the problem is with the performance.when the listview loads it takes a lot of time because of large amount of data.when using data pager it takes all the result from table and display first 10 instead of this i only want first 10 result totake from db

Richard Deeming 7-Oct-14 8:29am

Are you using the <asp:SqlDataSource> control to bind your data? That control doesn't support paging. You'll need to use an <ObjectDataSource>, an <EntityFrameworkDataSource>, or ASP.NET 4.5's model binding.

Namith Krishnan E 9-Oct-14 2:58am

iam using data table for binding listview

2 solutions

Solution 1

To get only first 6 records use the top-n analysis query.

SELECT TOP 6 column FROM tablename

Posted 7-Oct-14 18:08pm

MukeshSagar

Comments

Namith Krishnan E 9-Oct-14 3:02am

i want paging too,if i take top 6 i didnt get the next results in paging

MukeshSagar 9-Oct-14 3:14am

Use the PageIndexChanged event and rebind the control

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)

Bhavik_Patel · Accepted Answer · 2014-10-07T20:29:00

Solution 2

Hey , you can take a look at
Effective paging with List View control in ASP.NET[^]
this article may help you.

Posted 7-Oct-14 20:29pm

Bhavik_Patel

Comments

Namith Krishnan E 9-Oct-14 3:12am

By looking at this code i think this one iam looking for

5*