Question

ASP.NET数据库调用问题

<asp:DataList ID="DataList1" runat="server" DataSourceID="AccessDataSource1"
RepeatDirection="Horizontal">
<ItemTemplate>
biaoti:
<asp:Label ID="biaotiLabel" runat="server" Text='<%# Eval("biaoti") %>'></asp:Label><br />
<br />
</ItemTemplate>
</asp:DataList><asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/news.mdb"
SelectCommand="SELECT [biaoti] FROM [jiaocheng] ORDER BY [id] DESC, [biaoti] DESC">
</asp:AccessDataSource>如何修改让其只显示5条最新的记录

Answer 1

SELECT top (5) [biaoti] FROM [jiaocheng] ORDER BY [id] DESC, [biaoti] DESC 加上一个top （）括号里写你要显示的条数就行了

Answer 2

select top 5 ...
order by id desc

or if you have date related to the records,
order by date desc

Answer 3

你也说了，要看记录，还是要看最新的，So。。查数据库，sql语句top5就好了