'）' 附近有语法错误。

Question

本帖最后由 lflsg 于 2014-12-30 09:40:18 编辑

Answer 1

  new SqlParameter("@CreateOn", createon));   两个 )

Answer 2

括号和逗号，我都检查修改了没问题了，但是还是不行                    SqlHelper.ExecuteNonQuery(@"insert into TB_News(ClassId,NewsTitle,NewsSTitle,AuthorId,NaviContent,ListImage,NewsContent,CreateOn）
                                                             values(@ClassId,@NewsTitle,@NewsStitle,@AuthorId,@NaviContent,@ListImage,@NewsContent,@CreateOn)",
                                                 new SqlParameter("@ClassId", newsclassid),
                                                 new SqlParameter("@NewsTitle",title),
                                                 new SqlParameter("@NewsStitle", stitle),
                                                 new SqlParameter("@AuthorId",row["Id"]),
                                                 new SqlParameter("@NaviContent", navicontent),
                                                 new SqlParameter("@ListImage", "/Upload/" + filename),
                                                 new SqlParameter("@NewsContent", newscontent),
                                                 new SqlParameter("@CreateOn", createon));

Answer 3

 SqlHelper.ExecuteNonQuery(@"insert into TB_News(ClassId,NewsTitle,NewsSTitle,AuthorId,NaviContent,ListImage,NewsContent,CreateOn）
                                                             values(@ClassId,@NewsTitle,@NewsStitle,@AuthorId,,@NaviContent,@ListImage,@NewsContent,@CreateOn)",

Answer 4

都调试了不会把sql语句提取出来再数据库执行一下？

Answer 5

请研究一下这个方法ExecuteNonQuery()，sql语句和参数一起传入！！！
不防试这个逻辑类:
http://www.cnblogs.com/insus/p/4156735.html

Answer 6

2个错误 
第一@AuthorId,,@ 部分 有2个,第二CreateOn） values 部分是中文的右括号.