C# web Web.config裏sql連接數據庫

訪問數據庫有兩種方式：

Windows身份驗證登錄（不需要用戶名和密碼，適用於訪問本地數據庫，應用程序和SQL軟件安裝在同壹臺服務器）

SQL Server 身份驗證登錄（適用於訪問其他計算機的數據庫，當然也可以用這種方式訪問本地數據庫）

根據樓主的情況應該用 SQL Server 身份驗證登錄

數據庫連接字符串壹般寫在 connectionStrings節點下，非強制性（如寫在appsettings節點下），只不過這樣可以用

ConfigurationManager.ConnectionStrings["connString"].ConnectionString;

方便訪問

以下是筆者的壹個 web.config 文件的內容

<?xml version="1.0" encoding="utf-8" ?>

</connectionStrings>

</configuration>

附：數據庫連接字符串的寫法

SQL Server connection strings

SQL ODBC connection strings

Standard Security:< br> "Driver={SQLServer};Server=Your_Server_Name;Database=Your_Database_Name;Uid=Your_Username;Pwd=Your_Password;"

Trusted connection:< br> "Driver={SQLServer};Server=Your_Server_Name;Database=Your_Database_Name;Trusted_Connection=yes;"

SQL OLE DB connection strings

Standard Security:

"Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog= Your_Database_Name;UserId=Your_Username;Password=Your_Password;"

Trusted connection:

"Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;Integrated Security=SSPI;"

SQL OleDbConnection .NET strings

Standard Security:

"Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog= Your_Database_Name;UserId=Your_Username;Password=Your_Password;"

Trusted connection:

"Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;Integrated Security=SSPI;"

SQL SqlConnection .NET strings

Standard Security:

1. "Data Source=Your_Server_Name;Initial Catalog= Your_Database_Name;UserId=Your_Username;Password=Your_Password;" < br>2. "Server=Your_Server_Name;Database=Your_Database_Name;UserID=Your_Username;Password=Your_Password;Trusted_Connection=False"

Trusted connection:

1. "Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;Integrated Security=SSPI;"

2."Server=Your_Server_Name;Database=Your_Database_Name;Trusted_Connection=True;"

希望回答對妳有幫助

上一篇:職高學工業機器人怎麽樣

下一篇:為什麽程序員的薪資那麽高？北大青鳥沙河計算機學院為妳揭秘？