FenYa

    public partial class _Default : System.Web.UI.Page
    {
        /// <summary>
        /// 删除一条数据
        /// </summary>
        ///
        public DataTable FendYa(string order,string fileds,int pageIndex,int pageSize)
        {
            StringBuilder strSql = new StringBuilder();

            //strSql.Append("select * from(select ROW_NUMBER() over (order by @order) AS pos,cname,@fileds from test) as sp where pos between 1 and 3");

            strSql.Append("select * from(select row_number() over (order by " + order + "desc");
            strSql.Append(") AS pos," + fileds + " from test)");
            strSql.Append(" as sp where pos between " + ((pageIndex - 1) * pageSize + 1) + " and " + pageIndex * pageSize);

            SqlCommand cmd = new SqlCommand(strSql.ToString(), conn);
            SqlDataReader dr = cmd.ExecuteReader();

            DataTable dt = new DataTable();
            dt.Load(dr);

            return dt;
        }
        SqlConnection conn = new SqlConnection("server=.;database=student;uid=sa;pwd=123456");
        protected void Page_Load(object sender, EventArgs e)
        {
            conn.Open();
            GridView1.DataSource = FendYa("id", "cname", 2, 3);
            GridView1.DataBind();

        }
    }