在本地连接字符串没问题，但上传之后路径不对，如何获取正确的路径

Question

如题

Answer 1

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
using System.Collections.Generic;using System;
using System.Data;
using System.Configuration;
using System.Collections.Generic;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.IO;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
/// <summary>
/// 对数据库的各种操作
/// </summary>
public class DAO
{
    
    string str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='\\db\\test.mdb'";
    OleDbConnection con;
    OleDbCommand cmd;
public DAO()
{
        con = new OleDbConnection(str);
}
    //增删改的方法
    public int InsertOrDelete(string sql)
    {
        
        int num = 0;
        try
        {
           
            con.Open();
            cmd = new OleDbCommand(sql, con);
            num = cmd.ExecuteNonQuery();
          
        }
        catch (Exception ex)
        {
           // MessageBox.Show("程序运行繁忙，请联系管理员");
        }
        finally
        {
            con.Close();
        }
        return num;
    
    }
    //查询的方法
    public List<object> getShuJU(string sql,List<object> lists,Ijiekou shitilei)
    {        try
        {
            con.Open();
            cmd = new OleDbCommand(sql, con);
            OleDbDataReader datareade = cmd.ExecuteReader();
            while (datareade.Read())
            {
          
                lists.Add(shitilei.getImsg(datareade));
                           
            }
            datareade.Close();
        }
        catch (Exception ex)
        {            throw;
        }
        finally
        {
            con.Close();
        }
        
        return lists;    }}

Answer 2

 原创  Access数据库 连接字符串全解析（Asp.net） 收藏密码：
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|Financing_db.mdb;Persist Security Info=False;Jet OLEDB:Database Password=xxxxxx
用户名和密码：
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|Financing_db.mdb;Persist Security Info=False;User Id=admin;Jet OLEDB:Database Password=xxxxxx通常：
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|Financing_db.mdb
其中:
|DataDirectory|系统被解析到App_Data文件夹下。