读书人

错误详细信息: System.InvalidOperati

发布时间: 2011-12-13 21:22:18 作者: rapoo

异常详细信息: System.InvalidOperationException: 阅读器关闭时 FieldCount 的尝试无效。
阅读器关闭时 FieldCount 的尝试无效。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: System.InvalidOperationException: 阅读器关闭时 FieldCount 的尝试无效。

源错误:


行 44: dlHTDJ.DataValueField = "htdjid ";
行 45: dlHTDJ.DataSource = htlbReader;
行 46: dlHTDJ.DataBind();
行 47:
行 48: CloseConnection();


源文件: h:\ASP.NET\WebSites\WebSite2\hetong\contractedit.aspx.cs 行: 46


====================================================================================

源码是这样的,在页面的page_load里面,有
if (!IsPostBack) {
HTDJSql = "select htlbid,htlb from htlb order by htlbid ";
OleDbDataReader htlbReader = GetDataReader(HTDJSql);
dlHTLB.DataTextField = "htlb ";
dlHTLB.DataValueField = "htlbid ";
dlHTLB.DataSource = htlbReader;
dlHTLB.DataBind();
CloseConnection();
//然后检索
HTDJSql = "select htdjid,htdj from htdj order by htdjid ";
OleDbDataReader htdjReader = GetDataReader(HTDJSql);
dlHTDJ.DataTextField = "htdj ";
dlHTDJ.DataValueField = "htdjid ";
dlHTDJ.DataSource = htlbReader;
dlHTDJ.DataBind();

CloseConnection();

subDisplay();
}


其中调用了GetDataReader函数,这个函数的源码是:

public OleDbDataReader GetDataReader(string sql)


{
OleDbCommand myCmd;
myCmd = new OleDbCommand(sql, conn);

conn.Open();
return myCmd.ExecuteReader();

}

这其中的conn是定义的public OleDbConnection conn; ,请问这个问题怎么解决?个人认为这个DataReader并没有关闭啊

[解决办法]
OleDbDataReader htdjReader = GetDataReader(HTDJSql);
dlHTDJ.DataTextField = "htdj ";
dlHTDJ.DataValueField = "htdjid ";
dlHTDJ.DataSource = htlbReader;
==============================
写错了,应该是htdjReader
dlHTDJ.DataBind();

CloseConnection();
[解决办法]
OleDbDataReader htdjReader = GetDataReader(HTDJSql);
dlHTDJ.DataTextField = "htdj ";
dlHTDJ.DataValueField = "htdjid ";
dlHTDJ.DataSource = htlbReader;
===============================================
OleDbDataReader htdjReader = GetDataReader(HTDJSql);
dlHTDJ.DataTextField = "htdj ";
dlHTDJ.DataValueField = "htdjid ";
dlHTDJ.DataSource = htdjReader;

读书人网 >asp.net

热点推荐