先看一下Access的連接配接資料庫并打開:
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuAjNhVTMlhzMzImMwQ2NjJmM1QWMkdTNlNTZllzMzYTYfdWbp9CXt92Yu4GZjlGbh5SZslmZxl3Lc9CX6MHc0RHaiojIsJye.gif)
string strConnection="Provider=Microsoft.Jet.OleDb.4.0;Data Source=";
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuAjNhVTMlhzMzImMwQ2NjJmM1QWMkdTNlNTZllzMzYTYfdWbp9CXt92Yu4GZjlGbh5SZslmZxl3Lc9CX6MHc0RHaiojIsJye.gif)
strConnection+=Server.MapPath("*.mdb"); //*就是資料庫的名字
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuAjNhVTMlhzMzImMwQ2NjJmM1QWMkdTNlNTZllzMzYTYfdWbp9CXt92Yu4GZjlGbh5SZslmZxl3Lc9CX6MHc0RHaiojIsJye.gif)
OleDbConnection objConnection=new OleDbConnection(strConnection);
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuAjNhVTMlhzMzImMwQ2NjJmM1QWMkdTNlNTZllzMzYTYfdWbp9CXt92Yu4GZjlGbh5SZslmZxl3Lc9CX6MHc0RHaiojIsJye.gif)
objConnection.Open();
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuAjNhVTMlhzMzImMwQ2NjJmM1QWMkdTNlNTZllzMzYTYfdWbp9CXt92Yu4GZjlGbh5SZslmZxl3Lc9CX6MHc0RHaiojIsJye.gif)
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuAjNhVTMlhzMzImMwQ2NjJmM1QWMkdTNlNTZllzMzYTYfdWbp9CXt92Yu4GZjlGbh5SZslmZxl3Lc9CX6MHc0RHaiojIsJye.gif)
dim objConnection as OleDbConnection
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuAjNhVTMlhzMzImMwQ2NjJmM1QWMkdTNlNTZllzMzYTYfdWbp9CXt92Yu4GZjlGbh5SZslmZxl3Lc9CX6MHc0RHaiojIsJye.gif)
objConnection=new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source="+Server.MapPath("*.mdb"))
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuAjNhVTMlhzMzImMwQ2NjJmM1QWMkdTNlNTZllzMzYTYfdWbp9CXt92Yu4GZjlGbh5SZslmZxl3Lc9CX6MHc0RHaiojIsJye.gif)
objConnection.Open()
下面再看一下SQL SERVER的連接配接資料庫并打開:
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuAjNhVTMlhzMzImMwQ2NjJmM1QWMkdTNlNTZllzMzYTYfdWbp9CXt92Yu4GZjlGbh5SZslmZxl3Lc9CX6MHc0RHaiojIsJye.gif)
string strConnection="server=資料庫連接配接;uid=使用者名;pwd=密碼;database=資料庫名字";
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuAjNhVTMlhzMzImMwQ2NjJmM1QWMkdTNlNTZllzMzYTYfdWbp9CXt92Yu4GZjlGbh5SZslmZxl3Lc9CX6MHc0RHaiojIsJye.gif)
SqlConnediob objConnection=new SqlCOnnection(strConnection);
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuAjNhVTMlhzMzImMwQ2NjJmM1QWMkdTNlNTZllzMzYTYfdWbp9CXt92Yu4GZjlGbh5SZslmZxl3Lc9CX6MHc0RHaiojIsJye.gif)
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuAjNhVTMlhzMzImMwQ2NjJmM1QWMkdTNlNTZllzMzYTYfdWbp9CXt92Yu4GZjlGbh5SZslmZxl3Lc9CX6MHc0RHaiojIsJye.gif)
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuAjNhVTMlhzMzImMwQ2NjJmM1QWMkdTNlNTZllzMzYTYfdWbp9CXt92Yu4GZjlGbh5SZslmZxl3Lc9CX6MHc0RHaiojIsJye.gif)
dim objConnection as SqlConnectiom
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuAjNhVTMlhzMzImMwQ2NjJmM1QWMkdTNlNTZllzMzYTYfdWbp9CXt92Yu4GZjlGbh5SZslmZxl3Lc9CX6MHc0RHaiojIsJye.gif)
objConnection=new SqlConnection("server=資料庫連接配接;uid=使用者名;pwd=密碼;database=資料庫名字")
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuAjNhVTMlhzMzImMwQ2NjJmM1QWMkdTNlNTZllzMzYTYfdWbp9CXt92Yu4GZjlGbh5SZslmZxl3Lc9CX6MHc0RHaiojIsJye.gif)
objConnection.Open()
實際上,在大多數地方SQL SERVER和ACCESS的差別除了連接配接語句,其他定義語句也就是SQL××和OLEDB××的差別
另外,如果是ACCESS資料庫的話在ASPX檔案的開頭需要包括下列語句:
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
如果是SQL SERVER則需要包括以下語句:
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.SqlClient"%>