6-19.aspx

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

<%@ Page Language="C#"%>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
<Form runat="server">
<asp:DataList id="dl" runat="server"
      RepeatDirection="Horizontal"
      RepeatColumns="3">
      <ItemTemplate>
      <B><%#DataBinder.Eval(Container.DataItem, "姓名") %>
      (<%#DataBinder.Eval(Container.DataItem, "学号") %>)</B>
      数学成绩：<%#DataBinder.Eval(Container.DataItem, "数学") %>,
      </ItemTemplate>
 </asp:DataList>
 </Form>
 <script runat="server">
	void Page_Load(Object src,EventArgs e) {
	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();
   }
 </script>