当前位置:Gxlcms > mysql > 使用ACCESS数据库,连接字符串的配置

使用ACCESS数据库,连接字符串的配置

时间:2021-07-01 10:21:17 帮助过:84人阅读

Example of ASP.Net 2.0 Access Database Connection String connectionStrings add name ="accessConnStr" connectionString ="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=|DataDirectory|ajTravelDB.mdb" providerName ="System.Data.OleDb" / / connec

Example of ASP.Net 2.0 Access Database Connection String

<connectionStrings>
<add name="accessConnStr" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source= |DataDirectory|ajTravelDB.mdb" providerName="System.Data.OleDb"/>
connectionStrings>


name
attribute of connectionstrings add element contains the name as accessConStr for the connection string.

connectionString attribute contains the connection string format supported by Oledb drivers. |DataDirectory| is used in the above of connection string to connect the MS Access Database placed inside the App_Data directory. By Default |DataDirectory| maps the path of database file placed inside the default App_Data directory. After |DataDirectory| add up the name of MS Access Database filename as shown in above example.

providerName attribute contains the name of the Namespace of ASP.Net 2.0 that will provide the methods and functions for Data Access while coding.

人气教程排行