.NET链接Access数据库的方式(总是忘,记一下)

来源:互联网 发布:抽奖算法 奖池 c 编辑:程序博客网 时间:2024/06/05 11:34

链接字符串配置:

<connectionStrings>    <add name="connStr" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" />    <add name="connPath" connectionString="../CusData/db.mdb" /></connectionStrings>

提取拼接:

private string ConnStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;private string ConnPath = HttpContext.Current.Server.MapPath(ConfigurationManager.ConnectionStrings["connPath"].ConnectionString);

连接对象:

OleDbConnection conn = new OleDbConnection(ConnStr + ConnPath);


原创粉丝点击