Datapager和Datalist可以结合使用吗?如何结合?
以前一直用VS2005,现在装了VS2008,多了个分页控件Datapager,但这个控件似乎只能和Listview结合,我看网上好像可以和Datalist结合使用。
请问Datapager和Datalist两者如何结合使用啊?需要比较详细一点的代码,本人水平不高。谢谢各位支持!
[解决办法]
有现成的分页控件啊
传送门
PagedDataSource 分页
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bind();
}
}
void bind()
{
int curpage = Convert.ToInt32(this.Label1.Text);
PagedDataSource ps = new PagedDataSource();
pagebind(ps);
ps.AllowPaging = true;
ps.PageSize = 5;
ps.CurrentPageIndex = curpage -1;
this.LinkButton1.Enabled = true;
this.LinkButton2.Enabled = true;
this.LinkButton3.Enabled = true;
this.LinkButton4.Enabled = true;
if (curpage == 1)
{
this.LinkButton1.Enabled = false;
this.LinkButton2.Enabled = false;
}
if (curpage == ps.PageCount)
{
this.LinkButton3.Enabled = false;
this.LinkButton4.Enabled = false;
}
this.Label2.Text = ps.PageCount.ToString();
this.DataList1.DataSource = ps;
this.DataList1.DataBind();
}
void pagebind(PagedDataSource pd)
{
string strcon="server=.;database=pubs;uid=sa;pwd=sa";
SqlConnection cn = new SqlConnection(strcon);
SqlDataAdapter da = new SqlDataAdapter("select title_id,title,price from titles", cn);
DataSet ds = new DataSet();
da.Fill(ds, "titles");
pd.DataSource = ds.Tables["titles"].DefaultView;
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
this.Label1.Text = "1";
bind();
}
protected void LinkButton2_Click(object sender, EventArgs e)
{
this.Label1.Text = (Convert.ToInt32(this.Label1.Text) - 1).ToString();
bind();
}
protected void LinkButton3_Click(object sender, EventArgs e)
{
this.Label1.Text=(Convert.ToInt32(this.Label1.Text)+1).ToString();
bind();
}
protected void LinkButton4_Click(object sender, EventArgs e)
{
this.Label1.Text = Label2.Text;
bind();
}