6-22.aspx

来自「这是一个很好的基于数据库的系统」· ASPX 代码 · 共 42 行

<%@ Page Language="C#"%>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
<Form runat="server">
<asp:DataGrid 
      AllowPaging="True"
      PageSize="4"
      PagerStyle-HorizontanAlign="Right"
      PagerStyle-Mode="NumericPages"
      OnPageindexChanged="ChangePage"
      Headerstyle-BackColor="#AAAADD"
      AlternatingItemStyle-BackColor="#FFFFCD" 
      CellPadding="2"
      CellSpacing="0" 
      id="Grid1" runat="server"/>
</Form>
<script runat="server">
int startIndex;
void BindGrid() {
	String Provider,DataBase,ConnStr,SQL;
	Provider = "Microsoft.Jet.OLEDB.4.0;";
	DataBase = Server.MapPath("person.mdb");
	ConnStr = "Provider=" + Provider + "Data Source=" + DataBase;
	OleDbDataAdapter da;
	da = new OleDbDataAdapter("Select * From grade",ConnStr);
	DataSet ds = new DataSet();
	da.Fill(ds,"grade");
	Grid1.DataSource = ds.Tables["grade"].DefaultView;
	Grid1.DataBind();
}
void Page_Load(Object src,EventArgs e)  { 
      if(!IsPostBack) {
            startIndex =0;
               }
      BindGrid();
}
void ChangePage(Object sender, DataGridPageChangedEventArgs e) {    
      Grid1.CurrentPageIndex = e.NewPageIndex;
      BindGrid();
}
 </script>