asp.net Method of Connecting Access via Configuration File

This article provides an example of how asp.net connects Access through a configuration file.Share it for your reference.Specific analysis is as follows:

Here the database blog.mdb is stored in App_In Data

configuration file

<connectionStrings>
// Method 1
<add name="access_conn" connectionString="Provider=Microsoft.Jet.Oledb.4.0;data source="/>
<add name="access_path" connectionString="~/App_Data/blog.mdb"/>
// Method 2
<add name="blogConn" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\\blog.mdb;Persist Security Info=True"/>
</connectionStrings>

Called in cs:

string sConn = "";
// call 1
sConn = ConfigurationManager.ConnectionStrings["access_conn"].ConnectionString
  + HttpContext.Current.Server.MapPath(ConfigurationManager.ConnectionStrings["access_path"].ConnectionString);
// call 2
sConn = ConfigurationManager.ConnectionStrings["blogConn"].ConnectionString;
OleDbConnection conn = new OleDbConnection(sConn);
conn.Open();

I hope that the description in this paper will be helpful to everyone's asp.net program design.