数据库连接字在Web.config里的用法

作者：未知 请速与本人联系

在asp.net中的WEB程序的设置中我们必须用到Web.config来存储数据库连接字.事实上这是个很好的做法,因为可以省去我们很多的麻烦还可以帮助我们避免不必要的错位,是的很多情况下我就是这样做.它通过XML来记录这些信息.具体的是在<appsettings>....</appsettings>这个标记中来记录的.这里请看一个ORACLE的例子如下:

<appsettings><br><font color="#0000ff">&lt;appSettings&gt;<br> &lt;add key="ORACLEConnectionString" value="Provider=OraOLEDB.Oracle.1;<br>Persist Security Info=False;Password=blah;User ID=greg;Data Source=sph;" /&gt;<br> &lt;add key="SQLConnectionString" value="data source=SQL1;initial catalog=ID_V;<br>integrated security=SSPI;persist security info=False;workstation id=TH03D374;<br>packet size=4096"/&gt; <br>&lt;appSettings&gt;<br><br><br></font>而在你的应用程序中你只要这样写,就可以了,如下:<br><br><font color="#0000ff">string conn = ConfigurationSettings.AppSettings["ORACLEConnectionString"];<br>OleDbConnection myConnection = new OleDbConnection(conn);</font><br><br>很轻松是吗?不必每次都输入同样的连接字,也不要记住那些讨厌的信息了,只需要起一个好记的名字就可以.好了下面我在来给出其他的一些连接字:<br><br><font color="#0000ff">MYSQL的连接字:<br>ConnectionString = "Data Source=localhost;" +<br> "Database=mySQLDatabase;" +<br> "User ID=myUsername;" +<br> "Password=myPassword;" +<br> "Command Logging=false";<br>OLE DB的:<br>IBM AS/400 OLE DB 的</font></appsettings>

' VB.NET
Dim oOleDbConnection As OleDb.OleDbConnection
Dim sConnString As String = _
"Provider=IBMDA400.DataSource.1;" & _
"Data source=myAS400DbName;" & _
"User Id=myUsername;" & _
"Password=myPassword"
oOleDbConnection = New OleDb.OleDbConnection(sConnString)
oOleDbConnection.Open()

JET OLE DB 的

' VB.NET
Dim oOleDbConnection As OleDb.OleDbConnection
Dim sConnString As String = _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\myPath\myJet.mdb;" & _
"User ID=Admin;" & _
"Password="
oOleDbConnection = New OleDb.OleDbConnection(sConnString)
oOleDbConnection.Open()

Oracle OLE DB 的

' VB.NET
Dim oOleDbConnection As OleDb.OleDbConnection
Dim sConnString As String = _
"Provider=OraOLEDB.Oracle;" & _
"Data Source=MyOracleDB;" & _
"User ID=myUsername;" & _
"Password=myPassword"
oOleDbConnection = New OleDb.OleDbConnection(sConnString)
oOleDbConnection.Open()

SQL Server OLE DB 的

' VB.NET
Dim oOleDbConnection As OleDb.OleDbConnection
Dim sConnString As String = _
"Provider=sqloledb;" & _
"Data Source=myServerName;" & _
"Initial Catalog=myDatabaseName;" & _
"User Id=myUsername;" & _
"Password=myPassword"
oOleDbConnection = New OleDb.OleDbConnection(sConnString)
oOleDbConnection.Open()

Sybase ASE OLE DB 的

' VB.NET
Dim oOleDbConnection As OleDb.OleDbConnection
Dim sConnString As String = _
"Provider=Sybase ASE OLE DB Provider;" & _
"Data Source=MyDataSourceName;" & _
"Server Name=MyServerName;" & _
"Database=MyDatabaseName;" & _
"User ID=myUsername;" & _
"Password=myPassword"
oOleDbConnection = New OleDb.OleDbConnection(sConnString)
oOleDbConnection.Open()

SQL Server在System.Data.SqlClient

SqlConnection oSQLConn = new SqlConnection();
oSQLConn.ConnectionString = "Data Source=(local);" +
"Initial Catalog=mySQLServerDBName;" +
"Integrated Security=SSPI";
oSQLConn.Open();

这里都是用VB.NET写的，希望能对用VB写ASP.NET的朋友一点帮助.