6-04.aspx

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

<% @ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script runat="server">
void Page_Load(Object sender, EventArgs e) {
   OleDbConnection Conn=new OleDbConnection(); 
   Conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;"+
                       "Data Source="+Server.MapPath("person.mdb");
   Conn.Open();
   OleDbCommand Comm=new OleDbCommand("select * from grade",Conn);
   OleDbDataReader dr=Comm.ExecuteReader();   
   dg.DataSource=dr;
   dg.DataBind();
   Conn.Close();
}
</script>
<asp:DataGrid id="dg" runat="server" />