下面一段程序,那里还没有关闭啊?
SqlCommand pcmd = new SqlCommand();
//遍历FORM表单
for(int ii=0;ii<Request.Form.Count;ii++)
{
if(Request.Form[ii].ToString().Trim()!="" && Xh_Class.IsNumeric(Request.Form[ii].ToString().Trim()))
{
pcmd.CommandText = "update tb_votequestion set ps=ps+1 where id="+Request.Form[ii].ToString().Trim();
pcmd.Connection = MyConn;
pcmd.Connection.Open();
pcmd.ExecuteNonQuery();
pcmd.CommandText = "update tb_votetitle set vcount=vcount+1 where id="+Request.Form.Keys[ii].ToString();
pcmd.ExecuteNonQuery();
pcmd.Dispose();
MyConn.Close();
}
else if(Request.Form[ii].ToString().Trim().IndexOf(',')!=-1)
{
string strNum=Request.Form[ii].ToString().Trim();
string strId=Request.Form.Keys[ii].ToString();
string [] sz=strNum.Split(',');
for(int jj=0;jj<sz.Length;jj++)
{
pcmd.CommandText = "update tb_votequestion set ps=ps+1 where id="+sz[jj];
pcmd.Connection = MyConn;
pcmd.Connection.Open();
pcmd.ExecuteNonQuery();
}
pcmd.CommandText = "update tb_votetitle set vcount=vcount+1 where id="+strId;
pcmd.ExecuteNonQuery();
pcmd.Dispose();
MyConn.Close();
}
}
pcmd.Dispose();
MyConn.Close();
SqlCommand pcmd = new SqlCommand();
//遍历FORM表单
for(int ii=0;ii<Request.Form.Count;ii++)
{
if(Request.Form[ii].ToString().Trim()!="" && Xh_Class.IsNumeric(Request.Form[ii].ToString().Trim()))
{
pcmd.CommandText = "update tb_votequestion set ps=ps+1 where id="+Request.Form[ii].ToString().Trim();
pcmd.Connection = MyConn;
pcmd.Connection.Open();
pcmd.ExecuteNonQuery();
pcmd.CommandText = "update tb_votetitle set vcount=vcount+1 where id="+Request.Form.Keys[ii].ToString();
pcmd.ExecuteNonQuery();
pcmd.Dispose();
MyConn.Close();
}
else if(Request.Form[ii].ToString().Trim().IndexOf(',')!=-1)
{
string strNum=Request.Form[ii].ToString().Trim();
string strId=Request.Form.Keys[ii].ToString();
string [] sz=strNum.Split(',');
for(int jj=0;jj<sz.Length;jj++)
{
pcmd.CommandText = "update tb_votequestion set ps=ps+1 where id="+sz[jj];
pcmd.Connection = MyConn;
pcmd.Connection.Open();
pcmd.ExecuteNonQuery();
}
pcmd.CommandText = "update tb_votetitle set vcount=vcount+1 where id="+strId;
pcmd.ExecuteNonQuery();
pcmd.Dispose();
MyConn.Close();
}
}
pcmd.Dispose();
MyConn.Close();
解决方案 »
- 为什么点击TreeView前面的状态条就触发事件
- (解决后帖子加到100分)写个控件,在TextBox的基础上加一个onkeyup事件?
- 散分了,回归C#了
- 多个dropdownlist控件的使用
- 语句问题,大家帮我看下。谢谢!
- json格式的问题 可是我不会 求指教 十万火急
- 请问怎样将一个WEB控件的Enabled属性设置FLASE;(菜鸟初学)
- 真是怪事,我得.net2003不能新建项目,怎么回事???
- 小弟遇到的一个DATAGRID排序问题,请高手指教
- Excel与图表问题.
- 菜鸟请教:求JS的代码示例,请指点…………
- IButtonControl 是个interface, 怎么会有property的东西要implement 呢?
pcmd.ExecuteNonQuery();
con.close();
con.open();
pcmd.CommandText = "update tb_votetitle set vcount=vcount+1 where id="+Request.Form.Keys[ii].ToString();
pcmd.ExecuteNonQuery();
{
pcmd.CommandText = "update tb_votequestion set ps=ps+1 where id="+sz[jj];
pcmd.Connection = MyConn;
pcmd.Connection.Open();
pcmd.ExecuteNonQuery();
}
---------建议不要使用这样的循环,多次访问数据库很影响dbserver的。
你可以考虑拼接sql语句,然后再执行
pcmd.Connection = MyConn;
pcmd.Connection.Open();
pcmd.ExecuteNonQuery();
pcmd.Connection.Close();
MyConn.Open(); //加上这两句试一下
pcmd.CommandText = "update tb_votetitle set vcount=vcount+1 where id="+Request.Form.Keys[ii].ToString();
pcmd.ExecuteNonQuery();
pcmd.Dispose();
MyConn.Close();