在asp.net中的(de)WEB程序的(de)設置中我們必須用(yòng)£ ₩到(dào)Web.config來(lái'δ←)存儲數(shù)據庫連接字.事(shì)實上(s•ε♠•hàng)這(zhè)是(shì)個(gè)

很(hěn)好(hǎo)的(de)做(zuò)法,因為(wèi)可(k↑$∏ě)以省去(qù)我們很(hěn)多(duō)的(de)✔λ麻煩還(hái)可(kě)以幫助我們避免不(bù)必要(yào)∑‍↕的(de)錯(cuò)位,是(shì)的(de)很(¥α<hěn)多(duō)情況下(xià)

我就(jiù)是(shì)這(zhè)樣做(zuò).它通(tōng)過xm∏↔✘l來(lái)記錄這(zhè)些(xiē)信息.具體(tǐ)的(de)是(s<™hì)在<appsettings>....</apps₹♦∏ ettings>這(zhè)個(gè)

标記中來(lái)記錄的(de).這(zhè)裡(lǐ)請($ qǐng)看(kàn)一(yī)個(gè)orac→≠®le的(de)例子(zǐ)如(rú)下(xià):

<appsettings>
<add key="ORACLEConnectionString" v∞φ"★alue="Provider=OraOLEDB.Oracle.1€&♣₽;
Persist Security Info=Falδ♠se;Password=blah;User ID=greg;Data S∏αource=sph;" />
<add key="SQLConnectionString" va​₩σ$lue="data source=SQL1;initial c®∞₹±atalog=ID_V;
integrated security=S&α÷SPI;persist security info=FΩ≤≥alse;workstation id=TH03D374;
packet size=4096"/>
<appSettings>

而在你(nǐ)的(de)應用(yòng)程序中↔↓&你(nǐ)隻要(yào)這(zhè)樣寫,就(jiù)可(kě)以了(le)±®α∑,如(rú)下(xià):

string conn = Configu₹≈rationSettings.AppSettings["ORACLEConn< 'ectionString"];
OleDbConnection myConne§↑ "ction = new OleDbConnection(conn$∏);

很(hěn)輕松是(shì)嗎(ma)?不(bù)必每次都(dōu)輸入同♥¶樣的(de)連接字,也(yě)不(bù)要(yào)記住那÷↓λ(nà)些(xiē)討(tǎo)厭(yàn)的(de)信息了(le),隻需要(±>₹©yào)起一(yī)個(gè)好(hǎo)記的(d←™↑e)

名字就(jiù)可(kě)以.

好(hǎo)了(le)下(xià)面我在來(láγ≤£i)給出其他(tā)的(de)一(yī)些(xiē)連接字

mysql的(de)連接字:
ConnectionString = "Data Source=loc₩♥☆ alhost;" +
"Database=mySQLDatabase;" +
"User ID=myUsername;" +
"Password=myPassword;" +
"Command Logging=false";
OLE DB的(de):
IBM AS/400 OLE DB 的(de)

" VB.NET
Dim oOleDbConnection As OleDb.OleDbConnũection
Dim sConnString As St‍α•♣ring = _
"Provider=IBMDA400.D≥±♣•ataSource.1;" & _
"Data source=myAS400DbName;" & _
"User Id=myUsername;" & _
"Password=myPassword"
oOleDbConnection = New OleDb.®¶♠OleDbConnection(sConnString)
oOleDbConnection.Ope​'n()

jet OLE DB 的(de)

" 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.OleφπDbConnection(sConnSt®§♣​ring)
oOleDbConnection.Open()

oracle OLE DB 的(de)

" VB.NET
Dim oOleDbConnection As OleD£ ≥©b.OleDbConnection
Dim sConnString As S>‍±tring = _
"Provider=OraOLEDB.Oracle;" & _
"Data Source=MyOracleDB;" & _
"User ID=myUsername;" & _
"Password=myPassword"
oOleDbConnection = New OleDb.OleD​ ​bConnection(sConnString)
oOleDbConnection.Open()

sql Server OLE DB 的(de)♦≠♠

" VB.NET
Dim oOleDbConnection As OleDb.O§¶leDbConnection
Dim sConnString As String = _↕♣←
"Provider=sqloledb;" & _
"Data Source=myServerName;" &λ≤→≈; _
"Initial Catalog=myDatabaseN§✔¥→ame;" & _
"User Id=myUsername;" &<<®amp; _
"Password=myPassword"
oOleDbConnection = Ne÷♦w OleDb.OleDbConnection(s  ÷ConnString)
oOleDbConnection.Open()

sybase ASE OLE DB 的(de)

" VB.NET
Dim oOleDbConnection As OleDb.O∏σ∑leDbConnection
Dim sConnString As String = _
"Provider=Sybase ASE®α♠≥ OLE DB Provider;" & _
"Data Source=MyDataSourceName;"≠↔ & _
"Server Name=MyServerName;" &a≤→mp; _
"Database=MyDatabaseName;" &am¶♠ p; _
"User ID=myUsername;" & _
"Password=myPassword"
oOleDbConnection = New OleD↓δb.OleDbConnection(sConnString)
oOleDbConnection.Open() ​←

sql Server在System.Dataδ".SqlClient

sqlconnection oSQLConn = new©♥δ SqlConnection();
oSQLConn.ConnectionString = "'π​Data Source=(local);" +
"Initial Catalog=mySQLSe✘Ω₽£rverDBName;" +
"Integrated Security=SSPI";
oSQLConn.Open();