index.aspx
<%@ Page Language="C#" %><%@ import Namespace="System.Data" %><%@ import Namespace="System.Data.OleDb" %><script runat="server">
// 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;
}
</script><html><head></head><body> <form method="post" runat="server"> <!-- Insert content here --> </form></body></html>
设为首页
加入收藏
总编信箱
投稿或申请专栏请先 [登 陆]
