AccessDataSourceView.ExecuteSelect(DataSourceSelectArguments) Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Retrieves data from the underlying data storage using the SQL string in the SelectCommand property and any parameters in the SelectParameters collection.
protected public:
override System::Collections::IEnumerable ^ ExecuteSelect(System::Web::UI::DataSourceSelectArguments ^ arguments);protected internal override System.Collections.IEnumerable ExecuteSelect (System.Web.UI.DataSourceSelectArguments arguments);override this.ExecuteSelect : System.Web.UI.DataSourceSelectArguments -> System.Collections.IEnumerableProtected Friend Overrides Function ExecuteSelect (arguments As DataSourceSelectArguments) As IEnumerableParameters
- arguments
- DataSourceSelectArguments
A DataSourceSelectArguments that is used to request operations on the data beyond basic data retrieval.
Returns
An IEnumerable of data rows.
Exceptions
The DataFile property is null or an empty string ("").
The arguments passed to the ExecuteSelect(DataSourceSelectArguments) method specify that the data source should perform some additional work while retrieving data to enable paging or sorting through the retrieved data, but the data source control does not support the requested capability.
Remarks
The AccessDataSourceView object overrides the ExecuteSelect method to ensure that the DataFile property of its associated AccessDataSource control is set before retrieving data.
Before the ExecuteSelect method is performed, the OnSelecting method is called to raise the Selecting event. You can handle the Selecting event to examine the values of the parameters and to perform any preprocessing before a data retrieval operation.
To perform the data retrieval, the AccessDataSourceView object builds an IDbCommand object using the SelectCommand text and any associated SelectParameters properties. Then, the AccessDataSourceView object executes the IDbCommand object against the underlying data storage. After the operation completes, the OnSelected method is called to raise the Selected event. You can handle the Selected event to examine any return values and error codes and to perform any post-processing.
If the DataSourceMode property is set to the DataSet value and caching is enabled, the AccessDataSourceView retrieves data from and saves data to the cache during the data retrieval operation. The cache is created, discarded, or refreshed, based on the caching behavior that is specified by the combination of the CacheDuration and CacheExpirationPolicy properties.
If the DataSourceMode property is set to the DataSet value and a FilterExpression property has been specified, the DataSourceMode property is evaluated along with any supplied FilterParameters properties and the resulting filter is applied to the list of data during the Select operation.
