index.ASPx
<%@ Page Language="C#" %><%@ import Namespace="System.Data" %><%@ import Namespace="System.Data.OleDb" %>
??? // Insert page code here??? //??? void Page_Load(){??????? string db=@"database/data.mdb";??????? string connStr="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source="+Server.MapPath(db)+";";
??????? string SQLcmd="create table IEB_webs(ID identity primary key,title varchar(255) Default Null)";
??????? OleDbConnection conn=new OleDbConnection(connStr);??????? conn.Open();??????? OleDbCommand OleCmd=new OleDbCommand(SQLcmd,conn);
??????? OleCmd.ExecuteNonQuery();????? //执行SQL命令
??????? Response.Write("数据表建立完成!");??????? }
??????? conn.Close();??????? conn=null;??????? OleCmd=null;
??? }
?