Get ConnectString Form Web.config

最新推荐文章于 2020-12-17 13:59:45 发布

转载最新推荐文章于 2020-12-17 13:59:45 发布 · 37 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/xucanzhao/archive/2006/03/22/355625.html

文章标签：

#c#

Listing 11-14: Building connection strings using ConnectionStringBuilder
VB
‘ Retrieve an existing connection string into a Connection String Builder
Dim builder As New System.Data.SqlClient.SqlConnectionStringBuilder()
‘ Change the connection string properties
builder.DataSource = “localhost”
builder.InitialCatalog = “Northwind1”
builder.UserID = “sa”
builder.Password = “password”
builder.PersistSecurityInfo = true
‘ Save the connection string back to the web.config
ConfigurationManager.ConnectionStrings(“AppConnectionString1”).ConnectionString = _
builder.ConnectionString
C#
System.Data.SqlClient.SqlConnectionStringBuilder builder = new
System.Data.SqlClient.SqlConnectionStringBuilder();
// Change the connection string properties
builder.DataSource = “localhost”;
builder.InitialCatalog = “Northwind1”;
builder.UserID = “sa”;
builder.Password = “password”;
builder.PersistSecurityInfo = true;
// Save the connection string back to the web.config
ConfigurationManager.ConnectionStrings[“AppConnectionString1”].ConnectionString =
builder.ConnectionString;

转载于:https://www.cnblogs.com/xucanzhao/archive/2006/03/22/355625.html