webconfig数据库连接字符串

Question

        private string _AccessConnet;
        protected string AccessConnet
        {
            get { return _AccessConnet; }
        }
        public pweb_AccessConnet()
        {
            _AccessConnet = "Provider = Microsoft.ACE.OLEDB.12.0;Data Source = " + Server.MapPath(ConfigurationManager.AppSettings["Access"]) + ";Persist Security info=False";
        }

Answer 1

<appSettings>
<add key="strConnection" value="server=(suyiming);User ID=suyiming;Password=suyiming;database=suyiming;Connection Reset=FALSE"/>
<add key="Manager" value="admin"/>
</appSettings>

Answer 2

<appSettings>
        <add key="strConnection" value="~/database/abc.mdb"/>
</appSettings>路径
~在asp.net里面就是网站的根路径
Server.MapPath(ConfigurationManager.AppSettings["strConnection"]) 
这样就行了

Answer 3

private string _AccessConnet;
        protected string AccessConnet
        {
            get { return _AccessConnet; }
        }
        public pweb_AccessConnet()
        {
            _AccessConnet = "Provider = Microsoft.ACE.OLEDB.12.0;Data Source = " + Server.MapPath(~/aaa/...)+ ";Persist Security info=False";
        }

Answer 4

用~  .NET独有的寻找路径方式