Sql代码  

1. set ANSI_NULLS ON  
2. set QUOTED_IDENTIFIER ON  
3. GO   
4. -- =============================================   
5. -- Author:      myroom   
6. -- Create date: 2009-12-6   
7. -- Description: 新闻表的分页   
8. -- =============================================   
9. ALTER PROCEDURE [dbo].[prceNewsPagerSelectAll]   
10. @startIndex int,   
11. @endIndex int  
12. AS  
13. BEGIN  
14.     with temptbl as(   
15.     select ROW_NUMBER() OVER (ORDER BY id desc)AS Row,* from news   
16. )   
17.     SELECT Row,title FROM temptbl where Row between @startIndex and @endIndex   
18. END  

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		myroom
-- Create date: 2009-12-6
-- Description:	新闻表的分页
-- =============================================
ALTER PROCEDURE [dbo].[prceNewsPagerSelectAll]
@startIndex int,
@endIndex int
AS
BEGIN
	with temptbl as(
	select ROW_NUMBER() OVER (ORDER BY id desc)AS Row,* from news
)
	SELECT Row,title FROM temptbl where Row between @startIndex and @endIndex
END

Sql代码  

1. exec prceNewsPagerSelectAll 1,5  

exec prceNewsPagerSelectAll 1,5

C#代码  

1. //选出新闻表中总记录个数   
2.        public int NewsRecordCount()    
3.        {   
4.            string cmdText="select * from news";   
5.            int rc = (sqlhelper.ExecuteQuery(cmdText, CommandType.Text)).Rows .Count ;   
6.            return rc;   
7.        }   
8.        //新闻表分页功能   
9.        public DataTable SelectNewsPager(int startIndex, int endIndex)   
10.        {   
11.            DataTable dt = new DataTable();   
12.            string cmdText = "prceNewsPagerSelectAll";   
13.            SqlParameter[] paras = new SqlParameter[] {    
14.                new SqlParameter ("@startIndex",startIndex ),   
15.                new SqlParameter ("@endIndex",endIndex )   
16.            };   
17.            dt = sqlhelper.ExecuteQuery(cmdText, paras, CommandType.StoredProcedure);   
18.            return dt;   
19.        }  

 //选出新闻表中总记录个数
        public int NewsRecordCount() 
        {
            string cmdText="select * from news";
            int rc = (sqlhelper.ExecuteQuery(cmdText, CommandType.Text)).Rows .Count ;
            return rc;
        }
        //新闻表分页功能
        public DataTable SelectNewsPager(int startIndex, int endIndex)
        {
            DataTable dt = new DataTable();
            string cmdText = "prceNewsPagerSelectAll";
            SqlParameter[] paras = new SqlParameter[] { 
                new SqlParameter ("@startIndex",startIndex ),
                new SqlParameter ("@endIndex",endIndex )
            };
            dt = sqlhelper.ExecuteQuery(cmdText, paras, CommandType.StoredProcedure);
            return dt;
        }

C#代码  

1. protected void Page_Load(object sender, EventArgs e)   
2. {   
3.     if (!Page .IsPostBack )   
4.     {                
5.          int totalRecord = new NewsDAO().NewsRecordCount();//获取总记录数   
6.         AspNetPager1.RecordCount = totalRecord;//对AspNetPager属性进行设置   
7.         databind();   
8.     }   
9. }   
10. //AspNetPager1控件的PageChanged事件   
11. protected void AspNetPager1_PageChanged(object sender, EventArgs e)   
12. {   
13.     databind();   
14. }   
15. //数据绑定方法   
16. private void databind()   
17. {   
18.     int startIndex = AspNetPager1.StartRecordIndex;//StartRecordIndex是AspNetPager固有属性   
19.     int endIndex = AspNetPager1.EndRecordIndex;//EndRecordIndex是AspNetPager固有属性   
20.     //数据绑定   
21.     Repeater1.DataSource = new NewsDAO().SelectNewsPager(startIndex, endIndex);   
22.     Repeater1.DataBind();   
23. }  

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page .IsPostBack )
        {             
             int totalRecord = new NewsDAO().NewsRecordCount();//获取总记录数
            AspNetPager1.RecordCount = totalRecord;//对AspNetPager属性进行设置
            databind();
        }
    }
    //AspNetPager1控件的PageChanged事件
    protected void AspNetPager1_PageChanged(object sender, EventArgs e)
    {
        databind();
    }
    //数据绑定方法
    private void databind()
    {
        int startIndex = AspNetPager1.StartRecordIndex;//StartRecordIndex是AspNetPager固有属性
        int endIndex = AspNetPager1.EndRecordIndex;//EndRecordIndex是AspNetPager固有属性
        //数据绑定
        Repeater1.DataSource = new NewsDAO().SelectNewsPager(startIndex, endIndex);
        Repeater1.DataBind();
    }

.NET基于分页控件实现真分页功能,布布扣,bubuko.com

.NET基于分页控件实现真分页功能