SQL paging

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        

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 <= 9

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.

HI

Plz refer these link :

http://www.codeguru.com/csharp/.net/net_data/article.php/c19611

http://blog.sqlauthority.com/tag/sql-paging/