后台代码: void tuto1()
{
OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("/App_Data/ps.mdb"));//建立数据库连接
con.Open();
OleDbCommand com = con.CreateCommand();
string str = "select Top 8 * from Article order by ArticleAddTime DESC";
OleDbDataAdapter oleda = new OleDbDataAdapter(str, con);
DataSet ds = new DataSet();
oleda.Fill(ds);
this.DataList1.DataSource = ds;
this.DataList1.DataBind();
}
前台代码:<asp:DataList ID="DataList1" runat="server" Width="352px">
<ItemTemplate>
<table style="width: 310px;">
<tr>
<td style="width: 20px;">
<img src="Images/arr.gif" /></td>
<td style="width: 230px;">
<a href='<%# "ShowNews.aspx?newsid=" + Eval("ArticleId") %>'><%# Eval("ArticleTitle") %></td>
<td style="width: 60px;">
<%# Eval("ArticleAddTime","{0:MM-dd}") %></td>
</tr>
</table>
</ItemTemplate>
</asp:DataList>为什么会出现数据数量不正确???我分明是取前8的!!可是显示了前10!!真是郁闷啊!!!
{
OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("/App_Data/ps.mdb"));//建立数据库连接
con.Open();
OleDbCommand com = con.CreateCommand();
string str = "select Top 8 * from Article order by ArticleAddTime DESC";
OleDbDataAdapter oleda = new OleDbDataAdapter(str, con);
DataSet ds = new DataSet();
oleda.Fill(ds);
this.DataList1.DataSource = ds;
this.DataList1.DataBind();
}
前台代码:<asp:DataList ID="DataList1" runat="server" Width="352px">
<ItemTemplate>
<table style="width: 310px;">
<tr>
<td style="width: 20px;">
<img src="Images/arr.gif" /></td>
<td style="width: 230px;">
<a href='<%# "ShowNews.aspx?newsid=" + Eval("ArticleId") %>'><%# Eval("ArticleTitle") %></td>
<td style="width: 60px;">
<%# Eval("ArticleAddTime","{0:MM-dd}") %></td>
</tr>
</table>
</ItemTemplate>
</asp:DataList>为什么会出现数据数量不正确???我分明是取前8的!!可是显示了前10!!真是郁闷啊!!!
移动硬盘 10-19
环境卡红点颏按时打算按时到达盛大 10-18
1111 10-16
qwe 10-16
qqq 10-14
111 10-14
qqq 10-14
111 10-14
的佛挡杀佛 10-10