EnableCaching

[Tony Johansson]

Hello!

I'm reading a book and it says
"Every time you displays a webbpage that contain a SqlDataSource will the
select clause run that is specified for the SqlDataSource and fill the
DataSet with data. Default is to run the select clause every time you go
from one page to another page if you use a pager for the webbpage and the
rows is split on several pages. For example the total number of rows might
be 50 in the DataSet but you only show 10 rows on each page which mean that
you have 5 pages 1,2,3,4,5 on the same webbpage."

Now to my question the book says also the following
"The select clause is also run again if you update the display of the
webbpage in the browser"
So what does this last sentence mean ?

//Tony

 

[Gregory A. Beamer]

Now to my question the book says also the following
"The select clause is also run again if you update the display of the
webbpage in the browser"
So what does this last sentence mean ?

What it means is hitting the refresh button, as far as I can tell, which
is correct. From a web standpoint, it means you initiated a GET instead
of a POST, but that may be getting too deep.

From an ASP.NET standpoint, it means any refresh of the page outside of
the mechanisms wired up. The SQL datasource control will be wired to the
Grid or List or Repeater and handle the normal sort, page, etc.
(provided everything is declared correctly). Events outside of this
wiring will cause a refresh (GET) and the page will be delivered new.

Hope this helps.

Peace and Grace,

--
Gregory A. Beamer (MVP)

Twitter: @gbworld
Blog: http://gregorybeamer.spaces.live.com

*******************************************
| Think outside the box! |
*******************************************