Gets or sets a value indicating whether the System.Web.UI.WebControls.SqlDataSource control has data caching enabled.
Syntax
public virtual bool EnableCaching { set; get; }
Value
Documentation for this section has not yet been entered.
Remarks
The System.Web.UI.WebControls.SqlDataSource control supports data caching. While data is cached, the SqlDataSource.Select(System.Web.UI.DataSourceSelectArguments) method retrieves data from the cache rather than from the underlying database. When the cache expires, the SqlDataSource.Select(System.Web.UI.DataSourceSelectArguments) method retrieves data from the underlying database, and then caches the data again.
The System.Web.UI.WebControls.SqlDataSource control automatically caches data when the SqlDataSource.EnableCaching property is set to true and the SqlDataSource.CacheDuration property is set to a value greater than 0, which indicates the number of seconds that the cache stores data before retrieving a fresh set.
When you are using client impersonation under Microsoft Windows authentication, the data is cached when the first user accesses the data. If another user requests the same data, the data is retrieved from the cache. The data is not retrieved by making another call to the database to verify the user's access to the data. If you expect more than one user to access the data, and you want each retrieval to the data to be verified by the security configurations for the database, do not use caching.
Requirements
Assembly: System.Web (in System.Web.dll)
Assembly Versions: 2.0.0.0
Since: .NET 2.0