In ASPX page, create datagrid and set settings as allowpaging =true and pagerstyle-pagebutton count =25 and pagesize =20
<asp:DataGrid id="dg" HeaderStyle-Font-Bold="True" runat="Server" AutoGenerateColumns="False"
AllowSorting="True" BorderColor="#88AABB" CellSpacing="0" CellPadding="0"
GridLines="Both" AllowPaging="True" PagerStyle-PageButtonCount="25" PageSize="20" Width=98%>
<HeaderStyle BackColor="SteelBlue" HorizontalAlign=Left Font-Bold="True"/>
<PagerStyle HorizontalAlign="Center" Mode="NumericPages"/>
<ItemStyle HorizontalAlign=Left/>
<Columns>
<asp:BoundColumn SortExpression="DBField1" DataField="DBField1" HeaderText="Header1"/>
<asp:BoundColumn SortExpression="DBField2" DataField="DBField2" HeaderText="Header2"/>
</Columns>
</asp:DataGrid>
and in code behind write like this
Protected Sub dg_PageIndexChanged(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridPageChangedEvent Args) Handles dg.PageIndexChanged
Try
dg.CurrentPageIndex = e.NewPageIndex
callyourfunctiontogetDBrecords()
Catch ex As Exception
End Try
End Sub
|