如何实现过滤数据跟高效分页两个功能
各位高手求指点迷津啊?我用ListView+DataPage实现高效分页,但是想同时实现过滤数据的时候就不知道怎么做了,难道要自己开发一个DataPage么?代码如下
SELECT *FROM (SELECT CustomID, Name, OpenDate, BankNum, ProductID, AccountType, TelePhone, Email, Reamark, Row_Number() OVER(ORDER BY CustomID) rownumFROM dbo.V_Custom) tWHERE t .rownum > @startRowIndex AND t .rownum <= @startRowIndex + @maximumRows
SELECT COUNT(*) FROM Custom
<asp:ObjectDataSource ID="Obscustom" runat="server" OldValuesParameterFormatString="original_{0}" SelectMethod="GetPageData" TypeName="XTWeb.DAL.DataSetCustomTableAdapters.CustomTableAdapter" EnablePaging="True" SelectCountMethod="QueryCount" > </asp:ObjectDataSource>