Changing SqlDataSource.SelectCommand at runtime breaks pagination
I have a GridView bound to a SqlDataSource with a default SelectCommand defined as such:
I have a GridView bound to a SqlDataSource with a default SelectCommand defined as such: