50分！！就求教一个控件 DataList 怎样用来分页

[xierlovexier]

怎么用DATALIST来分页！！！！！！！！！！！！！！！！！！！！！！！

[dzvsyt]

如果用DW里的数据源，它有自动分页功能

[活靶子哥哥]

http://www.webdiyer.com

[gaoqixiang]

如果用dataset作为数据源可以直接通过取数据的数量分页。

[ysq0102]

Private Function DLBindPage()
Dim Ps As New PagedDataSource
Dim lstrsql As String
Dim DT As DataTable
lstrsql = "select * from vw_ess_enterprise_ad t"
DT = DB.getDataTable(lstrsql)
Ps.DataSource = DT.DefaultView
Ps.AllowPaging = True
Ps.PageSize = 80
Dim currentpage As Integer
If Not Request.QueryString("Page") Is Nothing Then
currentpage = Convert.ToInt32(Request.QueryString("Page"))
Else
currentpage = 1
End If
Ps.CurrentPageIndex = currentpage - 1

If Not Ps.IsFirstPage Then
lnkPrev.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(currentpage - 1) + "&p=" + Request("p")
End If

If Not Ps.IsLastPage Then
lnkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(currentpage + 1) + "&p=" + Request("p")
End If

DataList1.DataSource = Ps
DataList1.DataBind()

End Function

[Proyang]

有好多例子。。
http://dotnet.aspx.cc/ 里

[xierlovexier]

dzvsyt(一笑天)
请你具体点
谢谢！

[xierlovexier]

顶！！！！！！！！！！！！！！！！
急求用C#的解决办法

[lyfxzzb]

c#的你参考一下，根据你的实际修改修改。

int PageSize=12,CurrentPage,PageCount,RecordCount;(定义成本页.cs文件的域或属性)

private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
//得到商品的分类号


//连接语句
string xnxdgpath=HttpContext.Current.Request.ApplicationPath.Substring(1,HttpContext.Current.Request.ApplicationPath.Length-1);
string xnqjpath=HttpContext.Current.Server.MapPath("etaoyuan.mdb");
string MyConnString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+HttpContext.Current.Server.MapPath("/")+xnxdgpath+"/etaoyuan.mdb";
MyConn = new OleDbConnection(MyConnString);
MyConn.Open();

if(!Page.IsPostBack)
{

CurrentPage = 0;
ViewState["PageIndex"] = 0;
RecordCount=sumcount();
lblRecordCount.Text = RecordCount.ToString();

//计算总共有多少页
if(RecordCount%PageSize==0)
{
PageCount = RecordCount/PageSize;
}
else
{
PageCount = RecordCount/PageSize+1;
}
// PageCount = RecordCount/PageSize;
lblPageCount.Text = PageCount.ToString();
ViewState["PageCount"] = PageCount;
ListBind();



}
}
//计算共有多少记录
public int sumcount()
{
int intCount;
string strCount = "select count(*) as co from ty_mpsearch where spflbh="+id;
OleDbCommand MyComm = new OleDbCommand(strCount,MyConn);
OleDbDataReader dr = MyComm.ExecuteReader();
if(dr.Read())
{
intCount = Int32.Parse(dr["co"].ToString());
}
else
{
intCount = 0;
}
dr.Close();
return intCount;

}
public void ListBind()
{

int StartIndex;

//设定导入的起终地址
StartIndex = CurrentPage*PageSize;
string strSel = "select * from ty_mpsearch where spflbh="+id;
DataSet ds = new DataSet();

OleDbDataAdapter MyAdapter = new OleDbDataAdapter(strSel,MyConn);
MyAdapter.Fill(ds,StartIndex,PageSize,"Score");


DataList1.DataSource =ds.Tables["Score"].DefaultView;
DataList1.DataBind();

lbnNextPage.Enabled = true;
lbnPrevPage.Enabled = true;
if(CurrentPage==(PageCount-1)) lbnNextPage.Enabled = false;
if(CurrentPage==0) lbnPrevPage.Enabled = false;
lblCurrentPage.Text = (CurrentPage+1).ToString();
MyConn.Close();

}
public void Page_OnClick(Object sender,CommandEventArgs e)
{
CurrentPage = (int)ViewState["PageIndex"];
PageCount = (int)ViewState["PageCount"];

string cmd = e.CommandName;
//判断cmd，以判定翻页方向
switch(cmd)
{
case "next":
if(CurrentPage<(PageCount-1)) CurrentPage++;
break;
case "prev":
if(CurrentPage>0) CurrentPage--;
break;
}

ViewState["PageIndex"] = CurrentPage;

ListBind();

}
页面文件部分代码：
<table width="591" height="328" border="0" align="left" cellpadding="0" cellspacing="0">
<tr>
<td align="center">
<asp:DataList id="DataList1" runat="server" RepeatColumns="6" Width="100%">
<ItemTemplate>
<table width="80" height="121" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="109"><div align="center"><a href='tymphldetail.aspx?id=<%# DataBinder.Eval(Container.DataItem,"id")%>'><img src='<%# "../"+DataBinder.Eval(Container.DataItem,"picture")%>' width="79" height="102" border="1"></a></div>
</td>
</tr>
<tr>
<td width="85">
</td>
</tr>
<tr>
<td bgcolor="#4b3a74"><div align="center" class="../style2">::<a href="#"><font color="#ffffff"><%# DataBinder.Eval(Container.DataItem,"mpmc")%></font></a>::</div>
</td>
</tr>
<tr>
<td height="33"> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td height="33"> </td>
</tr>
</table>
</ItemTemplate>
</asp:DataList>
</td>
</tr>
<tr>
<td align="center"><FONT face="宋体">共有<asp:Label id="lblRecordCount" ForeColor="red" runat="server" />条记录 
当前为<asp:Label id="lblCurrentPage" ForeColor="red" runat="server" />/<asp:Label id="lblPageCount" ForeColor="red" runat="server" />页
</FONT><FONT face="宋体">
<asp:LinkButton id="lbnPrevPage" Text="上一页" CommandName="prev" OnCommand="Page_OnClick" runat="server" /> 
<asp:LinkButton id="lbnNextPage" Text="下一页" CommandName="next" OnCommand="Page_OnClick" runat="server" /> </FONT><FONT face="宋体">   </FONT><FONT face="宋体">   </FONT><FONT face="宋体">
</FONT><FONT face="宋体">   </FONT>
</td>
</tr>
</table>

[joeweng]

打错了，应该是

http://fifa.1m.cn

[joeweng]

用ASPNETPAGER

你可以看一下

http://fc.1m.cn

就是用DATALIST+ASPNETPAGER分页的！

[xierlovexier]

非常感谢各位的帮助