In aspx
<asp:LinkButton ForeColor=”White” ID=”lnkPrev” runat=”server” ><< Previous</asp:LinkButton>
<asp:LinkButton ForeColor=”White” ID=”lnkNext” runat=”server” >Next >></asp:LinkButton>
In code behind
Dim CPage As Integer = 0, pageSize As Integer = 30, totalRec As Integer, totalPages As Integer
On page load event
FillGrid()
Private Sub FillGrid()
If Request(“CP”) = “” Then
CPage = 1
Else
CPage = Convert.ToInt64(Request(“CP”))
End If
If Convert.ToSingle(Request(“CP”)) = “1″ Then
lnkPrev.Visible = False
Else
lnkPrev.Visible = True
End If
Dim dt As DataTable
ViewState(“CPage”) = CPage
dt = PageDesign.selectallbypaging(CPage)
If dt.Rows.Count > 0 Then
totalRec = Convert.ToInt32(dt.Rows(0)(“TR”))
Else
totalRec = 0
End If
If totalRec Mod pageSize = 0 Then
totalPages = totalRec / pageSize
Else
totalPages = (totalRec / pageSize) + 1
End If
If (CPage >= totalPages) Then
lnkNext.Visible = False
Else
lnkNext.Visible = True
End If
grdPage.DataSource = dt
grdPage.DataBind()
End Sub
Protected Sub lnkPrev_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles lnkPrev.Click
Response.Redirect(“DesignPagelist.aspx?CP=” + (ViewState(“CPage”) – 1).ToString())
End Sub
Protected Sub lnkNext_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles lnkNext.Click
Response.Redirect(“DesignPagelist.aspx?CP=” + (ViewState(“CPage”) + 1).ToString())
End Sub
CREATE Proc [dbo].[sp_tbl_PageSelectAll]
– Declare parameters.
@CurrentPage As int,
@PageSize As int
AS
– Turn off count return.
Set NoCount On
– Declare variables.
Declare @FirstRec int
Declare @LastRec int
– Initialize variables.
Set @FirstRec = (@CurrentPage – 1) * @PageSize
Set @LastRec = (@CurrentPage * @PageSize + 1)
– Create a temp table to hold the current page of data
– Add an ID column to count the records
Create Table #TempTable
(
Id int IDENTITY PRIMARY KEY,
[pageid] bigint,
[Pagename] [varchar](400),
[Pagedetails] [ntext],
[pagetitle] [varchar](300)
)
–Fill the temp table with the reminders
Insert Into #TempTable
(
[pageid],
[Pagename],
[Pagedetails],
[pagetitle]
)
SELECT [pageid],
[Pagename],
[Pagedetails],
[pagetitle]
FROM tbl_pageinfo
order by pageid desc
–Select one page of data based on the record numbers above
SELECT [pageid],
[Pagename],
[Pagedetails],
[pagetitle],
(Select Count(*) From tbl_pageinfo) as TR
From
#TempTable As tbl_pageinfo
Where
Id > @FirstRec
And Id < @LastRec
