6-07.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();
   String strSQL="insert into grade (学号,姓名,数学) "+
          "values (99,'小张',100)";
   OleDbCommand Comm=new OleDbCommand(strSQL,Conn);
   Comm.ExecuteNonQuery();   
   Conn.Close();
   Response.Write("操作成功！");
}
</script>