Question

ASP.NET Datalist分页?

我是初学者，大家帮我代码补充完，尽量说明，还有用什么引用也说下
源文件
<asp:DataList ID="DataList1" runat="server" DataKeyField="编号" DataSourceID="SqlDataSource1"
RepeatColumns="4" RepeatDirection="Horizontal">
<ItemTemplate>
<a href="diaodingdan.aspx?ia=<%# DataBinder.Eval(Container.DataItem,"编号") %>"><img width="160" height="73" border="0" src="../pic/<%# DataBinder.Eval(Container.DataItem,"图片") %>" /><br /></a><asp:Label ID="名称Label" runat="server" Text='<%# Eval("名称") %>'></asp:Label><br />
</ItemTemplate>
</asp:DataList>
<asp:LinkButton ID="LinkButton1" runat="server" Font-Size="12px" CommandName="shouye" OnCommand="page_onclick">首页</asp:LinkButton>
<asp:LinkButton ID="LinkButton2" runat="server" Font-Size="12px" CommandName="prev" OnCommand="page_onclick">上页</asp:LinkButton>
<asp:LinkButton ID="LinkButton3" runat="server" Font-Size="12px" CommandName="next" OnCommand="page_onclick">下页</asp:LinkButton>
<asp:LinkButton ID="LinkButton4" runat="server" Font-Size="12px" CommandName="weiye" OnCommand="page_onclick">尾页</asp:LinkButton>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Data Source=localhost;Initial Catalog=hemeida;Integrated Security=True"
ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM [吊顶表] WHERE ([类] = @类)">
<SelectParameters>
<asp:QueryStringParameter DefaultValue="1" Name="类" QueryStringField="id" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
代码文件
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;public partial class web_diaoding : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection conm = new SqlConnection();
conm.ConnectionString = "server=localhost;database=hemeida;integrated security=sspi";
conm.Open();

}
}
帮我做出对Datalist里面用SQL绑定的数据表里的数据进行分页，分页效果为 首页 上一页 下一页 尾页

Answer 1

select top a * from xxx
where id not in
(select top b id from xxx)
a为每页显示的条数
b为（当前页数-1）*a
如每页5条显示第二页就是a=5,b=(2-1)*5=5

大体思路就芦咐是陪槐纯这明册个

Answer 2

使用PagedDataSource控件可以快速的实现分页！

Answer 3

aspnetpager 控件实现分页 非常简单

Answer 4

你先在数据库中举则写个存储过程。提供三个参数，一个总行数正樱棚count 分好多页pageindex,还有很页多少行pagesize
然后再到颂昌前台写代码就行了。