Freelancer logo
Log In Sign Up
Post a Project

EXPLORE

.NET AJAX Project Management SEO SQL
Profile cover photo
User Avatar

Shibin L.

@shibin4m

0.0
0

0.0

0.0

0%

I am software engineer with 3+ years of experience in web application development using asp.net and

$5 USD / Hour

・

Flag of

India (9:13 AM)

・

Joined on June 13, 2012

$5 USD / Hour

・

I am software engineer with 3+ years of experience in web application development using asp.net and sql server,ajax,javascript and other latest technologies.I am familiar with latest web technologies

Verifications

Freelancer .NET Developers India
See all .NET Developers in India

Portfolio

Portfolio

270622
In this article I'll describe how to implement Custom Paging in ASP.Net GridView control. Require for Custom Pagination ASP.Net GridView fetches all the records and then displays one page from the fetched records. Thus for illustration if your table has 1000 records and you want to display only 50 records per page, GridView will fetch all 1000 records throw away the 950 records and display the 50 records based on the page index selected by the users. In Stored Procedure SQL Server 2005 came up with the new ROW_NUMBER() keyword that allows us to give row numbers to the records that we select from the table. Using this row number we can apply our custom pagination logic within the SQL Server Stored Procedure. I am using the Customers table Microsoft's NorthWind Database for this article and below is the Stored Procedure that allows us to fetch records page wise.

Custom Paging in ASP.Net GridView using SQL Server Stored Pr

270622
In this article I'll describe how to implement Custom Paging in ASP.Net GridView control. Require for Custom Pagination ASP.Net GridView fetches all the records and then displays one page from the fetched records. Thus for illustration if your table has 1000 records and you want to display only 50 records per page, GridView will fetch all 1000 records throw away the 950 records and display the 50 records based on the page index selected by the users. In Stored Procedure SQL Server 2005 came up with the new ROW_NUMBER() keyword that allows us to give row numbers to the records that we select from the table. Using this row number we can apply our custom pagination logic within the SQL Server Stored Procedure. I am using the Customers table Microsoft's NorthWind Database for this article and below is the Stored Procedure that allows us to fetch records page wise.

Custom Paging in ASP.Net GridView using SQL Server Stored Pr

Reviews
0 Reviews

No reviews to see here!

Experience

software engineer

Dec, 2011 - Present

•

14 years, 7 months

SBN technologics

Dec, 2011 - Present

•

14 years, 7 months

Dec, 2011 - Present

•

14 years, 7 months

software developer

Feb, 2010 - Nov, 2011

•

1 year, 9 months

wairs

Feb, 2010 - Nov, 2011

•

1 year, 9 months

Feb, 2010 - Nov, 2011

•

1 year, 9 months

Education

Cochin University of Science and Technology

2005 - 2009

•

4 years

B.Tech

Flag of

India

2005 - 2009

•

4 years

Qualifications

ASP.NET

2009

QUEST

2009

Publications

Dot net sql tips

http://dotnetsqltips.blogspot.in/

Freelancer logo US (International) / English
Help & Support

Freelancer

Categories Projects Contests Freelancers Enterprise Innovation Challenges AI Development Membership Preferred Freelancer Program Project Management Local Jobs Photo Anywhere Showcase API for Developers Get Verified

About

About us How it Works Security Investor Sitemap Stories News Team Awards Press Releases Careers

Terms

Privacy Policy Terms and Conditions Copyright Policy Code of Conduct Fees and Charges

Partners

Escrow.com Loadshift Warrior Forum

Apps

Apple App Store logoGoogle Play logo

Registered Users

Total Jobs Posted

Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)

Copyright © 2026 Freelancer Technology Pty Limited (ACN 142 189 759)