c# - ConnectionString 中的可变密码

Question

我创建了连接字符串:

connection.ConnectionString = @"Provider=abcdef; Server=123....; Database=abc; User Id=user; Password=xyz"; 

效果很好。我想用变量交换密码:

connection.ConnectionString = @"Provider=abcdef; Server=123....; Database=abc; User Id=user; Password="+textBox1.Text;

我的程序显示错误:

Login failed for user: user... (textBox.Text = "xyz")

你知道如何正确地与变量交换密码吗？

Answer 1

使用SqlConnectionStringBuilder类。

static void Main()
{
    SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(connectionString);
    builder.Password = "YourNewPassword";
    string newConnectionString = builder.ConnectionString;
}