萌小希

导航

ASP.NET+Access数据库

       string tablenamesql = "SELECT tablename FROM dbo.updateAccess WHERE URL='"+url+"'";
        DataTable tablenamedata = ClsCommon.getDataTable(tablenamesql);
        string tablename = tablenamedata.Rows[0][0].ToString();
        //声明access中的数据引擎
        string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
        //数据源的位置
        strConnection += @"Data Source=" + Server.MapPath("~/PO/Access1/" + url + "") + "";
      
        //建立连接
        OleDbConnection objConnection = new OleDbConnection(strConnection);
      
        //打开数据连接
        objConnection.Open();

posted on 2014-02-25 11:46  萌小希  阅读(416)  评论(0编辑  收藏  举报