例外：数据视图中的行筛选 [英] Exception : Row Filter in data view

问题描述

我有一个像过滤器一样excel的应用程序，并在数据视图中应用过滤器时出现异常...

过滤器表达式长度为112253，表达式字符串类似于（1 = 1和（strDate = '03 -Jun-2014 00：03'或strDate = '03 -Jun-2014 04:08'或strDate = '03 -Jun-2014 04:09'.............. ）





例外是：



未处理的类型异常System.Data.dll中发生'System.StackOverflowException'

I have an application having excel like filter and got exception while apply filter in Data View...
The filter expression length is 112253 and expression string is like (1=1 and ( strDate='03-Jun-2014 00:03' Or strDate='03-Jun-2014 04:08' Or strDate='03-Jun-2014 04:09' ..............)


The exception is:

An unhandled exception of type 'System.StackOverflowException' occurred in System.Data.dll

推荐答案

问题的答案是简化过滤器。



尝试在源头而不是在数据视图中过滤数据



如果你真的要降低到特定时间的检查水平然后使用范围比较，不要列出所有单独的时间。

The answer to your problem is simplify your filter.

Try to filter the data at source rather than in the data view itself

If you are really going to down to the level of checking for specific times then use a range comparison, don't list all of the individual times.

这篇关于例外：数据视图中的行筛选的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！