asp.net personalized Paging implementation
The pagination we talked about was just a way to implement pagination by modifying the properties of the DataGrid, which has the benefit
, the biggest is simple, hehe, do not have to worry about, pagination is how to produce.
But it is also flawed and does not produce the kinds of styles we want to do as we imagine.
There is no way to personalize the function, only to do it yourself, hehe.
The first step is to import the required namespaces. The following example, in fact, I also found from abroad
, plus some personal stuff, and then Chinese, hehe. The mood is very good today, I even the label color to show everybody
Here it comes. Oh, more conducive to everyone to see the program.
<%@ Page language= "C #"%>
<%@ Import namespace= "System.Data"%>
<%@ Import namespace= "System.Data.SQL"%>
Let's take a look at what our web controls are, and then look at how the code is written, which is better:
<body>
<form runat=server>
<asp:datagrid id= "Mydatagrid" runat= "Server"
Allowpaging= "True"
Pagesize= "10"
Pagerstyle-mode= "NumericPages"
Pagerstyle-horizontalalign= "Right"
Onpageindexchanged= "Mydatagrid_page"
Bordercolor= "BLACK"
Borderwidth= "1"
Gridlines= "Both"
Cellpadding= "3"
cellspacing= "0"
Font-name= "Verdana"
Font-size= "8pt"
Headerstyle-backcolor= "#aaaadd"
Alternatingitemstyle-backcolor= "#eeeeee"
Autogeneratecolumns= "false"
>
<property name= "Columns" >
<asp:boundcolumn headertext= "Studio member" datafield= "enter_id"/>
<asp:boundcolumn headertext= "Landing Time" datafield= "Enter_time"/>
</property>
</ASP:DataGrid>
<p>
<asp:linkbutton id= "Btnfirst" runat= "Server"
text= "Home"
commandargument= "0"
Forecolor= "Navy"
Font-name= "Verdana" font-size= "8pt"
/>
<asp:linkbutton id= "Btnprev" runat= "Server"
text= "front page"
Commandargument= "Prev"
Forecolor= "Navy"
Font-name= "Verdana" font-size= "8pt"
/>
<asp:linkbutton id= "Btnnext" runat= "Server"
text= "Back Page"
Commandargument= "Next"
Forecolor= "Navy"
Font-name= "Verdana" font-size= "8pt"
/>
<asp:linkbutton id= "Btnlast" runat= "Server"
Text= "Last"
Commandargument= "Last"
Forecolor= "Navy"
Font-name= "Verdana" font-size= "8pt"
/>
<p>
<asp:checkbox id= "Chk1" runat= "Server"
Text= "Show built in pages"
Font-name= "Verdana"
Font-size= "8pt"
Autopostback= "true"
/>
<p>
<table bgcolor= "#eeeeee" cellpadding= "6" ><tr><td nowrap><font face= "Verdana"
Size= "-2" >
<asp:label id= "Lblcurrentindex" runat= "Server"/><br>
<asp:label id= "Lblpagecount" runat= "Server"/><br>
</font></td></tr></table>
</form>
</body>
From the example above we can see that clicking the LinkButton control onclick triggers the Pagebuttonclick event,
The DataGrid page onpageindexchanged change triggers the Mydatagrid_page event, and we'll be
Is the code to write these two events
Here is the first query of the database information, expressed in a function, because often used:), I opened the table, uh
Oh, it's our studio Admin login log (and we sold some of our studio secrets to everyone).
ICollection CreateDataSource ()
{
/*
Read the database information and get the DataView
*/
SqlConnection myconnection = new
SqlConnection ("SERVER=LOCALHOST;UID=SA;PWD=123456;DATABASE=ASPCN");
Sqldatasetcommand Mydatasetcommand = new Sqldatasetcommand ("SELECT * FROM
Admin_enter ORDER BY enter_time Desc ", MyConnection);
DataSet ds= new DataSet ();
Mydatasetcommand.filldataset (ds, "Admin_enter");
Return DS. tables["Admin_enter"]. DefaultView;
}
And then there's the Page_Load function, where you're basically deciding whether to show the paging numbers that come with the DataGrid.
, using the Pagestyle Visible property:
void Page_Load (Object sender, EventArgs e)
{
Decide whether to hide Pagerstyle-mode
if (chk1. Checked)
{
Mydatagrid.pagerstyle.visible=true;
}
Else
{
Mydatagrid.pagerstyle.visible=false;
}
Bindgrid ();
}
Here is the Pagerbuttonclick that handles the Click event, this is our core part, in fact we operate only
is the CurrentPageIndex property of the DataGrid. If CurrentPageIndex is less than pagecount then there is a next page
, if CurrentPageIndex is greater than 0, the previous page is represented.
void Pagerbuttonclick (Object sender, EventArgs e)
{
Get the LinkButton parameter value
String arg = ((LinkButton) sender). CommandArgument;
Switch (ARG)
{
Case ("Next"):
if (Mydatagrid.currentpageindex < (mydatagrid.pagecount-1))
Mydatagrid.currentpageindex + +;
Break
Case ("prev"):
if (Mydatagrid.currentpageindex > 0)
Mydatagrid.currentpageindex--;
Break
Case ("Last"):
Mydatagrid.currentpageindex = (mydatagrid.pagecount-1);
Break
Default
Value of this page
Mydatagrid.currentpageindex = arg. ToInt32 ();
Break
}
Bindgrid ();
}
Here is Mydatagrid_page, the main action is to call the Bindgrid function to give the data to the DataGrid display:
void Mydatagrid_page (Object sender, DataGridPageChangedEventArgs e)
{
How to handle numbers
Bindgrid ();
}
Finally there are two functions that they function, which I have commented on:
void Bindgrid ()
{
Bind DataView to the DataGrid
Mydatagrid.datasource = CreateDataSource ();
Mydatagrid.databind ();
Showstats ();
}
void Showstats ()
{
Display page Information
Lblcurrentindex.text = "Current page is:" +
((int) mydatagrid.currentpageindex+1);
Lblpagecount.text = "Total number of pages is:" + mydatagrid.pagecount;
}
So far, our personalized page has been completed (all code and display to see the section), our general thinking on
is to use the LinkButton control as a page-flipping flag, by judging the commandargument value of the LinkButton,
As the CurrentPageIndex property of the DataGrid to achieve the effect of paging.
If you don't understand the structure in this section, see the entire code in the next section and the example.
