6-09.aspx

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

<% @ Page Language="C#" %>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
<Script runat="server">
void Page_Load(Object Src, EventArgs E) { 
  OleDbConnection Conn=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;"+
                    "Data Source="+Server.MapPath("person.mdb"));
   Conn.Open();
   String strSQL="select * from grade";
   OleDbCommand Comm=new OleDbCommand(strSQL,Conn);
   OleDbDataReader dr=Comm.ExecuteReader();
   string html="<Table border=1>";
   html+="<TR>";
   html+="<TD><B>学号</B></TD>";
   html+="<TD><B>姓名</B></TD>";
   html+="<TD><B>数学</B></TD>";
   html+="</TR>";
try{//读出每一条记录
  while(dr.Read())   {
  html+="<TR>";
  html+="<TD>" +  dr["学号"].ToString() + "</TD>";
  html+="<TD>" +  dr["姓名"].ToString() + "</TD>";
  html+="<TD>" +  dr["数学"].ToString() + "</TD>";
  html+="</TR>";
  }
  html+="</Table>";
}
finally{//关闭链接
  dr.Close();
  Conn.Close();
}
  Response.Write(html);
}
</Script>