ASP.NET 链接数据库基础

index.aspx

1@ Page Language="C#"

1@ import Namespace="System.Data"

1@ import Namespace="System.Data.OleDb"

 1<script runat="server">
 2
 3// Insert page code here   
 4//   
 5void Page_Load(){   
 6string db=@"database/data.mdb ";   
 7string connStr="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source="+Server.MapPath(db)+";"; 
 8
 9string SQLcmd="create table IEB_webs(ID identity primary key,title varchar(255) Default Null)"; 
10
11OleDbConnection conn=new OleDbConnection(connStr);   
12conn.Open();   
13OleDbCommand OleCmd=new OleDbCommand(SQLcmd,conn); 
14
15OleCmd.ExecuteNonQuery(); //执行SQL命令 
16
17Response.Write("数据表建立完成！");   
18} 
19
20conn.Close();   
21conn=null;   
22OleCmd=null; 
23
24  
25} 
26
27</script>

1<html>
2<head>
3</head>
4<body>
5<form method="post" runat="server">
6<!-- Insert content here -->
7</form>
8</body>
9</html>