WEB开发网
开发学院WEB开发ASP.NET 数据库连接字在Web.config里的用法 阅读

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

 2003-12-29 16:57:21 来源:WEB开发网   
核心提示:在asp.net中的WEB程序的设置中我们必须用到Web.config来存储数据库连接字.事实上这是个很好的做法,因为可以省去我们很多的麻烦还可以帮助我们避免不必要的错位,是的很多情况下我就是这样做.它通过xml来记录这些信息.具体的是在<appSettings>....</appSettings&g

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

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

我就是这样做.它通过xml来记录这些信息.具体的是在<appSettings>....</appSettings>这个

标记中来记录的.这里请看一个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>

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

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

Tags:数据库 连接 Web

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接