C# 提示DataReader must be closed first 咋办呀
public static SEO GetAllSEOBySEOID(int SEOID){
string sql = "select * from SEO Where SEOID=@SEOID";
SqlDataReader reader = DBHelper.GetReader(sql, new SqlParameter("@SEOID", SEOID));
if (reader.Read())
{
SEO seo = new SEO();
seo.SEOID = SEOID;
seo.SEOTitle = reader["SEOTitle"].ToString();
seo.SEODescription = reader["SEODescription"].ToString();
seo.SEOKeyword = reader["SEOKeyword"].ToString();
reader.Close();
return seo;
}
else
{
reader.Close();
return null;
}
经常出现 There is already an open DataReader associated with this Command which must be closed first. 错误提示,这该如何改写呀。。。。
--------------------编程问答-------------------- There is already an open DataReader associated with this Command which must be closed first这句话意思是:已经有一个开放的DataReader相关的命令必须关闭第一
你这个方法前面可能有DataReader未关闭, --------------------编程问答-------------------- seo是个类
那如何关闭呀 --------------------编程问答-------------------- 每次读取数据完把datareader关闭… --------------------编程问答-------------------- 具体咋写呀,俺一点不懂
补充:.NET技术 , C#