用DataList如何实现分页！

bfqyvek 2004-08-27 01:56:26

如果我用以下代码。可我想有分页的，应如何做呢？请各位大哥指点一下。谢谢！

%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>

<html>

<script language="C#" runat="server">

void Page_Load(Object sender, EventArgs e) {

SqlConnection myConnection = new SqlConnection("server=(local);database=pubs;Trusted_Connection=yes");
SqlDataAdapter myCommand = new SqlDataAdapter("select * from Titles", myConnection);

DataSet ds = new DataSet();
myCommand.Fill(ds, "书名");

MyDataList.DataSource = ds.Tables["书名"].DefaultView;
MyDataList.DataBind();
}

</script>

<body topmargin="0" leftmargin="0" marginwidth="0" marginheight="0">



<ASP:DataList id="MyDataList" RepeatColumns="3" RepeatDirection="Horizontal" runat="server" HorizontalAlign="Center">
<FooterStyle HorizontalAlign="Center"></FooterStyle>

<ItemTemplate>

<div style="padding:15,15,15,15;font-size:10.5pt;font-family:宋体">

<div style="font:12pt 宋体;color:darkred">
<i><b><%# DataBinder.Eval(Container.DataItem, "title") %></i></b>
</div>

<br>

<b>书名 ID：</b><%# DataBinder.Eval(Container.DataItem, "title_id") %><br>
<b>类别：</b><%# DataBinder.Eval(Container.DataItem, "type") %><br>
<b>出版商 ID：</b><%# DataBinder.Eval(Container.DataItem, "pub_id") %><br>
<b>价格：</b><%# DataBinder.Eval(Container.DataItem, "price", "$ {0}") %><p>

</div>

</ItemTemplate>

</ASP:DataList>



</body>
</html>

...全文

111 2 打赏收藏转发到动态举报

写回复

用AI写文章

2 条回复

切换为时间正序

请发表友善的回复…

发表回复

saucer 2004-08-27

打赏
举报

here is C# example:

Paging a DataList
http://www.csharphelp.com/archives3/archive544.html

saucer 2004-08-27

打赏
举报

you need to write your own paging code, but see

Ask the DotNetJunkies: DataList Paging
http://www.dotnetjunkies.com/Tutorial/70E24E50-C179-4563-B053-2742516BF05B.dcik