c# - Best way get the data for paging concept in web applications in ASP.net -
can explain best way writing code in scenario
i have data base tables, have show data database in pages (contains 20 rows in each page)
i doing app - retrieving data data 20 rows each , every time showing in each page using sp, every page click connected database , showing data in front end page.
my idea - complete data in datatable in 1 single query execution (single iteration) , store data in session , use in every page click.
is way correct or not?
and best way data of every page click .
if amount of retrieved data not big, yes - getting @ once way go. on other hand if hundreds of thousands of records current approach - server-side paging better alternative.
Comments
Post a Comment