我想更改app config连接字符串 [英] I want to change app config connection string
问题描述
我想通过代码更改app config连接字符串
我的SourceCode
< pre lang =C#> string connString = 跨度>;
connString = 数据源= + Convert.ToString(txtServer。 EditValue)+ ; +
初始目录= + Convert.ToString(txtDatabase.EditValue)+ ; +
用户ID = + Convert.ToString(txtUserName.EditValue)+ ; +
Password = + Convert.ToString(txtPassword.EditValue)+ ;;
var config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
ConnectionStringsSection connSection =
(ConnectionStringsSection)config.GetSection( connectionStrings) ;
connSection.ConnectionStrings [ INATTSQLConnString]。ConnectionString = connString;
config.Save();
ConfigurationManager.RefreshSection( connectionStrings);
但是当我在app.config中看到时,这个文件没有被修改。
有人可以帮忙我,拜托?
谢谢这已经过测试可行了。唯一的区别是它省略了GetSection。
请记住,如果您在调试会话中测试它并且您正在使用vs主机,则此更改将应用于appName.vshost。 exe.Config文件。
public static void ModifyConnectionString(string connectionString)
{
Configuration config =
ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None );
ConnectionStringSettingsCollection connectionStrings =
config.ConnectionStrings.ConnectionStrings;
connectionStrings [INATTSQLConnString]。ConnectionString = connectionString;
config.Save();
ConfigurationManager.RefreshSection(connectionStrings);
}
I want to change app config connection string, through a code
My SourceCode
string connString = "";
connString = "Data Source=" + Convert.ToString(txtServer.EditValue) + ";" +
"Initial Catalog=" + Convert.ToString(txtDatabase.EditValue) + ";" +
"User id=" + Convert.ToString(txtUserName.EditValue) + ";" +
"Password=" + Convert.ToString(txtPassword.EditValue) + ";";
var config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
ConnectionStringsSection connSection =
(ConnectionStringsSection)config.GetSection("connectionStrings");
connSection.ConnectionStrings["INATTSQLConnString"].ConnectionString = connString;
config.Save();
ConfigurationManager.RefreshSection("connectionStrings");
but when i saw in my app.config, this file isn't modified.
can somebody help me, please?
Thanks
This has been tested to work. The only difference is that it omits the "GetSection".
Remember that if you are testing this in a debug session and you are using the vs host, this change will be applied to the appName.vshost.exe.Config file.
public static void ModifyConnectionString(string connectionString) { Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None); ConnectionStringSettingsCollection connectionStrings = config.ConnectionStrings.ConnectionStrings; connectionStrings["INATTSQLConnString"].ConnectionString = connectionString; config.Save(); ConfigurationManager.RefreshSection("connectionStrings"); }
这篇关于我想更改app config连接字符串的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!