在ASP.NET中设置连接字符串到SQL SERVER

Question

在ASP.NET中设置连接字符串到SQL SERVER

我正在尝试在我的web.config文件（Visual Studio 2008 / ASP.NET 3.5）中将连接字符串设置为本地服务器（SQL Server 2008）。

在我的web.config中，我如何以及在何处放置连接字符串？

以下是web.config文件现在的样子：http：//imwired.net/aspnet/Online_web.config

Answer 1

你也可以使用它，它更简单。您需要设置的唯一内容是“YourDataBaseName”。&nbsp;&nbsp;<connectionStrings> &nbsp;&nbsp;&nbsp;&nbsp;<add&nbsp;name="ConnStringDb1"&nbsp;connectionString="Data&nbsp;Source=localhost;Initial&nbsp;Catalog=YourDataBaseName;Integrated&nbsp;Security=True;"&nbsp;providerName="System.Data.SqlClient"&nbsp;/> &nbsp;&nbsp;</connectionStrings>放置连接字符串的位置<?xml&nbsp;version='1.0'&nbsp;encoding='utf-8'?>&nbsp;&nbsp; &nbsp;&nbsp;<configuration>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;<connectionStrings>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<clear&nbsp;/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<add&nbsp;name="Name"&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;providerName="System.Data.ProviderName"&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;connectionString="Valid&nbsp;Connection&nbsp;String;"&nbsp;/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;</connectionStrings>&nbsp;&nbsp; &nbsp;&nbsp;</configuration>

Answer 2

出于某种原因，我在这里看不到简单的答案。把它放在代码的顶部：using&nbsp;System.Web.Configuration;using&nbsp;System.Data.SqlClient;把它放在Web.Config中：<connectionStrings&nbsp;> &nbsp;&nbsp;&nbsp;&nbsp;<add &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;name="myConnectionString"&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;connectionString="Server=myServerAddress;Database=myDataBase;User&nbsp;ID=myUsername;Password=myPassword;Trusted_Connection=False;" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;providerName="System.Data.SqlClient"/></connectionStrings>以及您要设置连接变量的位置：SqlConnection&nbsp;con&nbsp;=&nbsp;new&nbsp;SqlConnection( &nbsp;&nbsp;&nbsp;&nbsp;WebConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString);