操作Config文件
#region 操作Config文件
private void GetConnectionString()
{
Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
ConfigurationSection section = config.ConnectionStrings;
for (int i = 0; i < config.ConnectionStrings.ConnectionStrings.Count; i++)
{
string connectionName = config.ConnectionStrings.ConnectionStrings[i].Name;
if (connectionName == "milnets")
{
string connectionString = config.ConnectionStrings.ConnectionStrings[i].ConnectionString;
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(connectionString);
RegExTextBox_Server.Text = builder.DataSource;
RegExTextBox_uid.Text = builder.UserID;
RegExTextBox_pwd.Text = builder.Password;
RegExTextBox_Database.Text = builder.InitialCatalog;
break;
}
}
RegExTextBox_LibCode.Text = ConfigurationManager.AppSettings["LibCode"];
}
private void SaveConnectionString(string connectionString, string libcode)
{
Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
ConfigurationSection section = config.ConnectionStrings;
for (int i = 0; i < config.ConnectionStrings.ConnectionStrings.Count; i++)
{
if (config.ConnectionStrings.ConnectionStrings[i].Name == "milnets")
{
config.ConnectionStrings.ConnectionStrings[i].ConnectionString = connectionString;
}
}
config.AppSettings.Settings.Clear();
config.AppSettings.Settings.Add("LibCode", libcode);
config.Save(ConfigurationSaveMode.Full);
ConfigurationManager.RefreshSection("dataConfiguration");
ConfigurationManager.RefreshSection("connectionStrings");
ConfigurationManager.RefreshSection("appSettings");
}
#endregion
private void GetConnectionString()
{
Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
ConfigurationSection section = config.ConnectionStrings;
for (int i = 0; i < config.ConnectionStrings.ConnectionStrings.Count; i++)
{
string connectionName = config.ConnectionStrings.ConnectionStrings[i].Name;
if (connectionName == "milnets")
{
string connectionString = config.ConnectionStrings.ConnectionStrings[i].ConnectionString;
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(connectionString);
RegExTextBox_Server.Text = builder.DataSource;
RegExTextBox_uid.Text = builder.UserID;
RegExTextBox_pwd.Text = builder.Password;
RegExTextBox_Database.Text = builder.InitialCatalog;
break;
}
}
RegExTextBox_LibCode.Text = ConfigurationManager.AppSettings["LibCode"];
}
private void SaveConnectionString(string connectionString, string libcode)
{
Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
ConfigurationSection section = config.ConnectionStrings;
for (int i = 0; i < config.ConnectionStrings.ConnectionStrings.Count; i++)
{
if (config.ConnectionStrings.ConnectionStrings[i].Name == "milnets")
{
config.ConnectionStrings.ConnectionStrings[i].ConnectionString = connectionString;
}
}
config.AppSettings.Settings.Clear();
config.AppSettings.Settings.Add("LibCode", libcode);
config.Save(ConfigurationSaveMode.Full);
ConfigurationManager.RefreshSection("dataConfiguration");
ConfigurationManager.RefreshSection("connectionStrings");
ConfigurationManager.RefreshSection("appSettings");
}
#endregion