Cache dataset and expire

[martin]

Hi,

I am storing a dataset in cache, which is happening fine. I can easily
retrive it at postback from the cache, cast it to a dataset and reuse it.
However I have specified that the cache expire in 5 minutes like so.

If Not IsPostBack Then
BindMyDropDown( )
Else
Response.Write( "<hr>Cache Expires 5 minutes" &
DateTime.Now.Ad dSeconds(300) & "<hr>")
'If the cache had expired I would expect this line to cause an
error -- but it doesn't even if I cause postback after 15 minutes!!!
dsMyDataset = CType(Cache("ds "), DataSet)
Response.Cache. SetExpires(Date Time.Now.AddSec onds(300))
End If

I also set the cache expire in exactly the same way in the BindMyDropDown( )
function.
and place the dataset into the cache like so.

//code here
objConn.Open()
daMyDataAdapter .Fill(dsMyDatas et, "Customers" )
objConn.Close()
Cache.Insert("d s", dsMyDataset)
Response.Write( "<hr>Cache Expires 5 minutes" &
DateTime.Now.Ad dSeconds(300) & "<hr>")
Response.Cache. SetExpires(Date Time.Now.AddSec onds(300))

DropDownList1.D ataSource = dsMyDataset
DropDownList1.D ataValueField =
dsMyDataset.Tab les(0).Columns( 0).ToString
DropDownList1.D ataTextField =
dsMyDataset.Tab les(0).Columns( 1).ToString
DropDownList1.D ataBind()

when a button is clicked and a postback is caused the button handler
retrieves the cache dataset and rebinds it to a combo box.
I would have thought that if the page was posted back any later than 5
minutes that an error would occur because the cache had expired, but it
doesn't.
The lack of this error indicates to me that the cache is not expiring, but I
do not know what I am doing wrong.
How do I make the cache expire in 5 minutes.

cheers

martin

[Cowboy \(Gregory A. Beamer\)]

You may be pulling some info from ViewState, which would pull the values
despite the cache being refreshed. Turn off ViewState to test this behavior.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************** *************** *************** *************** **********
Think Outside the Box!
*************** *************** *************** *************** **********
"martin" <ma***********@ hotmail.com> wrote in message
news:uA******** ******@tk2msftn gp13.phx.gbl...

Hi,

I am storing a dataset in cache, which is happening fine. I can easily
retrive it at postback from the cache, cast it to a dataset and reuse it.
However I have specified that the cache expire in 5 minutes like so.

If Not IsPostBack Then
BindMyDropDown( )
Else
Response.Write( "<hr>Cache Expires 5 minutes" &
DateTime.Now.Ad dSeconds(300) & "<hr>")
'If the cache had expired I would expect this line to cause an
error -- but it doesn't even if I cause postback after 15 minutes!!!
dsMyDataset = CType(Cache("ds "), DataSet)
Response.Cache. SetExpires(Date Time.Now.AddSec onds(300))
End If

I also set the cache expire in exactly the same way in the BindMyDropDown( ) function.
and place the dataset into the cache like so.

//code here
objConn.Open()
daMyDataAdapter .Fill(dsMyDatas et, "Customers" )
objConn.Close()
Cache.Insert("d s", dsMyDataset)
Response.Write( "<hr>Cache Expires 5 minutes" &
DateTime.Now.Ad dSeconds(300) & "<hr>")
Response.Cache. SetExpires(Date Time.Now.AddSec onds(300))

DropDownList1.D ataSource = dsMyDataset
DropDownList1.D ataValueField =
dsMyDataset.Tab les(0).Columns( 0).ToString
DropDownList1.D ataTextField =
dsMyDataset.Tab les(0).Columns( 1).ToString
DropDownList1.D ataBind()

when a button is clicked and a postback is caused the button handler
retrieves the cache dataset and rebinds it to a combo box.
I would have thought that if the page was posted back any later than 5
minutes that an error would occur because the cache had expired, but it
doesn't.
The lack of this error indicates to me that the cache is not expiring, but I do not know what I am doing wrong.
How do I make the cache expire in 5 minutes.

cheers

martin

[vMike]

I am not sure about datasets but with datatables and dataviews, if the cache
is empty it just returns nothing but does not generate an error. You can see
exactly what is in the cache by using the following

dim strCacheContent s as String
dim objItem as DictionaryEntry
dim strName as String
For Each objItem In Cache
strName = objItem.Key.tos tring()
strCacheContent s = "key=" & strName & "<br />"
Response.Write( strCacheContent s)
strCacheContent s = "value=" & Convert.ToStrin g(objItem.Value ) & "<br/>"
Response.Write( strCacheContent s)

