Question

c#问题，急急急急急急急急急！！！！！！！！！

c#代码问题，根据ID修改姓名和密码，麻烦高手看看是不是sql语句错误了！！！！！！
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source = (local); initial catalog = gui; integrated security=True";
conn.Open();
string strUpdate = "[密码] = '" + mima.Text + "'" + "[姓名] = '" + name.Text + "'";
string strCmd = "update 员工信息 set " + strUpdate + " where ID = '" + textBox1.Text + "'";
SqlCommand sc = new SqlCommand(strCmd, conn);
sc.ExecuteNonQuery();
conn.Close();
MessageBox.Show("员工信息修改成功");
}

Answer 1

string strUpdate = "[密码] = '" + mima.Text + "'" +","+ "[姓名] = '" + name.Text + "'";加个逗号试试

Answer 2

把你组合的Sql输出一次,拷贝到Sql里面去测试就知道了.这东西谁拿着不debug都没结果.

Answer 3

string strUpdate = "[密码] = '" + mima.Text + "'" + "[姓名] = '" + name.Text + "'";
少了一个","
string strUpdate = "[密码] = '" + mima.Text + "'" + ",[姓名] = '" + name.Text + "'";