How to add paging option to my datagrid?

liunx

Guest
Hi experts. I want to add paging option to my datagrid.(5 records per page) I be happy if some one help me put pagaing option to my datagrid .Thanks


<form runat="server">

<asp:DataGrid id="DBEditDataGrid" runat="server"
BorderWidth = "1" CellSpacing = "2" CellPadding = "2"
HeaderStyle-Font-Bold = "True"

OnEditCommand = "DBEditDataGrid_Edit"
OnCancelCommand = "DBEditDataGrid_Cancel"
OnUpdateCommand = "DBEditDataGrid_Update"

AutoGenerateColumns = "False"
>
<Columns>

<asp:BoundColumn HeaderText="PLAYERNO" DataField="PLAYERNO" ReadOnly="True" />
<asp:BoundColumn HeaderText="NAME" DataField="NAME" />
<asp:BoundColumn HeaderText="INITIALS" DataField="INITIALS" />
<asp:BoundColumn HeaderText="BIRTH_DATE" DataField="BIRTH_DATE" />
<asp:BoundColumn HeaderText="SEX" DataField="SEX" />
<asp:BoundColumn HeaderText="JOINED" DataField="JOINED" />
<asp:BoundColumn HeaderText="STREET" DataField="STREET" />
<asp:BoundColumn HeaderText="HOUSENO" DataField="HOUSENO" />
<asp:BoundColumn HeaderText="POSTCODE" DataField="POSTCODE" />
<asp:BoundColumn HeaderText="TOWN" DataField="TOWN" />
<asp:BoundColumn HeaderText="PHONENO" DataField="PHONENO" />
<asp:BoundColumn HeaderText="LEAGUENO" DataField="LEAGUENO" />

<asp:EditCommandColumn
HeaderText = "Edit"
EditText = "Edit"
CancelText = "Cancel"
UpdateText = "Update"
/>




<asp:HyperLinkColumn
HeaderText="Penalty"
DataNavigateUrlField="playerno"
DataNavigateUrlFormatString="./penaltyupdate.aspx?person_id={0}"
DataTextField="playerno"
DataTextFormatString="{0:c}"
Target="_blank"/>


<asp:HyperLinkColumn
HeaderText="TEAMS"
DataNavigateUrlField="playerno"
DataNavigateUrlFormatString="./teamsupdate.aspx?person_id={0}"
DataTextField="playerno"
DataTextFormatString="{0:c}"
Target="_blank"/>



<asp:HyperLinkColumn
HeaderText="MATCHES"
DataNavigateUrlField="playerno"
DataNavigateUrlFormatString="./matchesupdate.aspx?person_id={0}"
DataTextField="playerno"
DataTextFormatString="{0:c}"
Target="_blank"/>


<asp:HyperLinkColumn
HeaderText="COMMITTEE_MEMBERS"
DataNavigateUrlField="playerno"
DataNavigateUrlFormatString="./committeeupdate.aspx?person_id={0}"
DataTextField="playerno"
DataTextFormatString="{0:c}"
Target="_blank"/>




</Columns>
</asp:DataGrid>




</form>Scroll Down the Page, there is an example on how to implement paging in a datagrid

<!-- m --><a class="postlink" href="http://samples.gotdotnet.com/quickstart/aspplus/samples/webforms/ctrlref/webctrl/datagrid/doc_datagrid.aspx">http://samples.gotdotnet.com/quickstart ... agrid.aspx</a><!-- m -->

Eric
 
Back
Top