大家好,又见面了,我是你们的朋友全栈君。
读取
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
发布者:全栈程序员-用户IM,转载请注明出处:https://javaforall.cn/143478.html原文链接:https://javaforall.cn
【正版授权,激活自己账号】: Jetbrains全家桶Ide使用,1年售后保障,每天仅需1毛
【官方授权 正版激活】: 官方授权 正版激活 支持Jetbrains家族下所有IDE 使用个人JB账号...