异常详细信息: System.Data.OleDb.OleDbException: INSERT INTO 语句的语法错误。
行 39: ConnStr="Insert Into news(biaoti,zhaizi,neirong,shijian,img,counter) VALUES('"+biaoti.Text+"', '"+zhaizi.Text+"', '"+neirong2+"', '"+now.ToString()+"', '"+img.Text+"',0)";
行 39: ConnStr="Insert Into news(biaoti,zhaizi,neirong,shijian,img,counter) VALUES('"+biaoti.Text+"', '"+zhaizi.Text+"', '"+neirong2+"', '"+now.ToString()+"', '"+img.Text+"',0)";
建议用
ConnStr="Insert Into news(biaoti,zhaizi,neirong,shijian,img,counter)
VALUES
(?, ?, ?, ?, ?,0)";
然后用
myCommand.CommandText = ConnStr;
myCommand.Parameters.Add("biaoti",OleDbType.VarChar);
myCommand.Parameters["biaoti"].Value = biaoti.Text
剩下的不说了都一样
Server.UrlEncode()
Server.UrlDecode()
来解决
中间加个空格间隔一下
er) VALUES ('
改成这样试下
建议用
ConnStr="Insert Into news(biaoti,zhaizi,neirong,shijian,img,counter)
VALUES
(?, ?, ?, ?, ?,0)";
然后用
myCommand.CommandText = ConnStr;
myCommand.Parameters.Add("biaoti",OleDbType.VarChar);
myCommand.Parameters["biaoti"].Value = biaoti.Text
剩下的不说了都一样
就按人家说得做,没错