親密接觸ASP.Net(14)
來源：互聯網
上載者：User
個人化分頁(2)
上一節大家沒有看到總的結構，這一節，我把代碼全部貼出來，大家好好看看。
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SQL" %>
<html>
<script language="C#" runat="server">
void Page_Load(Object sender, EventArgs e)
{
//判斷是否隱藏PagerStyle-Mode
if (chk1.Checked)
{
MyDataGrid.PagerStyle.Visible=true;
}
else
{
MyDataGrid.PagerStyle.Visible=false;
}
BindGrid();
}
ICollection CreateDataSource()
{
/*
讀取資料庫的資訊，獲得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;
}
void PagerButtonClick(Object sender, EventArgs e)
{
//獲得LinkButton的參數值
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:
//本頁值
MyDataGrid.CurrentPageIndex = arg.ToInt32();
