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">
<aspataGrid 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>
</aspataGrid>
</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
<form runat="server">
<aspataGrid 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>
</aspataGrid>
</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