开发环境:vs2005
webconfig文件配置如下
<connectionStrings>
<add name="15dataConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=~app_data/15data.mdb"
providerName="System.Data.OleDb" />
</connectionStrings>
页面测试调用代码如下:
Dim strconn As OleDbConnection
strconn = New OleDbConnection(ConfigurationManager.AppSettings("15dataConnectionString"))
strconn.Open()
Dim sql As String
sql = "selset * from thinginfo"
Dim cmd As New OleDbCommand(sql, strconn)
Dim dr As OleDbDataReader = cmd.ExecuteReader
While dr.Read
Response.Write(dr(0))
End While
strconn.Close()
提示信息:
ConnectionString 属性尚未初始化
webconfig文件配置如下
<connectionStrings>
<add name="15dataConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=~app_data/15data.mdb"
providerName="System.Data.OleDb" />
</connectionStrings>
页面测试调用代码如下:
Dim strconn As OleDbConnection
strconn = New OleDbConnection(ConfigurationManager.AppSettings("15dataConnectionString"))
strconn.Open()
Dim sql As String
sql = "selset * from thinginfo"
Dim cmd As New OleDbCommand(sql, strconn)
Dim dr As OleDbDataReader = cmd.ExecuteReader
While dr.Read
Response.Write(dr(0))
End While
strconn.Close()
提示信息:
ConnectionString 属性尚未初始化
strconn = New OleDbConnection(ConfigurationManager.AppSettings["15dataConnectionString"].ToString()
就OK了!
改成
Data Source=|DataDirectory|\15data.mdb
这个应该是本地的完整路径
Response.Write(ConfigurationManager.ConnectionStrings["15dataConnectionString"].ConnectionString);