如何在CMSRepeater中从代码端添加分页

// 设置每页显示的记录数和当前页码
int pageSize = 10;
int currentPage = 1;

// 获取数据源（假设使用ADO.NET）
string connectionString = "YourConnectionString";
string query = "SELECT * FROM YourTable";
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand(query, connection);
SqlDataAdapter adapter = new SqlDataAdapter(command);
DataTable dataTable = new DataTable();
adapter.Fill(dataTable);

// 计算总页数和当前页的起始索引
int totalRecords = dataTable.Rows.Count;
int totalPages = (int)Math.Ceiling((double)totalRecords / pageSize);
int startIndex = (currentPage - 1) * pageSize;

// 获取当前页的数据
DataRow[] rows = dataTable.AsEnumerable()
    .Skip(startIndex)
    .Take(pageSize)
    .ToArray();

// 绑定数据到CMSRepeater控件
CMSRepeater.DataSource = rows;
CMSRepeater.DataBind();

// 添加分页控件（假设使用ASP.NET的Pager控件）
Pager.TotalRecords = totalRecords;
Pager.PageSize = pageSize;
Pager.CurrentPage = currentPage;
Pager.TotalPages = totalPages;