Bewerken

Delen via


AccessDataSourceView.ExecuteSelect(DataSourceSelectArguments) Method

Definition

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.IEnumerable
Protected Friend Overrides Function ExecuteSelect (arguments As DataSourceSelectArguments) As IEnumerable

Parameters

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.

Applies to

See also