读书人

AspNetPager与gridview组合显示数据

发布时间: 2013-01-01 14:04:19 作者: rapoo

AspNetPager与gridview结合显示数据,但是在模糊查询后AspNetPager控件就没有效果了!
我用AspNetPager与gridview结合显示数据,但是在模糊查询后AspNetPager控件就没有效果了!请问哪位高手有例子!帮忙小弟一下!
[解决办法]
不管是精确查询还是模糊查询,关键都是获取数据源,只要有数据就不会说控件没效果。

<webdiyer:AspNetPager ID="AspNetPager1" runat="server" AlwaysShow="true" PageSize="20" 
FirstPageText="首页" NextPageText="下一页" PrevPageText="上一页" LastPageText="尾页"
OnPageChanged="AspNetPager1_PageChanged" CssClass="pages">
</webdiyer:AspNetPager>

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
AspNetPager1.RecordCount = getTotalRecore();
bindData();
}
}
private void bindData()
{
string strResult = "";
string strSQL = "proc_Comm_Affairs_getList";
using (DBOperate dbo = new DBOperate())
{
SqlParameter[] sqlPa = new SqlParameter[]
{
DBOperate .MakeInParam ("@PageIndex",AspNetPager1 .CurrentPageIndex ),
DBOperate .MakeInParam ("@PageSize",AspNetPager1 .PageSize )
};
DataTable dt = dbo.ExecuteTable(strSQL ,sqlPa ,CommandType.StoredProcedure );

rp_NewsList.DataSource = dt;
rp_NewsList.DataBind();
}
}

protected void AspNetPager1_PageChanged(object sender, EventArgs e)
{
bindData();
}

private int getTotalRecore()
{
int iTotalRecore = 0;
using (DBOperate dbo = new DBOperate())
{
string strSQL = "select count(*) from Comm_Affairs where isShow='1' and catalogID='1'";
iTotalRecore = Convert .ToInt32 (dbo.ExecuteScalar(strSQL ,null ,CommandType.Text ));


}
return iTotalRecore;
}


[解决办法]

看8#解释

读书人网 >asp.net

热点推荐