App_Data里面放的数据库文件怎么获取啊

Question

我把数据库文件放到里面，可是我通过Server.MapPath(),只能读取到网站的根目录。还请高手指教一下！

Answer 1

web.config  <connectionStrings>
<add name="DataConnection" connectionString="Data Source=IP;Initial Catalog=dataname;uid=sa;pwd=sa"
 providerName="System.Data.SqlClient" />
</connectionStrings>     public static string DbConnStr
        {
            get
            {
                if (!_init)
                {
                    _DbConnStr = ConfigurationManager.ConnectionStrings["DataConnection"].ToString();
                    _DbMaster = ConfigurationManager.ConnectionStrings["MasterDataConnection"].ToString();
                    _init = true;
                }
                return _DbConnStr;
               
               // return "server=" + _dbIP + ";database=" + _dbName + ";User=" + _dbLoginId + ";password=" + _dbPwd + ";Connect Timeout=90;pooling=false";
            }
        }

Answer 2

好像不行吧！这样给你说吧！我做的是网站，用Access数据库！就是直接访问Access数据库！
不过还是谢谢！

Answer 3

<connectionStrings>
<add name="McmConnection" connectionString="provider=Microsoft.Jet.OLEDB.4.0 ; Data Source=|DataDirectory|\MCM.mdb;"/>
</connectionStrings>

Answer 4

然后使用string connectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["McmConnection"].ToString();获取链接字符串

Answer 5

请问|DataDirectory|是自动转换为网站目录还是写死的啊？如果我把项目放到别的地方怎么办？

Answer 6

|DataDirectory| 对应的是app_data文件夹

Answer 7

<connectionStrings>
   <add 
      name="LocalSqlServer" 
      connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" 
      providerName="System.Data.SqlClient"
   />
</connectionStrings>