原理:在WEB.CONFIG中的键值放上我们的数据库路径!!!!
asp 中conn.inc存放我们网站数据库的路径,在ASP.NET中的现实方法:
制作方法:
1.普通方法在控件中建OLECONNECTION的数据
2.控件OLECONNECTION-->属性-->DYNAMICPROPERTIES--?CONNECTIONSTRING-->勾选即可
以后用的方法:
控件OLECONNECTION-->属性-->DYNAMICPROPERTIES--?CONNECTIONSTRING-->勾选即可
====================
以下是存放在WEB.CONFIG的键前和不存放的代码比较
#Region " Web 窗体设计器生成的代码 "
'该调用是 Web 窗体设计器所必需的。
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
Dim configurationAppSettings As System.Configuration.AppSettingsReader = New System.Configuration.AppSettingsReader
Me.OleDbConnection1 = New System.Data.OleDb.OleDbConnection
'
'OleDbConnection1
'
Me.OleDbConnection1.ConnectionString = CType(configurationAppSettings.GetValue("OleDbConnection1.ConnectionString", GetType(System.String)), String)
End Sub
============================================================
#Region " Web 窗体设计器生成的代码 "
'该调用是 Web 窗体设计器所必需的。
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
Me.OleDbConnection1 = New System.Data.OleDb.OleDbConnection
'
'OleDbConnection1
'
Me.OleDbConnection1.ConnectionString = "Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database L" & _
"ocking Mode=1;Jet OLEDB:Database Password=;Data Source=""C:/Inetpub/wwwroot/WebAp" & _
"plication1/data/Database.mdb"";Password=;Jet OLEDB:Engine Type=5;Jet OLEDB:Global" & _
" Bulk Transactions=1;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System databas" & _
"e=;Jet OLEDB:SFP=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:New D" & _
"atabase Password=;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Lo" & _
"cale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Adm" & _
"in;Jet OLEDB:Encrypt Database=False"
End Sub