Next
"martin" <ma***********@ hotmail.com> wrote in message
news:uA******** ******@tk2msftn gp13.phx.gbl...

Hi,

I am storing a dataset in cache, which is happening fine. I can easily
retrive it at postback from the cache, cast it to a dataset and reuse it.
However I have specified that the cache expire in 5 minutes like so.

If Not IsPostBack Then
BindMyDropDown( )
Else
Response.Write( "<hr>Cache Expires 5 minutes" &
DateTime.Now.Ad dSeconds(300) & "<hr>")
'If the cache had expired I would expect this line to cause an
error -- but it doesn't even if I cause postback after 15 minutes!!!
dsMyDataset = CType(Cache("ds "), DataSet)
Response.Cache. SetExpires(Date Time.Now.AddSec onds(300))
End If

I also set the cache expire in exactly the same way in the BindMyDropDown( ) function.
and place the dataset into the cache like so.

//code here
objConn.Open()
daMyDataAdapter .Fill(dsMyDatas et, "Customers" )
objConn.Close()
Cache.Insert("d s", dsMyDataset)
Response.Write( "<hr>Cache Expires 5 minutes" &
DateTime.Now.Ad dSeconds(300) & "<hr>")
Response.Cache. SetExpires(Date Time.Now.AddSec onds(300))

DropDownList1.D ataSource = dsMyDataset
DropDownList1.D ataValueField =
dsMyDataset.Tab les(0).Columns( 0).ToString
DropDownList1.D ataTextField =
dsMyDataset.Tab les(0).Columns( 1).ToString
DropDownList1.D ataBind()

when a button is clicked and a postback is caused the button handler
retrieves the cache dataset and rebinds it to a combo box.
I would have thought that if the page was posted back any later than 5
minutes that an error would occur because the cache had expired, but it
doesn't.
The lack of this error indicates to me that the cache is not expiring, but I do not know what I am doing wrong.
How do I make the cache expire in 5 minutes.

cheers

martin

[vMike]

You might also use this syntax.

Cache.Insert ("yourname",you rdatasetvariabl e,New CacheDependency (filepath)
or Nothing ,DateTime.MaxVa lue, TimeSpan.FromMi nutes(5))

I am not sure but I thought the response.cache ... applies to the whole
control or page not the item being named in the cache insert line, but I am
not expert. When I have used the response.cache I usually have several
other lines as follows (but this is for an entire page)

Response.Cache. SetExpires(Date Time.Now.AddSec onds(intCacheTi me))
Response.Cache. SetCacheability (HttpCacheabili ty.Public)
Response.Cache. SetValidUntilEx pires(True)
Response.Cache. VaryByParams("_ p") = True
Response.Cache. VaryByParams("_ h") = True
Response.Cache. VaryByParams("_ c") = True

"martin" <ma***********@ hotmail.com> wrote in message
news:uA******** ******@tk2msftn gp13.phx.gbl...

Hi,

I am storing a dataset in cache, which is happening fine. I can easily
retrive it at postback from the cache, cast it to a dataset and reuse it.
However I have specified that the cache expire in 5 minutes like so.

If Not IsPostBack Then
BindMyDropDown( )
Else
Response.Write( "<hr>Cache Expires 5 minutes" &
DateTime.Now.Ad dSeconds(300) & "<hr>")
'If the cache had expired I would expect this line to cause an
error -- but it doesn't even if I cause postback after 15 minutes!!!
dsMyDataset = CType(Cache("ds "), DataSet)
Response.Cache. SetExpires(Date Time.Now.AddSec onds(300))
End If

I also set the cache expire in exactly the same way in the BindMyDropDown( ) function.
and place the dataset into the cache like so.

//code here
objConn.Open()
daMyDataAdapter .Fill(dsMyDatas et, "Customers" )
objConn.Close()
Cache.Insert("d s", dsMyDataset)
Response.Write( "<hr>Cache Expires 5 minutes" &
DateTime.Now.Ad dSeconds(300) & "<hr>")
Response.Cache. SetExpires(Date Time.Now.AddSec onds(300))

DropDownList1.D ataSource = dsMyDataset
DropDownList1.D ataValueField =
dsMyDataset.Tab les(0).Columns( 0).ToString
DropDownList1.D ataTextField =
dsMyDataset.Tab les(0).Columns( 1).ToString
DropDownList1.D ataBind()

when a button is clicked and a postback is caused the button handler
retrieves the cache dataset and rebinds it to a combo box.
I would have thought that if the page was posted back any later than 5
minutes that an error would occur because the cache had expired, but it
doesn't.
The lack of this error indicates to me that the cache is not expiring, but I do not know what I am doing wrong.
How do I make the cache expire in 5 minutes.

cheers

martin