Loading data with stored procedure in sql. Problem filter

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?

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