Question

我犯了以下错误:

“已经是与该指挥部有关的公开数据查询,必须首先关闭。

is it because I have used the reader in foreach loop ? or what the problem might be ? Regards BK

foreach( Apple a in listApple )
{


....
                   using (SmartSqlReader reader = Db.CurrentDb.ExecuteReader(sp))
                    {
                        while (reader.Read())
                        {
                            a.blablabla += reader.GetInt32("BLA_BLA_BLA"); 
                        }
                    }


.....

}

Answer 1

如下:

using (SmartSqlReader reader = Db.CurrentDb.ExecuteReader(sp))
 {
  while (reader.Read())
  {
   a.blablabla += reader.GetInt32("BLA_BLA_BLA"); 
  }
  reader.Close();
 }

Answer 2

您在处置时是否把SmartSqlReader imp倒闭? 定期数据阅读器采用可识别的界面和电话远离处置方法。

如果你不适当地关闭,就会把指挥物体保留到停车场收集器找到读物并清理后。

Answer 3

http://www.un.org/Depts/DGACM/index_french.htm SmartSqlReader

友情链接