SQL paging

Question

Hi, What is SQL paging? Please explain with example. Thanks.

Dhaval Patel · Answer

Dear Alok Please refer below link for paging using sql server http://www.c-sharpcorner.com/Blogs/7056/paging-using-sql-query-in-gridviewrepeater.aspx Thanks & Regards Dhaval Patel

Jignesh Trivedi · Answer

hi, SQL paging is crate pagination (load only required data) using SQL server or SQl query. if you use direct query on database using row number() function. for example SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY person) AS rownum, person, income FROM Salaries) AS Salaries1 WHERE rownum >= 5 AND rownum http://www.codeguru.com/csharp/.net/net_data/article.php/c19611 If you use LINQ then use skip and take. (from c in Customers select new { c.City, c.ContactName }).Skip(0).Take(5) http://weblogs.asp.net/rajbk/archive/2009/09/30/linq-to-sql-paging-gotcha.aspx hope this help.

Ankit Shivnakr · Answer

HI Plz refer these link : http://www.codeguru.com/csharp/.net/net_data/article.php/c19611 http://blog.sqlauthority.com/tag/sql-paging/

SQL paging

Answers (3)