Loading data with stored procedure in sql. Problem filter

Hi,
in my project I use stored procedures to load data into a group table, everything works correctly except filters and above all
pagination, loads all the data in the table but I would like to paginate them.
What am I missing or am I doing wrong?

Hi,
Take a look at this topic: How to add custom/override pagination for datacontainers