分页控件

twfx7758 2008-09-16 02:58:18

哪有好的分布控件，或者哪个地方有具体介绍分页，是主要的是简单好用，支持存储过程的~

...全文

140 16 打赏收藏转发到动态举报

写回复

用AI写文章

16 条回复

切换为时间正序

请发表友善的回复…

发表回复

shulei521 2008-09-16

打赏
举报

AspNetPag 顶一下

takako_mu 2008-09-16

打赏
举报

我自己以前写的一个带存储过程的例子，希望对你有帮助。

//绑定
public void BindGridView()
{
DataSet ds = new DataSet();
DataSet ds_count = new DataSet();
function func = new function();
//定义owner，status……省略N行
//计算出ds的数据量，Aspnetpager会自动的给你分成几页。
ds_count = func.dailywork_list(1, owner, status, project, item,
"", "", startdate1, startdate2, duedate1, duedate2,
description, updatedatetime, updatename, AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex);
//将ds_count赋给Aspnetpager
AspNetPager1.RecordCount = int.Parse(ds_count.Tables[0].Rows[0][0].ToString().Trim());
//查询出你需要的数据，赋给ds
ds = func.dailywork_list(2, owner, status, project, item,
"", "", startdate1, startdate2, duedate1, duedate2,
description, updatedatetime, updatename, AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex);
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}

//function我就不写了。
//分页
protected void AspNetPager1_PageChanged(object sender, EventArgs e)
{
BindGridView();
}

存储过程如下：
if(@flag=1)
begin
select count(*) from daily_work dw
where dw.Owner like ''+@owner+'%'
and dw.Status like '%'+@status+'%'
and dw.Item like '%'+@item+'%'
and dw.Project like '%'+@project+'%'
and ((dw.[Start Date] between @startdate1 and @startdate2) or dw.[Start Date] IS null)
and ((dw.[Due Date] between @duedate1 and @duedate2 )or dw.[Due Date] IS null)
and dw.[Description (purpose/value)] like '%'+@description+'%'
end

if(@flag=2)
begin
with temptbl as
(
select ROW_NUMBER()over(order by project asc,(right([Code],5)) desc) AS Number,
dw.[No],dw.Project,dw.Item,dw.Code,dw.[Type],dw.[Description(purpose/value)],dw.Status,dw.[%],
Convert(Varchar(10),dw.[Start Date],120)AS [Start Date],Convert(Varchar(10),dw.[Due Date],120)AS [Due Date],dw.Owner,dw.[Day/Hour],dw.Comment,dw.Updatedatetime,dw.UpdateName

from daily_work dw
where dw.Status='Delete'
and dw.Item like '%'+@item+'%'
and dw.Owner like ''+@owner+'%'
and dw.Status like '%'+@status+'%'
and dw.Project like '%'+@project+'%'
and ((dw.[Start Date] between @startdate1 and @startdate2) or dw.[Start Date] IS null)
and ((dw.[Due Date] between @duedate1 and @duedate2 )or dw.[Due Date] IS null)
and dw.[Description (purpose/value)] like '%'+@description+'%'
)
select * from temptbl where Number>=((@pageindex-1)*@pagesize+1)
and Number<=(@pageindex*@pagesize) order by project asc,(right([Code],5)) desc
end