VS2005里怎样修改配置文件里的数据库连接字符串？

Question

VS2005提供了ConfigurationManager(添加-引用System.Configuration.dll)类。可以通过
Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);config.ConnectionStrings.ConnectionStrings.Add(
   new ConnectionStringSettings("MyConnectionString", "Server=server;User ID=..."));config.Save();来向WindowsApplication1.exe.config文件增加连接字符串信息。不过怎样修改呢？

Answer 1

config.ConnectionStrings.ConnectionStrings["MyConnectionString"].ConnectionString = "Server=server;User ID=...";

Answer 2

to: jetxiapublic static ConnectionStringSettingsCollection ConnectionStrings { get; }也就是说ConfigurationManger.ConnectionStrings是只读的。

Answer 3

对不起， jetxia回复的对。Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);config.ConnectionStrings.ConnectionStrings["MyConnectionString"].ConnectionString = "Data Source=***;User ID=***;Password=***";config.Save();

Answer 4

VS2005提供了ConfigurationManager(添加-引用System.Configuration.dll)类。可以通过
Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);config.ConnectionStrings.ConnectionStrings.Add(
   new ConnectionStringSettings("MyConnectionString", "Server=server;User ID=..."));config.Save();来向WindowsApplication1.exe.config文件增加连接字符串信息。不过怎样修改呢？
我这样设置了怎么把他读取出来

Answer 5

config.ConnectionStrings.ConnectionStrings["MyConnectionString"].ConnectionString = "Server=server;User ID=...";

Answer 6

怎么读取啊
是这样吗
            ConnectionStringsSection conn = new ConnectionStringsSection();
             conn.ConnectionStrings["MyConnectionString"].ConnectionString.ToString();