【牛腩】-真假分页

--真分页SQL查询语句-SQL 2005以上
--使用临时表来存储查出来的东西，然后再在临时表中查找内容
with temptbl as(
    select ROW_NUMBER()over(order by id desc)as 行号,* from news  
)
select * from temptbl where 行号 between 4 and 8• 1

/// <summary>  
///  返回执行的SQL语句的第一行第一列的值 
/// </summary>  
/// <param name="sql">SQL语句</param>  
/// <returns></returns>  
public string ExecuteScalar(string sql)
{
    try
    {
        cmd = new SqlCommand(sql, GetConn());
        object obj = cmd.ExecuteScalar();
        if (obj != null)
        {
            return obj.ToString();
        }
        return "";
    }
    catch (Exception ex)
    {
        throw ex;
    }
    finally
    {
        if (conn.State == ConnectionState.Open)
        {
            conn.Close();
        }
    }
}  

#region 选择全部新闻
/// <summary>
/// 选择全部新闻
/// </summary>
/// <returns></returns>
public DataTable SelectAll(int startIndex, int endIndex)
{
    DataTable dt = new DataTable();
    string sql = "with temptbl as( select ROW_NUMBER()over(order by id desc)as 行号,* from news) select * from temptbl where 行号 between @startIndex and @endIndex";
    SqlParameter[] paras = new SqlParameter[]
    {
    new SqlParameter ("@startIndex",startIndex),
     new SqlParameter ("@endIndex",endIndex)
    };
    dt = new SQLHelper().ExecuteQuery(sql, paras, CommandType.Text);
    return dt;
}
#endregion

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Model;
namespace DAL
{
    public class FenYeDAO
    {
        private SQLHelper sqlhelper;
        public FenYeDAO()
        {
            sqlhelper = new SQLHelper();
        }
        /// <summary>  
        ///   根据条件计算新闻记录数
        /// </summary>  
        /// <param name="cond">条件，不用加where</param>  
        /// <returns></returns>  
        public int CalcCountNews(string cond)
        {
            string sql = "select count(*) from news";
            if (!string.IsNullOrEmpty(cond))
            {
                sql += "where" + cond;
            }
            return int.Parse(sqlhelper.ExecuteScalar(sql));
        }
    }
}

<asp:GridView ID="GridView1" runat="server"  >
</asp:GridView>• 1

<%--AspNetPager的页面头部设置--%>
<%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %>• 1

<webdiyer:AspNetPager ID="anp" runat="server" PageSize="5"   
         OnPageChanged="anp_PageChanged"   
         CustomInfoHTML="总计%RecordCount%条记录，共%PageCount%页"   
         FirstPageText="首页" 
         LastPageText="尾页" 
         NextPageText="下一页" 
         PrevPageText="上一页"   
         ShowCustomInfoSection="Left" 
         ShowPageIndexBox="Never"  
         cssclass="pages" 
         CurrentPageButtonClass="cpb"  
         AlwaysShow="true" 
         >  
 </webdiyer:AspNetPager>  • 1

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using BLL;
using System.Data;
namespace 牛腩新闻发布系统
{
  public partial class test : System.Web.UI.Page
  {
     BLL.FenYeManager fy = new FenYeManager();
     BLL.NewsManager nm = new NewsManager();
     protected void Page_Load(object sender, EventArgs e)
     {
         if (!Page.IsPostBack)
         {
             //查询总记录数
             anp.RecordCount = fy.CalcCountNews("");
             //绑定新闻列表
             BindGV();
         }
     }
     //分页事件  
     protected void anp_PageChanged(object sender, EventArgs e)
     {
         BindGV();
     }
     //绑定新闻列表  
     private void BindGV()
     {        
         GridView1.DataSource = nm.SelectAll(anp.StartRecordIndex, anp.EndRecordIndex);
         GridView1.DataBind();
     } 
   }
}