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>
类别: ASP.NET教程 
