数据库连接字在Web.config里的用法
2003-01-15 09:37:32
在asp.net中的WEB程序的设置中我们必须用到Web.config来存储数据库连接字.事实上这是个
很好的做法,因为可以省去我们很多的麻烦还可以帮助我们避免不必要的错位,是的很多情况下
我就是这样做.它通过XML来记录这些信息.具体的是在
1<appsettings>....</appsettings>
这个
标记中来记录的.这里请看一个ORACLE的例子如下:
1<appsettings>
2<add key="ORACLEConnectionString" value="Provider=OraOLEDB.Oracle.1;
3Persist Security Info=False;Password=blah;User ID=greg;Data Source=sph;"></add>
4<add key="SQLConnectionString" value="data source=SQL1;initial catalog=ID_V;
5integrated security=SSPI;persist security info=False;workstation id=TH03D374;
6packet size=4096"></add>
7<appsettings>
8
9而在你的应用程序中你只要这样写,就可以了,如下:
10
11string conn = ConfigurationSettings.AppSettings["ORACLEConnectionString"];
12OleDbConnection myConnection = new OleDbConnection(conn);
13
14很轻松是吗?不必每次都输入同样的连接字,也不要记住那些讨厌的信息了,只需要起一个好记的
15
16名字就可以.
17
18好了下面我在来给出其他的一些连接字
19
20MYSQL的连接字:
21ConnectionString = "Data Source=localhost;" +
22"Database=mySQLDatabase;" +
23"User ID=myUsername;" +
24"Password=myPassword;" +
25"Command Logging=false";
26OLE DB的:
27IBM AS/400 OLE DB 的
28
29' VB.NET
30Dim oOleDbConnection As OleDb.OleDbConnection
31Dim sConnString As String = _
32"Provider=IBMDA400.DataSource.1;" & _
33"Data source=myAS400DbName;" & _
34"User Id=myUsername;" & _
35"Password=myPassword"
36oOleDbConnection = New OleDb.OleDbConnection(sConnString)
37oOleDbConnection.Open()
38
39JET OLE DB 的
40
41' VB.NET
42Dim oOleDbConnection As OleDb.OleDbConnection
43Dim sConnString As String = _
44"Provider=Microsoft.Jet.OLEDB.4.0;" & _
45"Data Source=C:\myPath\myJet.mdb;" & _
46"User ID=Admin;" & _
47"Password="
48oOleDbConnection = New OleDb.OleDbConnection(sConnString)
49oOleDbConnection.Open()
50
51Oracle OLE DB 的
52
53' VB.NET
54Dim oOleDbConnection As OleDb.OleDbConnection
55Dim sConnString As String = _
56"Provider=OraOLEDB.Oracle;" & _
57"Data Source=MyOracleDB;" & _
58"User ID=myUsername;" & _
59"Password=myPassword"
60oOleDbConnection = New OleDb.OleDbConnection(sConnString)
61oOleDbConnection.Open()
62
63SQL Server OLE DB 的
64
65' VB.NET
66Dim oOleDbConnection As OleDb.OleDbConnection
67Dim sConnString As String = _
68"Provider=sqloledb;" & _
69"Data Source=myServerName;" & _
70"Initial Catalog=myDatabaseName;" & _
71"User Id=myUsername;" & _
72"Password=myPassword"
73oOleDbConnection = New OleDb.OleDbConnection(sConnString)
74oOleDbConnection.Open()
75
76Sybase ASE OLE DB 的
77
78' VB.NET
79Dim oOleDbConnection As OleDb.OleDbConnection
80Dim sConnString As String = _
81"Provider=Sybase ASE OLE DB Provider;" & _
82"Data Source=MyDataSourceName;" & _
83"Server Name=MyServerName;" & _
84"Database=MyDatabaseName;" & _
85"User ID=myUsername;" & _
86"Password=myPassword"
87oOleDbConnection = New OleDb.OleDbConnection(sConnString)
88oOleDbConnection.Open()
89
90SQL Server在System.Data.SqlClient
91
92SqlConnection oSQLConn = new SqlConnection();
93oSQLConn.ConnectionString = "Data Source=(local);" +
94"Initial Catalog=mySQLServerDBName;" +
95"Integrated Security=SSPI";
96oSQLConn.Open();
97
98
99---</appsettings></appsettings>