求Access 数据库连接字符串、

Question

目前OK的一种方式、<add key="db_ConnectionString" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" />
<add key="db_ConnectionString1" value="\DB\Screson.mdb" />获取时、   /// <summary>
    /// 数据库连接字符串
    ///// </summary>
    public static string DBName = ConfigurationManager.AppSettings.Get("db_ConnectionString1").ToString();    public static string DBDriver = ConfigurationManager.AppSettings.Get("db_ConnectionString").ToString();    public static string conStr = DBDriver +    HttpContext.Current.Server.MapPath(HttpContext.Current.Request.ApplicationPath + "") + DBName;
这个获取方式是在Web层。 现在求 在数据库访问层的 获取方式

Answer 1

ACCESS连接字符串

Answer 2

求的是发布后的连接串、并且是相对路径的、 public static string conStr = DBDriver +    HttpContext.Current.Server.MapPath(HttpContext.Current.Request.ApplicationPath + "") + DBName;就是在 数据层 怎么替换上面这一句的问题、

Answer 3

Access连接字符串大全

Answer 4

http://www.connectionstrings.com/

Answer 5

 <connectionStrings>
    <add name="ydycon" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|ZhongXiangDB.mdb;Jet OLEDB:Database Password=hzzx123456" providerName="System.Data.OleDb" />
  </connectionStrings>

Answer 6

配置文件：
  <appSettings>
    <add key="frist" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="/>
    <add key="second" value="~/data/test.mdb"/>
  </appSettings>程序：
public static string strCon = ConfigurationManager.AppSettings["frist"].ToString() + HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["second"]);

Answer 7

1.<add name="ConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\hoteldatabase.mdb" providerName="System.Data.OleDb" />2.
string datapath = Server.MapPath(@"~\App_Data\Database1.accdb");
OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + datapath);

Answer 8

1.首先要将access数据库放到专门放到App_Data文件夹中
2.在配置文件中增加连接字符串：<add name="ConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\数据库名.mdb" providerName="System.Data.OleDb" />
3.在DBHelper类中调用配置文件中的连接字符串即可;  string  connection=(configerManager.connectionString["connectionString"].connectionString);