ASP.NET 2.0: How to get a specific ConnectionString from the Web.Config by name

最新推荐文章于 2025-08-20 15:51:36 发布

dabtd

最新推荐文章于 2025-08-20 15:51:36 发布

阅读量565

点赞数

CC 4.0 BY-SA版权

文章标签： asp.net vb.net reference string security search

本文链接：https://blog.youkuaiyun.com/dabtd/article/details/1834635

本文介绍如何从ASP.NET的Web.Config文件中简单地获取连接字符串。通过使用C#和VB.NET的一行代码示例，展示如何访问配置文件内的数据库连接设置。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

You have your ConnectionString for your ASP.NET web app stored in the Web.Config file. Now how exactly how do you get that ConnectionString out of there from within your code?

Sample Web.Config section with a ConnectionString:
<connectionStrings>
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="Data Source=myDBServer;database=myDB;Integrated Security=True;" providerName="System.Data.SqlClient"/>
</connectionStrings>

Now lets get the ConnectionString from the Web.Config file with only one line of code:

C#:
string strConnString = ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString;

VB.NET:
Dim strConnString As String = ConfigurationManager.ConnectionStrings("LocalSqlServer").ConnectionString

Now isn't that simple? I'm posting this because I did a search and didn't find an example of how to do this. I had to poke around a little and discover this on my own. I hope this helps someone avoid some frustration.

reference from : http://pietschsoft.com/Blog/Post.aspx?PostID=1252