System.Data.SqlClient.SqlException: '0' 附近有语法错误。

Question

行 78:
行 79: cmd = new SqlCommand(str, sqlcon);
行 80: cmd.ExecuteNonQuery();
行 81: str = "insert into FrequencyData_table (ID,Start,Stop,InceptStart, InceptEnd,SendFre,ReceiveFre,BandWidth,Mode) values(" + int.Parse(TextBox9.Text.Trim()) + "," + float.Parse(TextBox10.Text.Trim()) + "," + float.Parse(TextBox11.Text.Trim()) + "," + float.Parse(TextBox12.Text.Trim()) + "," + float.Parse(TextBox17.Text.Trim()) + "," + float.Parse(TextBox13.Text.Trim()) + "," + float.Parse(TextBox14.Text.Trim()) + "," + float.Parse(TextBox15.Text.Trim()) + ",'" + TextBox16.Text.Trim() + "')";
行 82: cmd = new SqlCommand(str, sqlcon);

它老说第80行有错~~我现在的页面实现不了把数据存入数据库~~那位大侠能帮帮我呢~~谢谢啦

Answer 1

sql语句写错了

Response.Write(str);

把后面的注销，用这句输出一下放到sql里一执行你就明白了

Answer 2

上面的代码顺序有误……
str = "insert into FrequencyData_table (ID,Start,Stop,InceptStart, InceptEnd,SendFre,ReceiveFre,BandWidth,Mode) values(" + int.Parse(TextBox9.Text.Trim()) + "," + float.Parse(TextBox10.Text.Trim()) + "," + float.Parse(TextBox11.Text.Trim()) + "," + float.Parse(TextBox12.Text.Trim()) + "," + float.Parse(TextBox17.Text.Trim()) + "," + float.Parse(TextBox13.Text.Trim()) + "," + float.Parse(TextBox14.Text.Trim()) + "," + float.Parse(TextBox15.Text.Trim()) + ",'" + TextBox16.Text.Trim() + "')";

cmd = new SqlCommand(str, sqlcon);

cmd.ExecuteNonQuery();

Answer 3

你拼的t-sql语句应该是有问题的 看看你数据库中是否有相应的字段为非int或者money类型的 比如说是nvarchar的那种 如果有 就把你拼写的sql语句中相应的值也就是values括号中的相应值拼上"'"单引号