在做一个网页流量统计可是数据更新不到数据库 string connstring = WebConfigurationManager.ConnectionStrings["connstring"].ToString();
OleDbConnection mycon = new OleDbConnection(connstring);
mycon.Open();
string sql1 = "select sum from visits";
OleDbCommand mycmd1 = new OleDbCommand(sql1, mycon);
OleDbDataReader dr1 = mycmd1.ExecuteReader();
if (dr1.HasRows)
{
dr1.Read();
Application["renshu"] = dr1[0];
string sql = "update visits set sum=sum+1";
OleDbCommand mycmd = new OleDbCommand(sql, mycon);
OleDbConnection mycon = new OleDbConnection(connstring);
mycon.Open();
string sql1 = "select sum from visits";
OleDbCommand mycmd1 = new OleDbCommand(sql1, mycon);
OleDbDataReader dr1 = mycmd1.ExecuteReader();
if (dr1.HasRows)
{
dr1.Read();
Application["renshu"] = dr1[0];
string sql = "update visits set sum=sum+1";
OleDbCommand mycmd = new OleDbCommand(sql, mycon);
解决方案 »
- jquery 给img src 赋值
- 一个dropdownlist的selectedvalue改变,另一个dropdownlist里面的所有选项也改变,
- CloseConnection参数(数据库连接关闭)
- iframe嵌入页面后,有时右侧会出现很大一片空白
- vs2005不能浏览asp的问题
- mycommand.Parameters["@cno"].Value;
- 伺服器應用程式無法使用 ,系統管理員注意: Web 伺服器的應用程式事件記錄檔中的錯誤訊息詳細說
- 关于跨服务器上传文件的问题,大家来讨论一下啊
- datalist中的label怎么在后台去值?
- <asp:button id="btsubmit" runat="server" text="add" onclick="submit"/>出错
- 还是动态添加控件的问题
- viewstate
加上这一句后就提示sql语句错误
OleDbConnection mycon = new OleDbConnection(connstring);
mycon.Open();
string sql1 = "select sum from visits";
OleDbCommand mycmd1 = new OleDbCommand(sql1, mycon);
OleDbDataReader dr1 = mycmd1.ExecuteReader();
if (dr1.HasRows)
{
dr1.Read();
Application["renshu"] = dr1[0];
string sql = "update visits set sum=sum+1";
OleDbCommand mycmd = new OleDbCommand(sql, mycon);
OleDbDataReader dr = mycmd.ExecuteReader();
dr1.Close();
mycon.Close();
Application.Lock();
Application["renshu"] = (int)Application["renshu"] + 1;
Application.UnLock();
string ss = ((int)Application["renshu"]).ToString();
visits.Text = "";
for (int i = 0; i < ss.Length; i++)
{
visits.Text = visits.Text + "<img src='images\\" + ss.Substring(i, 1) + ".gif'>";
}
}
string sql = "update visits set sum=sum+1";
修改为
string sql = "update visits set [sum]=[sum]+1";