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

Visual Studio

SQL Server

服务器

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

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

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

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

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

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