Update Cache with database changes

[SMG]

Hi there,

I want to update my cached dataset, if there is any change in database. I
know this is possible in case of ASP.Net 2.0 , But how do I execute the same
task with ASP.Net 1.0

As there is need, if any change in database/tables happens then my dataset
should be updated.

Any help on this,

Shailesh

[Shiva]

Check out this article:
http://msdn.microsoft.com/msdnmag/is...e/default.aspx
"SMG" <SM*@nodmain.com> wrote in message
news:ej*************@tk2msftngp13.phx.gbl...
Hi there,

I want to update my cached dataset, if there is any change in database. I
know this is possible in case of ASP.Net 2.0 , But how do I execute the same
task with ASP.Net 1.0

As there is need, if any change in database/tables happens then my dataset
should be updated.

Any help on this,

Shailesh

[Frank Mamone]

Interesting question, but what would happen if your application changed data
in your cached dataset? Would you not lose your changes?

-Frank
"SMG" <SM*@nodmain.com> wrote in message
news:ej*************@tk2msftngp13.phx.gbl...

Hi there,

I want to update my cached dataset, if there is any change in database. I
know this is possible in case of ASP.Net 2.0 , But how do I execute the same task with ASP.Net 1.0

As there is need, if any change in database/tables happens then my dataset
should be updated.

Any help on this,

Shailesh

[SMG]

No, Currently there is no provison for changing the data in cached dataset ,
It is being used only from reading.

:-)
Shailesh
"Frank Mamone" <fr**********@canada.com> wrote in message
news:e$**************@TK2MSFTNGP15.phx.gbl...
Interesting question, but what would happen if your application changed data
in your cached dataset? Would you not lose your changes?

-Frank
"SMG" <SM*@nodmain.com> wrote in message
news:ej*************@tk2msftngp13.phx.gbl...

Hi there,

I want to update my cached dataset, if there is any change in database. I
know this is possible in case of ASP.Net 2.0 , But how do I execute the same task with ASP.Net 1.0

As there is need, if any change in database/tables happens then my dataset
should be updated.

Any help on this,

Shailesh

[Harry Simpson]

Process:
Set up a trigger on the table that may change that the dataset is drwan
from.
Have the trigger write a file to a directory

Use the insert method of the cache object and include a file dependency of
the above filename.

This will expire the cache dataset and require a trip to get fresh data when
needed.

HTH
Harry Simpson

"Frank Mamone" <fr**********@canada.com> wrote in message
news:e$**************@TK2MSFTNGP15.phx.gbl...

Interesting question, but what would happen if your application changed
data
in your cached dataset? Would you not lose your changes?

-Frank
"SMG" <SM*@nodmain.com> wrote in message
news:ej*************@tk2msftngp13.phx.gbl...

Hi there,

I want to update my cached dataset, if there is any change in database. I
know this is possible in case of ASP.Net 2.0 , But how do I execute the

same

task with ASP.Net 1.0

As there is need, if any change in database/tables happens then my
dataset
should be updated.

Any help on this,

Shailesh