读书人

急Gridview不分页兑现pagesize功能

发布时间: 2012-07-04 19:33:55 作者: rapoo

急急急:::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'

读书人网 >asp.net

热点推荐