我创建了连接字符串:
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;
我的程序显示错误:
用户登录失败:用户。。。(textBox.Text="xyz")
你知道如何正确地用变量交换密码吗?
使用SqlConnectionStringBuilder类。
static void Main()
{
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(connectionString);
builder.Password = "YourNewPassword";
string newConnectionString = builder.ConnectionString;
}
使用SqlConnectionStringBuilder
:
var csb = new SqlConnectionStringBuilder(<<your connection string>>);
csb.Password = "xyz";
string connectionString = csb.ConnectionString;
connection.ConnectionString = string.Format("Provider=abcdef; Server=123....; Database=abc; User Id=user; Password={0}", textBox1.Text);
你可以试试这个。。
string strTextBox;
private void textBox1_TextChanged(object sender, EventArgs e)
{
strTextBox= textBox1.Text;
}
您应该使用strTextBox而不是textBox1.密码为Text。