找了一整天了 也不知道什么原因看代码:DBHelper:public static DataSet GetDataSets(string SqlStrings, int Pager1, int Pager2, string TableName)
{
SqlConnection Connection = new SqlConnection(CONNECTION_STRING);
Connection.Open();
SqlDataAdapter sda = new SqlDataAdapter(SqlStrings, Connection);
DataSet ds = new DataSet();
sda.Fill(ds, Pager1, Pager2, TableName);
return ds;
}DAL: //分页查询
public DataSet GetPagesList(int Pager1, int Pager2, string TableName)
{ string sql = "select * from myusers order by id desc"; DataSet ds = DBHelper.GetDataSets(sql, Pager1, Pager2, TableName);
return ds;
}BLL://分页查询
public static DataSet GetPagesList(int Pager1, int Pager2, string TableName)
{
return dt.GetPagesList(Pager1, Pager2, TableName);
}。csif (!IsPostBack) { AspNetPager1.AlwaysShow = true; AspNetPager1.PageSize = 10; BindPages();
}public void BindPages() {
int page1 = AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1); int page2 = AspNetPager1.PageSize; DataSet ds = DictManager.GetPagesList(page1, page2, "Dict"); Repeater1.DataSource = ds.Tables["Dict"].DefaultView; Repeater1.DataBind();
}
protected void AspNetPager1_PageChanged(object sender, EventArgs e)
{
//AspNetPager1版本为7.3
BindPages();
}。aspx:
<ItemTemplate>
<tr>
<td style="width: 194px"><%#DataBinder.Eval(Container.DataItem,"Dict_id") %>
</td>
<td style="width: 367px"><%#DataBinder.Eval(Container.DataItem, "Dict_type")%>
</td>
<td style="width: 285px"><%#DataBinder.Eval(Container.DataItem, "Dict_item")%>
</td>
<td style="width: 306px"><%#DataBinder.Eval(Container.DataItem, "Dict_value")%>
</ItemTemplate><webdiyer:aspnetpager id="AspNetPager1" runat="server" alwaysshow="True" pageindexboxtype="TextBox" OnPageChanged="AspNetPager1_PageChanged" ShowCustomInfoSection="Left" ShowPageIndexBox="Always" SubmitButtonText="转"></webdiyer:aspnetpager>问题:永远只显示10条数据(数据库超过10条数据),没办法下一页,上一页,转到等按钮全是灰色不可点。谢谢!这问题困扰我很久了,请大家帮帮忙!~
{
SqlConnection Connection = new SqlConnection(CONNECTION_STRING);
Connection.Open();
SqlDataAdapter sda = new SqlDataAdapter(SqlStrings, Connection);
DataSet ds = new DataSet();
sda.Fill(ds, Pager1, Pager2, TableName);
return ds;
}DAL: //分页查询
public DataSet GetPagesList(int Pager1, int Pager2, string TableName)
{ string sql = "select * from myusers order by id desc"; DataSet ds = DBHelper.GetDataSets(sql, Pager1, Pager2, TableName);
return ds;
}BLL://分页查询
public static DataSet GetPagesList(int Pager1, int Pager2, string TableName)
{
return dt.GetPagesList(Pager1, Pager2, TableName);
}。csif (!IsPostBack) { AspNetPager1.AlwaysShow = true; AspNetPager1.PageSize = 10; BindPages();
}public void BindPages() {
int page1 = AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1); int page2 = AspNetPager1.PageSize; DataSet ds = DictManager.GetPagesList(page1, page2, "Dict"); Repeater1.DataSource = ds.Tables["Dict"].DefaultView; Repeater1.DataBind();
}
protected void AspNetPager1_PageChanged(object sender, EventArgs e)
{
//AspNetPager1版本为7.3
BindPages();
}。aspx:
<ItemTemplate>
<tr>
<td style="width: 194px"><%#DataBinder.Eval(Container.DataItem,"Dict_id") %>
</td>
<td style="width: 367px"><%#DataBinder.Eval(Container.DataItem, "Dict_type")%>
</td>
<td style="width: 285px"><%#DataBinder.Eval(Container.DataItem, "Dict_item")%>
</td>
<td style="width: 306px"><%#DataBinder.Eval(Container.DataItem, "Dict_value")%>
</ItemTemplate><webdiyer:aspnetpager id="AspNetPager1" runat="server" alwaysshow="True" pageindexboxtype="TextBox" OnPageChanged="AspNetPager1_PageChanged" ShowCustomInfoSection="Left" ShowPageIndexBox="Always" SubmitButtonText="转"></webdiyer:aspnetpager>问题:永远只显示10条数据(数据库超过10条数据),没办法下一页,上一页,转到等按钮全是灰色不可点。谢谢!这问题困扰我很久了,请大家帮帮忙!~
换成
OnPageChanging="AspNetPager1_PageChanging"
AspNetPager1.AlwaysShow = true;
AspNetPager1.PageSize = 10;
BindPages();
}加上AspNetPager1.RecordCount=1000000;