How to write the access database as a relative path in the cs file of the web application

我漫漫靠近你

How to write the access database as a relative path in the cs file of the web application

The database is placed in the app_Data folder of the project, but ~ / app_Data / xxx.mdb does not recognize it, you must write the absolute path

igogoal

An officially released project does not work with absolute paths. Generally, server.MapPath ("app_Data / xxx.mdb") is used to convert the path. Pay attention to the relationship between the file location of this statement and the directory in ()

cexopuwk80

Add on the <appSettings> node under Web.Config
<add key="AccessConnection" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|Database name.mdb"/>
Read in the program
private static readonly string connectionString=ConfigurationSettings.AppSettings["AccessConnection"].ToString();

ssg871018

string connStr = "Provider=Microsoft.Jet.OleDb.4.0;data source=" + Server.MapPath("~/App_Data//TreeViewDemo.mdb");