Question

在c#中，语句update语句有什么问题？

string cmdstring = "update [user] set xingming='" + TextBox2.Text
+ "',xuehao='" + TextBox3.Text
+ "',xingbie='" + TextBox4.Text
+ "',qq='" + TextBox5.Text
+ "',dianhua='" + TextBox6.Text
+ "',youxiang='" + TextBox7.Text +" where username='"+ Session["myname"].ToString() + "'";

Answer 1

不要这样拼接语然，使用String.Format()
string cmdstring = "update [user] set xingming='" + TextBox2.Text
+ "',xuehao='" + TextBox3.Text
+ "',xingbie='" + TextBox4.Text
+ "',qq='" + TextBox5.Text
+ "',dianhua='" + TextBox6.Text
+ "',youxiang='" + TextBox7.Text +{这里少了个单引号'}" where username='"+ Session["myname"].ToString() + "'";

Answer 2

语法错误？
同意上面的说法使用string.Format
string cmdstring=string.Format("update [user] set xingming='{0}',xuehao='{1}',xingbie='{2}'
,qq='{3}',dianhua='{4}',youxiang='{5}' where username = '{6}'
",TextBox2.Text,TextBox3.Text,TextBox4.Text,TextBox5.Text,TextBox6.Text,TextBox7.Text,Session["myname"].ToString());

Answer 3

推荐你用string.format函数。