编辑ConnectionString [英] Edit ConnectionString

问题描述

我一直在试图解决这个问题。

我正在使用Enterprise Library 3.1 VS2005。

I am using Enterprise Library 3.1 VS2005.

我需要编辑"Catolog"。在保存到app.config文件的连接字符串中。

I need to edit the "Catolog" in the connection string that is save to the app.config file.

我已经能够编辑并保存文件。在调试期间如果我打开文件，我会在confg.save（）方法触发后弹出文件已更改对话框。如果你在这一点上查看文件它确实发生了变化。问题是即使在调用 ConfigurationManager .RefreshSection（ 之后） " connectionStrings" ）;你在立即窗口中调用ConfigurationManager.ConnectionString [0]它会显示连接字符串的先前版本。

I have been able to edit and save the file. During debugging if I have the file open I get the file has changed dialog pop up after the confg.save() method fires. If you look at the file at this point it did change. The problem is that even after calling the ConfigurationManager.RefreshSection("connectionStrings");   you call ConfigurationManager.ConnectionString[0] in the immediate window  it shows you the previous version of the connection string.

//创建连接字符串构建器;

//create a connection string builder;

SqlConnectionStringBuilder sqlBuilder = new SqlConnectionStringBuilder （）;

SqlConnectionStringBuilder sqlBuilder = new SqlConnectionStringBuilder();

sqlBuilder.DataSource = sqlServerName;

sqlBuilder.DataSource = sqlServerName;

sqlBuilder.UserID = dbUserName;

sqlBuilder.UserID = dbUserName;

sqlBuilder.WorkstationID = MachineName;

sqlBuilder.WorkstationID = MachineName;

sqlBuilder.Password = Password;

sqlBuilder.Password = Password;

sqlBuilder.InitialCatalog = sqlDataBaseName;

sqlBuilder.InitialCatalog = sqlDataBaseName;

sqlConString = sqlBuilder.ConnectionString;

sqlConString = sqlBuilder.ConnectionString;

配置 config = ConfigurationManag呃 .OpenExeConfiguration（ Application .ExecutablePath）;

Configuration config = ConfigurationManager.OpenExeConfiguration(Application.ExecutablePath);

config.ConnectionStrings.ConnectionStrings.Clear（）;

config.ConnectionStrings.ConnectionStrings.Clear();

config.Save（ ConfigurationSaveMode .Modified）;

config.Save(ConfigurationSaveMode.Modified);

ConfigurationManager .RefreshSection（ " connectionStrings" ）;

ConfigurationManager.RefreshSection("connectionStrings");

ConnectionStringSettings conStrSettings = new ConnectionStringSettings （sqlConStringName，sqlConString， " System.Data.SqlClient" ）;

ConnectionStringSettings conStrSettings = new ConnectionStringSettings(sqlConStringName, sqlConString,"System.Data.SqlClient");

config.ConnectionStrings.ConnectionStrings.Add（conStrSettings）;

config.ConnectionStrings.ConnectionStrings.Add(conStrSettings);

config.Save（ ConfigurationSaveMode .Modified）;

config.Save(ConfigurationSaveMode.Modified);

ConfigurationManager .RefreshSection（ " connectionStrings" ）;

ConfigurationManager.RefreshSection("connectionStrings");

推荐答案

< font face = Arial size = 2>

这篇关于编辑ConnectionString的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！