RetrievalProcedures paging

Posts   
 
    
nato24 avatar
nato24
User
Posts: 14
Joined: 10-Apr-2007
# Posted on: 13-Sep-2007 19:00:50   

I am using a stored procedure to return a resultset based on the proximity of a zip code using RetrievalProcedures (selfservice). That is all fine and dandy but I need to bind that in an asp.net page with pagination (emphasis on paging).

I also need to be able to keyword search and filter within this resultset. I have to say I've been spoiled using the llbl datasource controls.

Is there a recommended technique for this?

Thanks, Nathan

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 14-Sep-2007 10:46:05   

That is all fine and dandy but I need to bind that in an asp.net page with pagination (emphasis on paging).

Use the paging of the GridView, all results will be fetched eachtime you'd select a page, and the grid will just display the needed records. (Not effecient)

Implement paging in your SP, add a couple of parameters for the page number & page size.

I also need to be able to keyword search and filter within this resultset.

Maybe you need to project the results into an entityCollection (if possible), and use the client side EntityView filtering.