语法错误 (操作符丢失) 在查询表达式 '1WHERE ID=1' 中。各位大哥高手看看。

[s330404]

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;

namespace news
{
/// <summary>
/// shownews 的摘要说明。
/// </summary>
public class shownews : System.Web.UI.Page
{
public DataRow dr;
protected System.Web.UI.WebControls.AdRotator AdRotator1;
public String newsid;

private void Page_Load(object sender, System.EventArgs e)
{
newsid =Request.Params["ID"];
//建立数据库连接
OleDbConnection myConnection=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+Server.MapPath("news.mdb"));
//创建OleDbDataAdapter对象，按照指定的查询语句获取结果
OleDbDataAdapter myCommand=new OleDbDataAdapter("select*FROM Contents WHERE ID="+newsid,myConnection);
//将结果填充到DATASET上
DataSet ds=new DataSet();
myCommand.Fill(ds,"Contents");
dr=ds.Tables["Contents"].Rows[0];
//创建OLEDBDATAADAPTER对象，获取指定编号新闻的访问次数
OleDbCommand myCommand2=new OleDbCommand("select click from Contents where ID="+newsid,myConnection);
myCommand2.Connection.Open();
OleDbDataReader reader=myCommand2.ExecuteReader();
reader.Read();
//将访问次数转换成整数，然后再加一
int i=reader.GetInt32(0);
i++;
reader.Close();
//重新定义SQL语句，更新访问次数
myCommand2.CommandText="UPDATE Contents SET click="+i.ToString()+"WHERE ID="+newsid;
myCommand2.ExecuteNonQuery();
myCommand2.Connection.Close();
myConnection.Close();
}

protected string FormatString(string str)
{
str=str.Replace(" ","  ");
str=str.Replace("<","<");
str=str.Replace(">",">");
str=str.Replace('\n'.ToString(),"<br>");
return str;
}




}
}

[孟子E章]

myCommand2.CommandText="UPDATE Contents SET click="+i.ToString()+" WHERE ID="+newsid;

空格

[tengfeng8888]

" WHERE ID="+newsid; 是空格问题

[dcbr4]

对头

[chenhaoying]

sql语句别写太紧，很容易连起来的，多打几个空格没影响。

[daishengs]

myCommand2.CommandText="UPDATE Contents SET click="+i.ToString()+" WHERE ID="+newsid;

[Aricc]

听一楼的，没错！哈哈