页面的控件设计:
1个datalist,4个linkbutton,2个lable控件,页面布局就不再说了。下面看后台代码:
---------------------------------------------------------------------------------
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 Default3 : System.Web.UI.Page
{
protected void bind()
{
int curpage = Convert.ToInt32(labpage.Text);
PagedDataSource ps = new PagedDataSource();
SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["conn"]);
conn.Open();
SqlDataAdapter da = new SqlDataAdapter("select * from img",conn);
DataSet ds = new DataSet();
da.Fill(ds,"img");
ps.DataSource = ds.Tables["img"].DefaultView;
ps.AllowPaging = true;
ps.PageSize = 3;
ps.CurrentPageIndex = curpage - 1;
pagedown.Enabled = true;
pageup.Enabled = true;
pagelast.Enabled = true;
pageindex.Enabled = true;
if (curpage == 1)
{
pageindex.Enabled = false;
pageup.Enabled = false;
}
if (curpage == ps.PageCount)
{
pagedown.Enabled = false;
pagelast.Enabled = false;
}
labbackpage.Text = Convert.ToString(ps.PageCount);
DataList1.DataSource = ps;
DataList1.DataKeyField = "imgid";
DataList1.DataSource = ps;
DataList1.DataBind();
conn.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
labpage.Text = "1";
bind();
}
}
protected void pageindex_Click(object sender, EventArgs e)
{
labpage.Text = "1";
bind();
}
protected void pageup_Click(object sender, EventArgs e)
{
labpage.Text = Convert.ToString(Convert.ToInt32(labpage.Text)-1);
bind();
}
protected void pagedown_Click(object sender, EventArgs e)
{
labpage.Text = Convert.ToString(Convert.ToInt32(labpage.Text) + 1);
bind();
}
protected void pagelast_Click(object sender, EventArgs e)
{
labpage.Text = labbackpage.Text;
bind();
}
}
DataList分页
最新推荐文章于 2014-01-22 15:25:58 发布