As I am looking at a couple of examples of implementing paging in a gridview (below is one url of an article) it seems to me that the way it is done is that on Every Next Page click the entire dataset (to which gridview is bound) is created. That is, every time user clicks to go to the next page, there is a call to DB and dataset is Fillled. Aside from visual (maybe) perception of dealing with smaller number of records, where is the processing saving of this method?
Here is the article on which I base my understanding:
http://www.dotnetgallery.com/kb/resource12-How-to-implement-paging-and-sorting-in-aspnet-Gridview-control.aspx.aspxI thought that the paging would get the entire dataset One Time and then simply display the rows of the dataset according to the user paging.
What am I not getting?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham