blocks|key|933328|text|它应该在<configuration>节点内：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|933329|++<connectionStrings+>
++++<add+name="myconnectionstring"+connectionString="Server=myServerAddress;Database=myDataBase;User+ID=myUsername;Password=myPassword;Trusted_Connection=False;"+providerName="System.Data.SqlClient"/>
++</connectionStrings>|code-block|syntax|javascript|933330|此site包含有关它的详细信息：|933331|entityMap|0|LINK|mutability|MUTABLE|url|http://www.connectionstrings.com/^0|4|F|0|0|1|4|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|X|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|Y|8|@]|D|@$9|Z|A|10|1|11]]|E|$]]|$1|M|3|-4|5|6|7|12|8|@]|D|@]|E|$]]]|N|$O|$5|P|Q|R|E|$S|T]]]]

it should be within the <code>&lt;configuration&gt;</code> node:

<pre><code> &lt;connectionStrings &gt;
 &lt;add name="myconnectionstring" connectionString="Server=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Trusted_Connection=False;" providerName="System.Data.SqlClient"/&gt;
 &lt;/connectionStrings&gt;
</code></pre>

this <a href="http://www.connectionstrings.com/">site</a> has more info on it:

blocks|key|717682|text|你也可以使用这个，它更简单。你唯一需要设置的是"YourDataBaseName“。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|717683|++<connectionStrings>
++++<add+name="ConnStringDb1"+connectionString="Data+Source=localhost;Initial+Catalog=YourDataBaseName;Integrated+Security=True;"+providerName="System.Data.SqlClient"+/>
++</connectionStrings>|code-block|syntax|javascript|717684|放置connection+string的位置|offset|length|717685|<?xml+version='1.0'+encoding='utf-8'?>++
++<configuration>++
++++<connectionStrings>++
++++++<clear+/>++
++++++<add+name="Name"+++
+++++++providerName="System.Data.ProviderName"+++
+++++++connectionString="Valid+Connection+String;"+/>++
++++</connectionStrings>++
++</configuration>++|717686|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/connection-strings-and-configuration-files^0|0|0|2|H|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@]|9|@$I|X|J|Y|1|Z]]|A|$]]|$1|K|3|L|5|D|7|10|8|@]|9|@]|A|$E|F]]|$1|M|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]]]

You can also use this, it's simpler. The only thing you need to set is "YourDataBaseName".

<pre><code> &lt;connectionStrings&gt;
 &lt;add name="ConnStringDb1" connectionString="Data Source=localhost;Initial Catalog=YourDataBaseName;Integrated Security=True;" providerName="System.Data.SqlClient" /&gt;
 &lt;/connectionStrings&gt;
</code></pre>

Where to place the <a href="https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/connection-strings-and-configuration-files" rel="noreferrer">connection string</a>

<pre><code>&lt;?xml version='1.0' encoding='utf-8'?&gt; 
 &lt;configuration&gt; 
 &lt;connectionStrings&gt; 
 &lt;clear /&gt; 
 &lt;add name="Name" 
 providerName="System.Data.ProviderName" 
 connectionString="Valid Connection String;" /&gt; 
 &lt;/connectionStrings&gt; 
 &lt;/configuration&gt; 
</code></pre>

blocks|key|933375|text|如果您想用Web.config编写连接字符串，则在给定的字符串下编写|type|unstyled|depth|inlineStyleRanges|entityRanges|data|933376|<connectionStrings>
++<add+name="Conn"+connectionString="Data+Source=192.168.1.25;Initial+Catalog=Login;Persist+Security+Info=True;User+ID=sa;Password=example.com"
+++providerName="System.Data.SqlClient"+/>
+</connectionStrings>|code-block|syntax|javascript|933377|或|933378|你在aspx.cs文件中就像这样|933379|SqlConnection+conn+=+new+SqlConnection("Data+Source=12.16.1.25;Initial+Catalog=Login;Persist+Security+Info=True;User+ID=sa;Password=example.com");|933380|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|S|8|@]|9|@]|A|$E|F]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

If you want to write connection string in Web.config then write under given sting

<pre><code>&lt;connectionStrings&gt;
 &lt;add name="Conn" connectionString="Data Source=192.168.1.25;Initial Catalog=Login;Persist Security Info=True;User ID=sa;Password=example.com"
 providerName="System.Data.SqlClient" /&gt;
 &lt;/connectionStrings&gt;
</code></pre>

OR

you right in aspx.cs file like 

<pre><code>SqlConnection conn = new SqlConnection("Data Source=12.16.1.25;Initial Catalog=Login;Persist Security Info=True;User ID=sa;Password=example.com");
</code></pre>

blocks|key|717728|text|在标题中|type|unstyled|depth|inlineStyleRanges|entityRanges|data|717729|using+System.Configuration;|code-block|syntax|javascript|717730|在代码中|717731|SqlConnection+conn+=+new+SqlConnection(*ConfigurationManager.ConnectionStrings["connstrname"].ConnectionString*);|717732|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

