protected void Page_Load(object sender, EventArgs e)
{
if (Request["ArticleID"].ToString() != "")
{
string dns = ConfigurationSettings.AppSettings["ConStr"];
SqlConnection myConn = new SqlConnection(dns);
string str = Page.Request["ArticleID"].ToString();
Session["ArticleID"] = str;
string Sql="update dbo.tb_Article set ViewCount=ViewCount+1 where ArticleID='" + str + "'";
SqlCommand sqlcom = new SqlCommand(Sql,myConn);
myConn.Open();
sqlcom.ExecuteNonQuery();
}
}
------解决方案--------------------------------------------------------
我猜 又是Page_load没有被调用
------解决方案--------------------------------------------------------
ViewCount=ViewCount+1整数格式?
ArticleID='" + str + "'"字符是否规范?
SqlCommand sqlcom = new SqlCommand(Sql,myConn);
myConn.Open();
sqlcom.ExecuteNonQuery();
myConn.Close();
数据打开一次必须关闭
------解决方案--------------------------------------------------------
------解决方案--------------------------------------------------------
首页确定 进入Page_load 再确定ArticleID 有值, 能进入if 里, 再确定调用数据库是否正确。
------解决方案--------------------------------------------------------
明白就好啊!