asp.net 使用ajax分页

查询出数据，使用 sql分页。

 
public static List<Topic> GetTopicList(int page, int pagesize)
        {
            string sql = "select * from (select *,row_number() over (order by id) as r_num from Topic) as rum_table where r_num between (@page-1) * @pagesize+1 and @pagesize * @page";
            List<Topic> list = new List<Topic>();
            using (SqlConnection connection = (SqlConnection)DBHelper.GetDataBase())
            {
                try
                {
                    SqlCommand cmd = new SqlCommand(sql, connection);
                    SqlParameter[] parameter = new SqlParameter[] 
                    { 
                        new SqlParameter("@page",page),
                        new SqlParameter("@pagesize",pagesize)
                    };
                    connection.Open();
                    cmd.Parameters.AddRange(parameter);
                    SqlDataReader reader = cmd.ExecuteReader();
                    list = CycleErgodic(reader);
                    connection.Close();
                }
                catch (Exception ex)
                {
                    ExceptionManage.WriteLogFile(ex.ToString());
                    throw new Exception("The system is buys,please try again later...");
                }
            }
            return list; 
                    
        }

经过BLL层 在 一般处