6-23.aspx

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

<%@ Page Language="C#"%>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
<Form runat="server">
<asp:DataGrid 
      AllowPaging="True"
      PageSize="5"
      PagerStyle-HorizontanAlign="Right"
      PagerStyle-Mode="NumericPages"
      OnPageindexChanged="ChangePage"
      Headerstyle-BackColor="#AAAADD"
      AlternatingItemStyle-BackColor="#FFFFCD" 
      BorderColor="Black"
      CellPadding="2"
      CellSpacing="0" 
      AutoGenerateColumns="false"
      id="dg" runat="server">
      <Columns>
        <asp:HyperLinkColumn DataTextField="学号" 
             HeaderText="学号"
             DataNavigateUrlField="学号"
             DataNavigateUrlFormatString="6-24.aspx?id={0}"
             Target="_blank" />
        <asp:BoundColumn DataField="姓名" HeaderText="姓名" />
        <asp:BoundColumn DataField="数学" HeaderText="数学成绩" 
             ItemStyle-HorizontalAlign="right"/>
          </Columns>
</asp:DataGrid>
 </Form></body></html>
<script language="C#" 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>