C#连接数据库时的相对路径

Question

[global::System.Configuration.DefaultSettingValueAttribute("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\新建文件夹\\students.mdb")]//绝对路径

Answer 1

1、配置文件
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
</configSections>
<connectionStrings>
<add name="connString" connectionString="Data Source=|path|\db\database.s3db;Version=3;" providerName="System.Data.SQLite" />
</connectionStrings>
</configuration>
2、实例化时传参，Application.StartupPath返回当前程序运行路径。
DBHelper db = new DBHelper(Application.StartupPath);
3、构造方法
public DBHelper(string dbPath)
{
this.connString = this.connString.Replace("|path|", dbPath);
}