6-21.aspx

这是一个很好的基于数据库的系统

<%@ Page Language="C#"%>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
<Form runat="server">
 <asp:DataGrid 
      AllowPaging="True"
      PageSize="3"
      PagerStyle-HorizontanAlign="Right"
      PagerStyle-NextPageText="后页"
      PagerStyle-PrevPageText="前页"
      OnPageindexChanged="ChangePage"
      Headerstyle-BackColor="#AAAADD"
      AlternatingItemStyle-BackColor="#FFFFCD" 
      BorderColor="Black"
      CellPadding="2"
      CellSpacing="0" 
      id="dg" 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");
		dg.DataSource=ds.Tables["grade"].DefaultView;
		dg.DataBind();
  }
void Page_Load(Object src,EventArgs e)  { 
	if(!IsPostBack) {
		startIndex = 0;
	}
	BindGrid();
}
void ChangePage(Object sender, DataGridPageChangedEventArgs e)   {    
	dg.CurrentPageIndex = e.NewPageIndex;
	BindGrid();
}
 </script>