ASP.Net網絡數據庫：修改數據庫[2]

    ——此文章摘自《ASPNET網絡數據庫開發實例精解》定價￥ 特價￥ 詳細>>

    ．設計訪問數據庫的連接字符串

    把頁面UpdateDataaspx訪問數據庫的連接字符串存放在應用程序的配置文件webconfig中程序代碼如下
    <appSettings>
    <add key=ACCESSCONNECTIONSTRING
    value=Provider=MicrosoftJetOLEDB; Data Source=>
    </add>
    </appSettings>

    由於頁面ShowDataaspx獲取連接字符串時需要使用類ConfigurationSettings它被包含在名字空間SystemConfiguration中因此需要引入該名字空間頁面獲取連接字符串的程序代碼如下
    using SystemConfiguration;                  //引入名字空間
    //獲取連接字符串
    private readonly string ACCESSCONNECTIONSTRING
    =ConfigurationSettingsAppSettings[
    ACCESSCONNECTIONSTRING]ToString();

    ．設計頁面UpdateDataaspx的事件和函數

    頁面UpdateDataaspx調用函數Page_Load(Object senderSystemEventArgs e)初始化該函數調用函數ShowDBData()顯示數據庫MyFirstAccessDB的表MyDataTable中的數據顯示的格式為表中的字段排列順序同時還顯示連接信息函數Page_Load(object sender SystemEventArgs e)和函數ShowDBData()的程序代碼如下
    private void Page_Load(object sender SystemEventArgs e)
    { 
        if(!PageIsPostBack) 
        { 
            ShowDBData();                       //顯示數據庫MyFirstAccessDB中的數據 
        }
    }
    private void ShowDBData()
    {        //設在訪問數據庫的連接字符串 
        string accessString = ACCESSCONNECTIONSTRING 
        + ServerMapPath(MyFirstAccessDBmdb); 
        string cmdText = SELECT * FROM MyDataTable;   //創建獲取數據的SQL語句 
        //創建數據庫的連接和Command 
        OleDbConnection accessConn = new OleDbConnection(accessString); 
        OleDbCommand accessComm = new OleDbCommand(cmdTextaccessConn); 
        //定義數據顯示的格式 
        string dataString = <br>MyID  MyName  MyType  My Length<br>; 

[]  []  []  []  

From:http://tw.wingwit.com/Article/program/net/201311/15130.html