I've recently started to work with the ASP.NET 2.0 beta and I'm filled with joy. The new features are really great. I was playing around with the new DataSource caching features. I've created an SqlDataSource that caches some data. Really easy and it looks just like this.
SqlDataSource ds = new SqlDataSource( ConnStr, "SELECT * FROM Table2;" );
ds.EnableCaching = true;
ds.CacheDuration = 30;
GridView grid = new GridView();
grid.DataSource = ds;
grid.DataBind();
this.Form.Controls.Add(grid);
The SqlDataSource looks if the Data is already in cache, and when it isn't, it will query the database and put the data in cache. But how -and here is my question- can I notice if the SqlDataSource has queried the database or has fetched the data from the cache? Is there a property that indicates that the data is in cache or is this easily programmed?