当前位置: 代码迷 >> ASP.NET >> 急Gridview不分页兑现pagesize功能
  详细解决方案

急Gridview不分页兑现pagesize功能

热度:8587   发布时间:2013-02-25 00:00:00.0
急急急:::Gridview不分页实现pagesize功能?
用一个DataView和SqlDataSource配套使用显示数据,想不分页,但只显示数据库最后的8条记录。怎么实现呢??
  <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString31 %>"
  ProviderName="<%$ ConnectionStrings:ConnectionString31.ProviderName %>" SelectCommand='SELECT TOP 8 * FROM "INDEX_NEWS" ORDER BY "NEWS_ID" DESC'>
  </asp:SqlDataSource>


  而当我改成SelectCommand='SELECT TOP 8 * FROM "INDEX_NEWS" ORDER BY "NEWS_ID" DESC'
的时候就出错

------解决方案--------------------------------------------------------
单双引号换下行吗?
------解决方案--------------------------------------------------------
还是自己写的顺手,比较怪
------解决方案--------------------------------------------------------
SelectCommand='SELECT TOP 8 * FROM INDEX_NEWS ORDER BY NEWS_ID DESC'