Question

c# '=' 附近有语法错误。

private void button4_Click(object sender, EventArgs e)
{
string connectionString = "data source=localhost;user id=sa;pwd=123456;database=student;";
SqlConnection con = new SqlConnection();
con.ConnectionString = connectionString;
string cmdText = "updata student set name ='" + textBox3.Text + "', birthday = '" + textBox4.Text + "',gender = '" + textBox5.Text + "',address = '" + textBox6.Text + "' where studentnum = '" + textBox2.Text + "'";
SqlCommand cmd = new SqlCommand(cmdText, con);
try
{
con.Open();
cmd.ExecuteNonQuery();
}

finally { con.Close(); }

}

Answer 1

string tianjia1 = "insert into list(学号，姓名，专业，性别，民族，导师) values('" + textBox13 + "','" + textBox14 + "','" + textBox15 + "','" + textBox16 + "','" + textBox17 + "','" + textBox18 + "',）";

最后一个括号左边那个逗号是多余的

string tianjia1 = "insert into list(学号，姓名，专业，性别，民族，导师) values('" + textBox13 + "','" + textBox14 + "','" + textBox15 + "','" + textBox16 + "','" + textBox17 + "','" + textBox18 + "'）";

Answer 2

提示已经很明确了呀~~你的整型字段没有给到值,提示出错,如:
studentnum = '" + textBox2.Text + "'";
建议跟踪一下语句!

Answer 3

updata 改为update,然后再打断点跟一下这个SQL语句，在放到数据库中执行一下，以后遇到类似的问题都可以这么做，试试吧。

Answer 4

调试.看下cmdText这个变量是什么值，复制出来在查询分析器里面执行一下.

Answer 5

string cmdText = "updata student set name ='"中的update