问题遇到的现象和发生背景
LISTVIEW设置高效翻页,报错,同样的操作如果数据集连的是sqlserver的数据库就没问题。但数据集连的是oracle的数据库就一直报错,劳烦指点。
问题相关代码,请勿粘贴截图
数据集sql:
select t.PATIENT_NO, t.NAME, t.STATE, t.DEPT_NAME, t.RECORD_STATE, t.RECORD_NAME from (SELECT PATIENT_NO, NAME, INPATIENT_NO, STATE, DEPT_NAME, RECORD_STATE, RECORD_NAME,ROW_NUMBER() OVER(order by PATIENT_NO) RN FROM "SYSTEM".NURSE_RECORD_DETAILE) t where t.RN>:startRowIndex and t.RN<=:startRowIndex+:maximumRows
运行结果及报错内容
[ArgumentOutOfRangeException: 容量小于当前大小。
参数名: value]
System.Collections.ArrayList.set_Capacity(Int32 value) +12830830
System.Web.UI.WebControls.ListView.CreateChildControls(IEnumerable dataSource, Boolean dataBinding) +664
System.Web.UI.WebControls.ListView.PerformDataBinding(IEnumerable data) +35
System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data) +133
System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +34
System.Web.UI.WebControls.DataBoundControl.PerformSelect() +151
System.Web.UI.WebControls.ListView.PerformSelect() +103
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +76
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +114
System.Web.UI.WebControls.ListView.CreateChildControls() +52
System.Web.UI.Control.EnsureChildControls() +97
System.Web.UI.Control.PreRenderRecursiveInternal() +42
System.Web.UI.Control.PreRenderRecursiveInternal() +163
System.Web.UI.Control.PreRenderRecursiveInternal() +163
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +906
我的解答思路和尝试过的方法
考虑过oracle和.net不兼容,我把datetime的字段都去掉了,不行!按照网上几个办法试了也不行,求老手指点迷津,搞崩溃了。