6-20.aspx

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

<%@ Page Language="C#"%>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
<Form runat="server">
<asp:DataList id="dl" runat="server"
     Border="1" BorderColor="Black"
     CellPadding="2" CellSpacing="0"
     HeaderStyle-BackColor="#aaaadd"
     AlternatingItemStyle-BackColor="lightgray"
     SelectedItemStyle-BackColor="yellow" 
     OnItemCommand="DataList_ItemCommand" >
   <HeaderTemplate>
    姓名(学号)
   </HeaderTemplate>
   <ItemTemplate>
    <%# DataBinder.Eval(Container.DataItem, "姓名")%>
    (<%# DataBinder.Eval(Container.DataItem, "学号")%>)
    <asp:LinkButton id="Detail" runat="server" Text="成绩查询"/>
   </ItemTemplate>
   <SelectedItemTemplate>
    姓名: <%# DataBinder.Eval(Container.DataItem, "姓名")%><BR>
    学号: <%# DataBinder.Eval(Container.DataItem, "学号")%><BR>
    数学成绩: <%# DataBinder.Eval(Container.DataItem, "数学")%><BR>
    <asp:LinkButton id="Title" runat="server" Text="关闭查询"/>
   </SelectedItemTemplate>
  </asp:DataList>
 </Form>
<script runat="server">
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 Comm;
     Comm = new OleDbDataAdapter("Select * From grade",ConnStr);
     DataSet ds = new DataSet();
     Comm.Fill(ds,"grade");
     dl.DataSource = ds.Tables["grade"].DefaultView;
     dl.DataBind();
}
void Page_Load(Object src,EventArgs e)  { 
     BindGrid();
}
void DataList_ItemCommand(Object sender, DataListCommandEventArgs e){
	if (((LinkButton)e.CommandSource).Text == "成绩查询")  {
          dl.SelectedIndex = e.Item.ItemIndex;
	}
	else if (((LinkButton)e.CommandSource).Text == "关闭查询") {
		dl.SelectedIndex = -1;
	}
	BindGrid();
}
</script>