in header

<pre><code>using System.Configuration;
</code></pre>

in code

<pre><code>SqlConnection conn = new SqlConnection(*ConfigurationManager.ConnectionStrings["connstrname"].ConnectionString*);
</code></pre>

blocks|key|933409|text|出于某种原因，我在这里看不到简单的答案。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|933410|将这段代码放在代码的顶部：|933411|using+System.Web.Configuration;
using+System.Data.SqlClient;+|code-block|syntax|javascript|933412|将此代码放入Web.Config：|933413|<connectionStrings+>
++++<add
+++++++++name="myConnectionString"+
+++++++++connectionString="Server=myServerAddress;Database=myDataBase;User+ID=myUsername;Password=myPassword;Trusted_Connection=False;"
+++++++++providerName="System.Data.SqlClient"/>
</connectionStrings>|933414|以及要设置连接变量的位置：|933415|SqlConnection+con+=+new+SqlConnection(
++++WebConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString);|933416|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|V|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|W|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|X|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|Y|8|@]|9|@]|A|$G|H]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

For some reason I don't see the simple answer here.

Put this at the top of your code: 

<pre><code>using System.Web.Configuration;
using System.Data.SqlClient; 
</code></pre>

Put this in Web.Config:

<pre><code>&lt;connectionStrings &gt;
 &lt;add
 name="myConnectionString" 
 connectionString="Server=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Trusted_Connection=False;"
 providerName="System.Data.SqlClient"/&gt;
&lt;/connectionStrings&gt;
</code></pre>

and where you want to setup the connection variable:

<pre><code>SqlConnection con = new SqlConnection(
 WebConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString);
</code></pre>

blocks|key|717764|text|您可以将其放入web.config文件connectionStrings中|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|717765|<add+name="myConnectionString"+connectionString="Server=myServerAddress;Database=myDataBase;User+ID=myUsername;Password=myPassword;Trusted_Connection=False;"+providerName="System.Data.SqlClient"/>|code-block|syntax|javascript|717766|entityMap^0|7|A|J|H|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]|$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|S|8|@]|D|@]|E|$]]]|L|$]]

You can put this in your <code>web.config</code> file <code>connectionStrings</code>:

<pre><code>&lt;add name="myConnectionString" connectionString="Server=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Trusted_Connection=False;" providerName="System.Data.SqlClient"/&gt;
</code></pre>

blocks|key|933443|text|为您的连接字符串尝试此方法。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|933444|+Data+Source=myServerAddress;Initial+Catalog=myDataBase;Integrated+Security=SSPI;
+User+ID=myDomain\myUsername;Password=myPassword;|code-block|syntax|javascript|933445|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Try this for your connection string. 

<pre><code> Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;
 User ID=myDomain\myUsername;Password=myPassword;
</code></pre>

blocks|key|717830|text|您可以使用以下格式：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|717831|++<connectionStrings>
++++<add+name="ConStringBDName"+connectionString="Data+Source=serverpath;Initial+Catalog=YourDataBaseName;Integrated+Security=SSPI;"+providerName="System.Data.SqlClient"+/>
++</connectionStrings>|code-block|syntax|javascript|717832|您很可能会在<appSettings>之后的web.config中找到connectionstring标记|offset|length|style|CODE|717833|试试这个。|717834|entityMap^0|0|0|6|D|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@$I|T|J|U|K|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

You can use following format:

<pre><code> &lt;connectionStrings&gt;
 &lt;add name="ConStringBDName" connectionString="Data Source=serverpath;Initial Catalog=YourDataBaseName;Integrated Security=SSPI;" providerName="System.Data.SqlClient" /&gt;
 &lt;/connectionStrings&gt;
</code></pre>

Most probably you will fing connectionstring tag in web.config after <code>&lt;appSettings&gt;</code>

Try out this.

blocks|key|933568|text|将连接字符串存储在web.config中|type|unstyled|depth|inlineStyleRanges|entityRanges|data|933569|最好将应用程序的连接字符串存储在配置文件中，而不是作为代码中的硬编码字符串。在.NET+2.0和.NET+3.5+(以及更高版本)中，实现这一点的方法是不同的。这篇文章涵盖了这两个方面。https://www.connectionstrings.com/store-connection-string-in-webconfig/|offset|length|933570|entityMap|0|LINK|mutability|MUTABLE|url|https://www.connectionstrings.com/store-connection-string-in-webconfig/^0|0|2L|1Z|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

Store connection string in web.config

It is a good practice to store the connection string for your application in a config file rather than as a hard coded string in your code. The way to do this differs between .NET 2.0 and .NET 3.5 (and above). This article cover both.
<a href="https://www.connectionstrings.com/store-connection-string-in-webconfig/" rel="nofollow">https://www.connectionstrings.com/store-connection-string-in-webconfig/</a>

