how to Paging in Asp.net

Question

4.00/5 (1 vote)

See more:

Hi,

I had a very basic doubt.

how to display a one million of data into gridview.

i have idea about the gridview paging,but just doing simply gridview paging will do

work, and every time the network round trip happen to the server.

and i just aware of sql server paging.

how to do ,

My Dear Techies,

Kindly Revert me.

Regards
James

Posted 16-Aug-12 6:08am

jameschowdaree

Add a Solution

4 solutions

Solution 1

You really don't need and should not bring back millions of rows. No one will ever need to see that much data and wouldn't know what to do with it anyway.

Bring back a few hundred rows, at most; perhaps a pre-filtered subset that would be relevant to the user at that point in time. If they need to see more or different records give them a filter (can be quite comprehensive) and they can then pull back the actual records they need to see rather than everything which would take ages and be overwhelming.

There are many different ways to accomplish this functionality so I'll leave it to you to do your research and figure out which method suits your requirement.

Good luck.

Posted 16-Aug-12 6:17am

R. Giskard Reventlov

Comments

jameschowdaree 16-Aug-12 12:28pm

Im Expected This,I got it

R. Giskard Reventlov 16-Aug-12 12:37pm

Paging is not the answer, at least not for millions of records. You can certainly page a few hundred.

Solution 3

hii please refer this

http://www.c-sharpcorner.com/UploadFile/rohatash/gridview-paging-sample-in-Asp-Net/[^]

and

http://msdn.microsoft.com/en-us/library/aa479347.aspx[^]

Posted 16-Aug-12 21:39pm

Ganesh Nikam

Updated 16-Aug-12 21:40pm

v2

Solution 4

See following

paging in gridview in asp.net[^]

Posted 16-Aug-12 21:41pm

Sangramsingh Pawar

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)

jameschowdaree · Accepted Answer · 2012-08-16T07:03:00

after 29 min google found a very easy for this.

using linq is one of solution for this.

Custom Paging in GridView Using LINQ.

C#

public IQueryable BindEmployees(int startRowIndex, int maximumRows)
    {
        EmployeeInfoDataContext dbEmp = new EmployeeInfoDataContext();
        var query = from emp in dbEmp.Employees
                    join dept in dbEmp.Departments
                        on emp.DeptID equals dept.DeptID
                    select new
                    {
                        EmpID = emp.EmpID,
                        EmpName = emp.EmpName,
                        Age = emp.Age,
                        Address = emp.Address,
                        DeptName = dept.DepartmentName
                    };
 
        return query.Skip(startRowIndex).Take(maximumRows);
    }

http://www.codedigest.com/Articles/ASPNET/153_Custom_Paging_for_GridView_using_LINQ.aspx[^]