读书人

.net datalist分页有关问题设置了al

发布时间: 2012-03-29 12:53:12 作者: rapoo

.net datalist分页问题,设置了allowPaging=true,pagesize也设置了但是所有的数据还是在一个页面显示,求助
前台代码:<div
当前页码为:<asp:Label ID="Label1" runat="server" Text="1"></asp:Label>
 总页码为:<asp:Label ID="Label2" runat="server" Text=""></asp:Label>
<asp:LinkButton ID="LinkButtonFirst" runat="server"
onclientclick="LinkButtonFirst_Click" onclick="LinkButtonFirst_Click">第一页</asp:LinkButton>
 
<asp:LinkButton ID="LinkButtonPrev" runat="server"
onclientclick="LinkButtonPrev_Click" onclick="LinkButtonPrev_Click">上一页</asp:LinkButton>
 
<asp:LinkButton ID="LinkButtonNext" runat="server"
onclientclick="LinkButtonNext_Click" onclick="LinkButtonNext_Click">下一页</asp:LinkButton>
 
<asp:LinkButton ID="LinkButtonLast" runat="server"
onclientclick="LinkButtonLast_Click" onclick="LinkButtonLast_Click">最后一页</asp:LinkButton> </div>

后台代码:
public partial class test10 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
listbind();
}
}
void listbind()
{ PagedDataSource pages = new PagedDataSource();
string sqlconnstr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlDataAdapter sqld = new SqlDataAdapter("select * from products", sqlconnstr);
DataSet ds = new DataSet();
sqld.Fill(ds, "sql");
using (SqlConnection sqlconn = new SqlConnection(sqlconnstr))
{
pages.DataSource = ds.Tables[0].DefaultView;
pages.AllowPaging = true;
pages.PageSize = 6;
int Curpage = Convert.ToInt32(this.Label1.Text);
pages.CurrentPageIndex = Curpage - 1;
if (pages.CurrentPageIndex < 0)
{
pages.CurrentPageIndex = 0;
}//只有一页时禁用上下页
if (pages.PageCount == 1)
{
LinkButtonPrev.Enabled = false;
LinkButtonNext.Enabled = false;
}
else //多页时
{
//为第一页时
if (Curpage == 1)
{
LinkButtonPrev.Enabled = false;
LinkButtonNext.Enabled = true;
}
//为最后一页时
if (Curpage == pages.PageCount)
{
LinkButtonPrev.Enabled = true;
LinkButtonNext.Enabled = false;
}
}
this.Label2.Text = Convert.ToString(pages.PageCount);

DataList1.DataBind();


}
}
//首页

protected void LinkButtonFirst_Click(object sender, EventArgs e)
{
this.Label1.Text = "1";
listbind(); }
protected void LinkButtonPrev_Click(object sender, EventArgs e)


{
this.Label1.Text = Convert.ToString(int.Parse(this.Label1.Text) - 1);
listbind();
}
protected void LinkButtonNext_Click(object sender, EventArgs e)
{
this.Label1.Text = Convert.ToString(int.Parse(this.Label1.Text) + 1);
listbind();
}
protected void LinkButtonLast_Click(object sender, EventArgs e)
{
this.Label1.Text = this.Label1.Text;
listbind();
}
}
后台代码没有显示错误 点击总页码,上下页也都能用 ,但所有的数据就一直在第一页,没有实现分页,请教!!非常感谢






[解决办法]
DataList控件有allowPaging属性吗?


http://msdn.microsoft.com/zh-cn/library/system.web.ui.webcontrols.datalist_properties.aspx


DataList分页方法

搜索google

DataList 分页
[解决办法]
DataList的分页技术

http://dotnet.aspx.cc/article/47dd34fd-ed0b-4455-94e8-cd9f63e19893/read.aspx

读书人网 >C#

热点推荐