FenYa

最新推荐文章于 2021-04-10 14:44:50 发布

原创最新推荐文章于 2021-04-10 14:44:50 发布 · 480 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#UI #Web

网络编程专栏收录该内容

5 篇文章

订阅专栏

本文介绍了一种使用C#和SQL实现的数据分页查询方法。通过构造动态SQL语句，结合参数化查询，实现了按指定字段排序及限定页数和每页条数的数据获取功能。

    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();

}
}