一个自定义分页功能的例子:
http://xml.sz.luohuedu.net/xml/ShowDetail.asp?id=B12283DE-DB20-4322-ACCC-12724442808A
http://xml.sz.luohuedu.net/xml/ShowDetail.asp?id=B12283DE-DB20-4322-ACCC-12724442808A
调试欢乐多
<% @ Import Namespace="System.Data" %>
<% @ Import Namespace="System.Data.OleDb" %>
<Script Language="C#" Runat="Server">
OleDbConnection MyConn;
public void Page_Load(Object src,EventArgs e)
{
//连接语句
string MyConnString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+Server.MapPath(".")+"..\\DataBase\\db1.mdb;";
MyConn = new OleDbConnection(MyConnString);
MyConn.Open(); if(!Page.IsPostBack)
{
BindGrid();
}
}
ICollection CreateTable()
{
string strSel = "select * from UserList";
DataSet ds = new DataSet(); OleDbDataAdapter MyAdapter = new OleDbDataAdapter(strSel,MyConn);
MyAdapter.Fill(ds,"Score"); return ds.Tables["Score"].DefaultView;
}
public void BindGrid()
{
DataView dv = (DataView)CreateTable();
usrGrid.VirtualItemCount = dv.Count;
usrGrid.DataSource = dv;
usrGrid.DataBind();
}public void DataGrid_PageChanged(Object sender,DataGridPageChangedEventArgs e)
{
usrGrid.CurrentPageIndex = e.NewPageIndex;
BindGrid();
}
</script>
<html>
<head>
<title></title>
</head>
<body>
<form runat="server">
<center>
<b>演示DataGrid的CustomPaging</b>
<asp:DataGrid id="usrGrid" runat="server"
HeaderStyle-BackColor="#aaaadd"
AlternatingItemStyle-BackColor="#eeeeee"
AutoGenerateColumns="False"
AllowPaging="True"
AllowCustomPaging="True"
PageSize="5"
PagerStyle-Mode="NumericPages"
PagerStyle-HorizontalAlign="Right"
OnPageIndexChanged="DataGrid_PageChanged"
>
<Columns>
<asp:BoundColumn HeaderText="ID号" DataField="id" />
<asp:BoundColumn HeaderText="姓名" DataField="UserName" />
<asp:BoundColumn HeaderText="年龄" DataField="Age" />
<asp:BoundColumn HeaderText="主页" DataField="HomePage" />
<asp:BoundColumn HeaderText="地址" DataField="Address" />
</Columns>
</asp:DataGrid>
</center>
</form>
</body>
</html>