C#修改connectionStrings的方法

读取
        protected void Page_Load(object sender, EventArgs e)
        {
            CheckLogin MyChk = new CheckLogin();
            title.InnerHtml = "<b>数据库连接配置</b>";


            if (!IsPostBack)
            {
                Configuration config = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration(HttpContext.Current.Request.ApplicationPath);
                string myConnect = config.ConnectionStrings.ConnectionStrings["MyApp.Properties.Settings.SqlConnectSetting"].ToString();

                string[] arycon = myConnect.Split(';');
                int i, li_index;
                for (i = 0; i < arycon.Length; i++)
                {
                    if (arycon[i].IndexOf("Data Source") > -1)
                    {
                        li_index = arycon[i].IndexOf("=");
                        TextBox1.Text = arycon[i].Substring(li_index + 1);
                    }
                    if (arycon[i].IndexOf("Initial Catalog") > -1)
                    {
                        li_index = arycon[i].IndexOf("=");
                        TextBox2.Text = arycon[i].Substring(li_index + 1);
                    }
                    if (arycon[i].IndexOf("User ID") > -1)
                    {
                        li_index = arycon[i].IndexOf("=");
                        TextBox3.Text = arycon[i].Substring(li_index + 1);
                    }
                    if (arycon[i].IndexOf("Password") > -1)
                    {
                        li_index = arycon[i].IndexOf("=");
                        TextBox4.Text = arycon[i].Substring(li_index + 1);
                    }
                }
            }
        }
修改
        protected void Button1_Click(object sender, EventArgs e)
        {
            string ls_newstring = "Data Source=" + TextBox1.Text.Trim() + ";Initial Catalog=" + TextBox2.Text.Trim() + ";Persist Security Info=True;User ID=" + TextBox3.Text.Trim() + ";Password=" + TextBox4.Text.Trim();
            
            Configuration config = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration(HttpContext.Current.Request.ApplicationPath);
            string csName = "MyApp.Properties.Settings.SqlConnectSetting";

            ConnectionStringsSection csSection = config.ConnectionStrings;
            csSection.ConnectionStrings[csName].ConnectionString = ls_newstring;

            config.Save(ConfigurationSaveMode.Modified);

            //IIS将重新启动
        }
    }



评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值