數據庫連接字在Web.config裏的用法

在asp.net中的WEB程序的設置中我們必須用到Web.config來存儲數據庫連接字.事實上這是個

很好的做法,因為可以省去我們很多的麻煩還可以幫助我們避免不必要的錯位,是的很多情況下

我就是這樣做.它通過XML來記錄這些信息.具體的是在<appSettings>....</appSettings>這個

標記中來記錄的.這裏請看一個ORACLE的例子如下:

<appSettings>
<addkey="ORACLEConnectionString"value="Provider=OraOLEDB.Oracle.1;
PersistSecurityInfo=False;Password=blah;UserID=greg;DataSource=sph;"/>
<addkey="SQLConnectionString"value="datasource=SQL1;initialcatalog=ID_V;
integratedsecurity=SSPI;persistsecurityinfo=False;workstationid=TH03D374;
packetsize=4096"/>
<appSettings>

而在你的應用程序中你隻要這樣寫,就可以了,如下:

stringconn=ConfigurationSettings.AppSettings["ORACLEConnectionString"];
OleDbConnectionmyConnection=newOleDbConnection(conn);

很輕鬆是嗎?不必每次都輸入同樣的連接字,也不要記住那些討厭的信息了,隻需要起一個好記的

名字就可以.

好了下麵我在來給出其他的一些連接字

MYSQL的連接字:
ConnectionString="DataSource=localhost;"+
"Database=mySQLDatabase;"+
"UserID=myUsername;"+
"Password=myPassword;"+
"CommandLogging=false";
OLEDB的:
IBMAS/400OLEDB的

'VB.NET
DimoOleDbConnectionAsOleDb.OleDbConnection
DimsConnStringAsString=_
"Provider=IBMDA400.DataSource.1;"&_
"Datasource=myAS400DbName;"&_
"UserId=myUsername;"&_
"Password=myPassword"
oOleDbConnection=NewOleDb.OleDbConnection(sConnString)
oOleDbConnection.Open()

JETOLEDB的

'VB.NET
DimoOleDbConnectionAsOleDb.OleDbConnection
DimsConnStringAsString=_
"Provider=Microsoft.Jet.OLEDB.4.0;"&_
"DataSource=C:/myPath/myJet.mdb;"&_
"UserID=Admin;"&_
"Password="
oOleDbConnection=NewOleDb.OleDbConnection(sConnString)
oOleDbConnection.Open()

OracleOLEDB的

'VB.NET
DimoOleDbConnectionAsOleDb.OleDbConnection
DimsConnStringAsString=_
"Provider=OraOLEDB.Oracle;"&_
"DataSource=MyOracleDB;"&_
"UserID=myUsername;"&_
"Password=myPassword"
oOleDbConnection=NewOleDb.OleDbConnection(sConnString)
oOleDbConnection.Open()

SQLServerOLEDB的

'VB.NET
DimoOleDbConnectionAsOleDb.OleDbConnection
DimsConnStringAsString=_
"Provider=sqloledb;"&_
"DataSource=myServerName;"&_
"InitialCatalog=myDatabaseName;"&_
"UserId=myUsername;"&_
"Password=myPassword"
oOleDbConnection=NewOleDb.OleDbConnection(sConnString)
oOleDbConnection.Open()

SybaseASEOLEDB的

'VB.NET
DimoOleDbConnectionAsOleDb.OleDbConnection
DimsConnStringAsString=_
"Provider=SybaseASEOLEDBProvider;"&_
"DataSource=MyDataSourceName;"&_
"ServerName=MyServerName;"&_
"Database=MyDatabaseName;"&_
"UserID=myUsername;"&_
"Password=myPassword"
oOleDbConnection=NewOleDb.OleDbConnection(sConnString)
oOleDbConnection.Open()

SQLServer在System.Data.SqlClient

SqlConnectionoSQLConn=newSqlConnection();
oSQLConn.ConnectionString="DataSource=(local);"+
"InitialCatalog=mySQLServerDBName;"+
"IntegratedSecurity=SSPI";
oSQLConn.Open();