Hi there,

I am using self service mode and I wanted to know that a) how the GetMulti paging is implemented means the whole paging programming is implemented on the sql part or whole data is fetched, then the logic is implemented in the code. b)Also please let me know how to get number of total records for paged data. Now with getmulti & getscalar we need to fire two queries one for the data and another for the total count. Is there any solution we can get both paged data and total count records altogether.

please first answer this question for us: http://www.llblgen.com/tinyforum/GotoMessage.aspx?ThreadID=21312&MessageID=120030

Please find my answer over the thread.

a) Generally speaking paging is done over the server, you can check that out by examining the generated SQL queries, in the VS output windows while debugging. Please check troubleshooting

b) One query is fired once to get the total count of the rows. A second query is executed whenever you request resultset page.