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