6-24.aspx

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

<%@ page language="C#"%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script runat="server">
void Page_Load(Object src,EventArgs e) { 
	OleDbConnection Conn;
	Conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;"+
            "Data Source="+Server.MapPath("person.mdb"));
	Conn.Open();
	String strSQL="select * from grade where 学号=" + Request["id"];
	OleDbCommand Comm=new OleDbCommand(strSQL,Conn);
	// 执行ExecuteReader()方法  
	OleDbDataReader dr = Comm.ExecuteReader();

	string html=" ";

	while(dr.Read())  {
		html += "<h1>学员：";
		html += "<font color=red>" +  dr["姓名"].ToString() + "</font>的成绩为：</h1><br>";
		html += "学号为：" +  dr["学号"].ToString() + "<br>";
		html += "数学成绩为：" +  dr["数学"].ToString() + "<br>";
		html += "";
  }
Response.Write(html);
}
</script>