在ASP.net中的WEB程序的设置中我们必须用到Web.config来存储数据库连接字.事实上这是个

很好的做法,因为可以省去我们很多的麻烦还可以帮助我们避免不必要的错位,是的很多情况下

我就是这样做.它通过XML来记录这些信息.具体的是在....这个

标记中来记录的.这里请看一个ORACLE的例子如下:

Persist Security Info=False;Password=blah;User ID=greg;Data Source=sph; />

integrated security=SSPI;persist security info=False;workstation id=TH03D374;

packet size=4096/>

而在你的应用程序中你只要这样写,就可以了,如下:

string conn = ConfigurationSettings.AppSettings[ORACLEConnectionString];

OleDbConnection myConnection = new OleDbConnection(conn);

很轻松是吗?不必每次都输入同样的连接字,也不要记住那些讨厌的信息了,只需要起一个好记的

名字就可以.

好了下面我在来给出其他的一些连接字

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

做人要厚道，请注明转自酷网动力(www.ASPCOOL.COM)。