blocks|key|933655|text|WebConfig中的连接|type|unstyled|depth|inlineStyleRanges|entityRanges|data|933656|将连接字符串添加到Web.config文件中的<connectionStrings>元素。|offset|length|style|CODE|933657|<connectionStrings>
<add+name="ConnectionString"+connectionString="Data+Source=192.168.1.25;Initial+Catalog=Login;Persist+Security+Info=True;User+ID=sa;Password=example.com"+++providerName="System.Data.SqlClient"+/>
</connectionStrings>|code-block|syntax|javascript|933658|在Class.Cs中|933659|public+static+string+ConnectionString{
get{
return+ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;}
set{}|933660|entityMap^0|0|9|A|N|J|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@$D|U|E|V|F|G]|$D|W|E|X|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|Y|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|Z|8|@]|9|@]|A|$]]|$1|O|3|P|5|J|7|10|8|@]|9|@]|A|$K|L]]|$1|Q|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|R|$]]

<h2>Connection in WebConfig</h2>

Add the your connection string to the <code>&lt;connectionStrings&gt;</code> element in the <code>Web.config</code> file.

<pre><code>&lt;connectionStrings&gt;
&lt;add name="ConnectionString" connectionString="Data Source=192.168.1.25;Initial Catalog=Login;Persist Security Info=True;User ID=sa;Password=example.com" providerName="System.Data.SqlClient" /&gt;
&lt;/connectionStrings&gt;
</code></pre>

<h2>In Class.Cs</h2>

<pre><code>public static string ConnectionString{
get{
return ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;}
set{}
</code></pre>

blocks|key|933756|text|在web.config+inside+<configuration></configuration>中创建一个名为<connectionStrings></connectionStrings>的部分，然后向其中添加不同的连接字符串，例如|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|933757|<configuration>

++<connectionStrings>
+++<add+name="ConnectionStringName"+providerName="System.Data.SqlClient"+connectionString="Data+Source=.\SQLEXPRESS;Initial+Catalog=DatabaseName;Integrated+Security=True;MultipleActiveResultSets=True"/>
++</connectionStrings>

</configuration>|code-block|syntax|javascript|933758|下面是所有不同连接字符串格式https://msdn.microsoft.com/en-us/library/jj653752(v=vs.110).aspx的列表|933759|entityMap|0|LINK|mutability|MUTABLE|url|https://msdn.microsoft.com/en-us/library/jj653752(v=vs.110).aspx^0|1|A|J|V|1L|13|0|0|E|1S|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]|$9|X|A|Y|B|C]|$9|Z|A|10|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|11|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|12|8|@]|D|@$9|13|A|14|1|15]]|E|$]]|$1|M|3|-4|5|6|7|16|8|@]|D|@]|E|$]]]|N|$O|$5|P|Q|R|E|$S|T]]]]

Create a section called <code>&lt;connectionStrings&gt;&lt;/connectionStrings&gt;</code> in your <code>web.config</code> inside <code>&lt;configuration&gt;&lt;/configuration&gt;</code> then add different connection strings to it, for example

<pre><code>&lt;configuration&gt;

 &lt;connectionStrings&gt;
 &lt;add name="ConnectionStringName" providerName="System.Data.SqlClient" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=DatabaseName;Integrated Security=True;MultipleActiveResultSets=True"/&gt;
 &lt;/connectionStrings&gt;

&lt;/configuration&gt;
</code></pre>

Here's a list of all the different connection string formats <a href="https://msdn.microsoft.com/en-us/library/jj653752(v=vs.110).aspx" rel="nofollow noreferrer">https://msdn.microsoft.com/en-us/library/jj653752(v=vs.110).aspx</a>

blocks|key|933822|text|你可以试试这个。这很简单|type|unstyled|depth|inlineStyleRanges|entityRanges|data|933823|<connectionStrings>+++++++++
++++<add+name="conString"+connectionString="Data+Source=SQLServerAddress;Initial+Catalog=YourDatabaseName;+User+Id=SQLServerLoginId;+Password=SQLServerPassword"/>
</connectionStrings>|code-block|syntax|javascript|933824|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You can try this. It is very simple

<pre><code>&lt;connectionStrings&gt; 
 &lt;add name="conString" connectionString="Data Source=SQLServerAddress;Initial Catalog=YourDatabaseName; User Id=SQLServerLoginId; Password=SQLServerPassword"/&gt;
&lt;/connectionStrings&gt;
</code></pre>

I'm trying to set up a connecting string in my web.config file (Visual Studio 2008/ASP.NET 3.5) to a local server (SQL server 2008).

In my web.config, how and where do I place the connection string?

Here's what web.config file looks like right now: <a href="http://imwired.net/aspnet/Online_web.config" rel="noreferrer">http://imwired.net/aspnet/Online_web.config</a>

Setting up connection string in ASP.NET to SQL SERVER

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我正在尝试在我的web.config文件(Visual Studio2008/ASP.NET3.5)中设置一个连接到本地服务器(SQL Server2008)的字符串。在我的web.config中，我如何以及在哪里放置连接字符串？下面是web.config文件现在的样子：

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

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

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