ASP.Net網絡數據庫：連接到數據庫

 private void Page_Load(object sender, System.EventArgs e)
    { 
        if(!Page.IsPostBack) 
        { 
            ConnectAccessDB();           //連接到MyFirstAccessDb數據庫 
        }
    }
    private void ConnectAccessDB()
    {             //設置訪問數據庫的連接字符串 
        string accessString = ACCESSCONNECTIONSTRING 
        + Server.MapPath("MyFirstAccessDB.mdb"); 
        OleDbConnection accessConn = new OleDbConnection(accessString); 
        try 
        { 
            accessConn.Open();             //打開OLEDB數據庫的連接 
            Response.Write("連接MyFirstAccessDB數據源成功�。�！"); 
            //顯示連接成功信息 
            Response.Write("<br>OLEDB數據庫連接的連接字符串：" 
            + accessConn.ConnectionString); 
            Response.Write("<br>OLEDB數據庫連接的數據庫名稱：" 
            + accessConn.Database); 
            Response.Write("<br>OLEDB數據庫連接的數據源：" 
            + accessConn.DataSource); 
            Response.Write("<br>OLEDB數據庫連接的數據庫驅動：" 
            + accessConn.Provider); 
            Response.Write("<br>OLEDB數據庫連接的服務器版本：" 
            + accessConn.ServerVersion); 
            Response.Write("<br>OLEDB數據庫連接的打開狀態：" 
            + accessConn.State.ToString()); 
            //執行數據庫的操作，如選擇、插入、刪除和更新等 
            accessConn.Close();            //關閉OLEDB數據庫的連接 
            Response.Write("<br><br>OLEDB數據庫連接的關閉狀態：" 
            + accessConn.State.ToString()); 
        } 
        catch(Exception ex) 
        { 
            Response.Write(ex.Message);   //拋出數據庫連接異常 
        }
    }

    設置頁面ConnectedAcDB.aspx為應用程序的起始頁面。按F5鍵運行后，出現如圖1-8所示的初始界面。

文章來源于領測軟件測試網 http://www.kjueaiud.com/