第 1 行: '=' 附近有语法错误,麻烦大家看看
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。
异常详细信息: System.Data.SqlClient.SqlException: 第 1 行: '=' 附近有语法错误。
源错误:
| 行 22: SqlDataAdapter dad4 = new SqlDataAdapter("select * from news where nid=" + newsid, con);行 23: DataSet dst = new DataSet();行 24: dad4.Fill(dst, "news2");行 25: dr = dst.Tables["news2"].Rows[0];行 26: |
源文件: c:\Inetpub\wwwroot\cms1\shownews.aspx.cs
行: 24
public DataRow dr;
public string newsid;
protected void Page_Load(object sender, EventArgs e)
{
newsid = Request.Params["nid"];
SqlConnection con = DB.con();
SqlDataAdapter dad4 = new SqlDataAdapter("select * from news where nid=" + newsid, con);
DataSet dst = new DataSet();
dad4.Fill(dst, "news2");
dr = dst.Tables["news2"].Rows[0];
SqlCommand cmd = new SqlCommand("select * from news where nid=" + newsid, con);
con.Open();
SqlDataReader dr1 = cmd.ExecuteReader();
int i = Convert.ToInt32(dr["onclick"]);
i++;
dr1.Close();
cmd.CommandText = "update news set onclick='" + i.ToString() + "'where nid=" + newsid;
cmd.ExecuteNonQuery();
con.Close();
}
看来看去,都搞不定,请各位赐教!