DataView dbview = allData.DefaultView;
dbview.RowFilter="modifyDate between convert(datetime,'2011-10-1 0:00:00') and convert(datetime,'2011-10-2 0:00:00')"
程序报错:表达式包含不支持的运算符“Between”。这个RowFilter不支持Between and操作么?
dbview.RowFilter="modifyDate between convert(datetime,'2011-10-1 0:00:00') and convert(datetime,'2011-10-2 0:00:00')"
程序报错:表达式包含不支持的运算符“Between”。这个RowFilter不支持Between and操作么?
DataView dbview = allData.DefaultView;
dbview.RowFilter="modifyDate >= convert(datetime,'2011-10-1 0:00:00') and modifyDate <= convert(datetime,'2011-10-2 0:00:00')" 另外,有些数据库函数可能也不能用的