本文目录一览

1,datalist如何分页它本身有没有分页的功能

配置数据源绑定 自身就有分院功能 不然自己做分页会很麻烦的 。net提供asp.net分页功能
用PagedDataSource这个数据源对象嫁接一下,先用他接数据,然后设置分页,之后再绑定到DataList上就OK了
使用PageDataSource或者第三方控件如ASPNETPager

datalist如何分页它本身有没有分页的功能

2,datalist怎么样实现分页功能

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 Demo : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { dlBind(); } public void dlBind() { int curpage = Convert.ToInt32(lb_CurrentPage.Text); SqlConnection conn = new SqlConnection("server=.;database=db_MyData;uid=sa;pwd="); conn.Open(); SqlDataAdapter da = new SqlDataAdapter("select top 50 * from tb_user", conn); DataSet ds = new DataSet(); da.Fill(ds, "tb_user"); PagedDataSource ps = new PagedDataSource(); ps.DataSource = ds.Tables["tb_user"].DefaultView; ps.AllowPaging = true; //是否分页 ps.PageSize = 5; //显示的数量 ps.CurrentPageIndex = curpage - 1; //取得当前页的页码 if (!IsPostBack) { for (int i = 1; i <= ps.PageCount; i++) { DropDownList1.Items.Add(i.ToString()); } DropDownList1.SelectedItem.Text = curpage.ToString(); } LinkFirst.Enabled = true; LinkUp.Enabled = true; LinkDown.Enabled = true; LinkLast.Enabled = true; if (curpage == 1) { LinkFirst.Enabled = false; //不显示第一页按钮 LinkUp.Enabled = false; //不显示上一页按钮 } if (curpage == ps.PageCount) { LinkDown.Enabled = false; //不显示下一页按钮 LinkLast.Enabled = false; //不显示最后一页按钮 } lb_page.Text = Convert.ToString (ps.PageCount); //获取总页数 lb_count .Text =ps .DataSourceCount .ToString (); //获取记录总数 DataList1.DataSource = ps; DataList1.DataKeyField = "userLoginID"; DataList1.DataBind(); } protected void LinkFirst_Click(object sender, EventArgs e) //第一页按钮 { lb_CurrentPage.Text = "1"; dlBind(); } protected void LinkUp_Click(object sender, EventArgs e) //上一页按钮 { lb_CurrentPage.Text = Convert.ToString(Convert .ToInt32 (lb_CurrentPage .Text )-1); dlBind(); } protected void LinkDown_Click(object sender, EventArgs e) //下一页按钮 { lb_CurrentPage .Text =Convert .ToString (Convert .ToInt32 (lb_CurrentPage .Text) +1); dlBind (); } protected void LinkLast_Click(object sender, EventArgs e) //最后一页按钮 { lb_CurrentPage.Text = lb_page.Text; dlBind(); } protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) //跳转到指定页 { int page = Convert.ToInt32(DropDownList1.SelectedItem.Value); lb_CurrentPage.Text = page.ToString(); dlBind(); } }

datalist怎么样实现分页功能


文章TAG:datalist  怎么  分页  如何  datalist怎么分页  
下一篇