大家好，又见面了，我是你们的朋友全栈君。
读取
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将重新启动
}
}
转载于:https://www.cnblogs.com/leotian/archive/2008/12/02/1346004.html
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请联系我们举报，一经查实，本站将立刻删除。
发布者：全栈程序员-站长，转载请注明出处：https://javaforall.net/143478.html原文链接：https://javaforall.net
