<configuration>
<connectionStrings>
<add name="ApplicationServices"
connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true"
providerName="System.Data.SqlClient" />
<add name="TESR_DB"
connectionString="user id=sa;Data Source=127.1.1.1;password=12345678;Persist Security Info=True;"
providerName="System.Data.SqlClient" />
<!-- Oracle 範例 -->
<add name="ORA_DB"
connectionString="DATA SOURCE=127.1.1.1;PASSWORD=12345678;USER ID=sa"
providerName="Oracle.DataAccess.Client" />
</connectionStrings>
</configuration>
name:唯一識別碼,後端透過 ConfigurationManager.ConnectionStrings["name"] 取得。connectionString:包含伺服器位址、資料庫名稱、認證方式、安全性選項。Persist Security Info=True:連線成功後是否在連線物件中保留密碼等敏感資訊。True 保留,False 不保留(較安全)。providerName:ADO.NET 提供者,SQL Server 用 System.Data.SqlClient,Oracle 用 Oracle.DataAccess.Client 等。using System.Configuration;
using System.Data.SqlClient;
string connStr = ConfigurationManager.ConnectionStrings["TESR_DB"].ConnectionString;
using (SqlConnection conn = new SqlConnection(connStr))
{
try
{
conn.Open();
Response.Write("連線成功");
}
catch (Exception ex)
{
Response.Write("連線失敗:" + ex.Message);
}
}
在 <connectionStrings> 區段新增多個 <add> 元素,各自指定不同 name,後端依名稱取用對應連線字串,實現一個專案連接多個資料庫。