在运行时更改SqlDataSource.SelectCommand会破坏分页

// 保存当前分页信息
int currentPageIndex = SqlDataSource1.CurrentPageIndex;
int pageSize = SqlDataSource1.PageSize;

// 更改SelectCommand
SqlDataSource1.SelectCommand = "SELECT * FROM [TableName] WHERE [ColumnName] = @Value";
SqlDataSource1.SelectParameters.Add("Value", "SomeValue");

// 恢复分页信息
SqlDataSource1.CurrentPageIndex = currentPageIndex;
SqlDataSource1.PageSize = pageSize;

// 重新绑定数据
SqlDataSource1.DataBind();