请问C#连接数据库报错，“=”附近有语法，该怎么解决？

Question

DataSet ds;DataRow dr;string newsid;void Page_Load(Object sender, EventArgs e){SqlConnection MyConnection;string ConnStr, strCon;newsid = Request.Params["id"]; MyConnection = new SqlConnection("server=ADMIN-PC;database=news;uid=sa;pwd='123456'");MyConnection.Open();string strCom = "Select biaoti,zhaizi,neirong,img,counter,shijian from news where id=" + newsid;ds = new DataSet();SqlDataAdapter myCommand = new SqlDataAdapter(strCom, MyConnection);myCommand.Fill(ds, "news");dr = ds.Tables["news"].Rows[0];strCon = "Select counter from news where id=" + newsid;SqlCommand mycommand2 = new SqlCommand(strCon, MyConnection);SqlDataReader reader = mycommand2.ExecuteReader();reader.Read();int i = reader.GetInt32(0);i++;reader.Close(); strCon = "Update news set counter=" + i.ToString() + "where (id=" + newsid + ")";mycommand2.CommandText = strCon;mycommand2.ExecuteNonQuery(); MyConnection.Close(); }

Answer 1

这个肯定是SQL语句的错误
Select biaoti,zhaizi,neirong,img,counter,shijian from news where id=' "+ newsid+"'
Select counter from news where id=' "+ newsid+"'
Update news set counter=" + i.ToString() + "where (id=" + newsid + ")
前两条错了 在sql2005修改后之后通过

Answer 2

strCon = "Update news set counter=" + i.ToString() + "where (id=" + newsid + ")";
在where前加一个空格