在asp.net中的web程序的設(shè)置中我們必須用到web.config來存儲數(shù)據(jù)庫連接字.事實(shí)上這是個(gè)

很好的做法,因?yàn)榭梢允∪ノ覀兒芏嗟穆闊┻€可以幫助我們避免不必要的錯(cuò)位,是的很多情況下

我就是這樣做.它通過xml來記錄這些信息.具體的是在<appsettings>....</appsettings>這個(gè)

標(biāo)記中來記錄的.這里請看一個(gè)oracle的例子如下:

<appsettings>
    <add key="oracleconnectionstring" value="provider=oraoledb.oracle.1;
persist security info=false;password=blah;user id=greg;data source=sph;" />
    <add key="sqlconnectionstring" value="data source=sql1;initial catalog=id_v;
integrated security=sspi;persist security info=false;workstation id=th03d374;
packet size=4096"/>  
<appsettings>

而在你的應(yīng)用程序中你只要這樣寫,就可以了,如下:

string conn = configurationsettings.appsettings["oracleconnectionstring"];
oledbconnection myconnection = new oledbconnection(conn);

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

名字就可以.

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

mysql的連接字:
connectionstring = "data source=localhost;" +
                              "database=mysqldatabase;" +
                              "user id=myusername;" +
                              "password=mypassword;" +
                              "command logging=false";
ole db的:
ibm as/400 ole db 的

' 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();