Question

c#修改数据库数据总说'123456' 附近有语法错误。怎么改？

SqlConnection conConnection = new SqlConnection(strConnect);

string cmd = "update Users set 昵称='" + textBox1.Text + "',年龄=" + textBox2.Text + ",性别='" + a + "',密码'" + textBox4.Text + "',姓名='" + textBox5.Text + "',生日='" + textBox6.Text + "',住址='" + textBox7.Text + "',邮箱='" + textBox8.Text + "',爱好='" + textBox9.Text + "',特长='" + textBox10.Text +"' where[ 账号]='123456'";
SqlCommand com=new SqlCommand (cmd,conConnection );
conConnection.Open();
com.ExecuteNonQuery();
conConnection.Close();

Answer 1

"',密码'" 改为 "',密码='"
+"' where[ 账号]='123456'" 改为 +"' where [ 账号]='123456'"

追问

对了，是账号没有[],谢谢！

Answer 2

1 SqlCommand com=new SqlCommand (cmd,conConnection);
应该是SqlCommand com=new SqlCommand (cmd.conConnection);
改完再试试

Answer 3

你能把sql 拿出来嘛 这个太乱了 不好看 你在那做个断点 你把cmd的值 追问给我

追问

cmd的值是修改之后的