dataset in Cache object

[Guest]

On my first page I create and persist my datasets into the Cache object. On the following pages if I excecutenonquery commands in transactions that update or delete from the database, I find that I must recreate my datasets. doing an adapter.fill is not enough to refresh the dataset. Is there a better way to refresh datasets if a db update was done via commands. Is this a problem that I persist to the cache object?

 

[Scott Allen]

If the underlying data is changing frequently, sometimes it is better
not to cache the data at all.

Fill should refresh the DataSet if you have the MissingSchemaAction
property of the adapter set to the AddWithKey enumeration value.
Perhaps you could post some code to look at the problem more
specifically.
HTH,