used this query in asp.net for pagination?
DECLARE @PageNumber AS INT, @RowspPage AS INT
SET @PageNumber = 4
SET @RowspPage = 500
SELECT [Id]
,[Name]
,[UserName]
,[Password]
,[Gender]
,[Age]
,[Address]
FROM [Regdb].[dbo].[TblReg]
ORDER BY [Id]
OFFSET ((@PageNumber - 1) * @RowspPage) ROWS
FETCH NEXT @RowspPage ROWS ONLY;
And my asp.net select query is that,
System.Data.SqlClient.SqlDataAdapter ad = new System.Data.SqlClient.SqlDataAdapter("select top ("+ PAGESIZE + ") * from TblReg ", con);
Prakash KumarPosted Oct 31, 2016, 2:20 AM
Salman BegPosted Oct 27, 2016, 1:33 AM