Re: OutputCache problem

3KyNoX — Sun, 05 Jul 2009 07:28:59 GMT

Thanks, taking time to read it.

Using actually SQL Server 2008 SP1 express with advanced services (think it is the same way as 2005)

Re: OutputCache problem

malcolms — Sat, 04 Jul 2009 11:52:26 GMT

Are you using SQL Server 2000 or SQL Server 2005? If you're using 2005 then check out this article I wrote on it which explains how to clearly use it:

http://www.dotnetcurry.com/ShowArticle.aspx?ID=263

OutputCache problem

3KyNoX — Fri, 03 Jul 2009 07:48:39 GMT

Hello,

on my asp website, i got a webform that displays a category products inside a gridview by selecting category on a dropdownlist.

i activated outputcache on that page by adding to web.config :

<sqlCacheDependency enabled="true" pollTime="500">
        <databases>
          <add name="dcNames" connectionStringName="csName" />
        </databases>
      </sqlCacheDependency>

and on my administration.aspx page :

<%@ OutputCache Duration="999999" VaryByParam="*" VaryByControl="DropDownList1" SqlDependency="dcName:Product;dcName:Category" %>

to work with my two tables Products and Category.

i got a label to verify the page generation at datetime.

1st problem : When the website is launched, and when i change the dropdownlist selection, the label indicate correctly "Page generated at DateTime.Now" but content of the dropdownlist never updated untill the moment i do a F5 to refresh the page (when i modify a category name for example).

Another problem is that when i select my administration.aspx page on the treeview contained in my masterpage, it keeps an old generation time and so my categories on the dropdownlist are not updated too and do not reflect the database.

Any idea to correct that two problems please ?

State Management

Re: OutputCache problem

Re: OutputCache problem

OutputCache problem