Export (0) Print
Expand All

AccessDataSourceView Class

Supports the AccessDataSource control and provides an interface for data-bound controls to perform data retrieval using Structured Query Language (SQL) against a Microsoft Access database.

Namespace:  System.Web.UI.WebControls
Assembly:  System.Web (in System.Web.dll)

public class AccessDataSourceView : SqlDataSourceView

The AccessDataSourceView type exposes the following members.

  NameDescription
Public methodAccessDataSourceViewInitializes a new instance of the AccessDataSourceView class setting the specified AccessDataSource control as the owner of the current view.
Top

  NameDescription
Public propertyCancelSelectOnNullParameterGets or sets a value indicating whether a data retrieval operation is canceled when any parameter that is contained in the SelectParameters collection evaluates to null. (Inherited from SqlDataSourceView.)
Public propertyCanDeleteGets a value indicating whether the SqlDataSourceView object that is associated with the current SqlDataSource control supports the delete operation. (Inherited from SqlDataSourceView.)
Public propertyCanInsertGets a value indicating whether the SqlDataSourceView object that is associated with the current SqlDataSource control supports the insert operation. (Inherited from SqlDataSourceView.)
Public propertyCanPageGets a value indicating whether the SqlDataSourceView object that is associated with the current SqlDataSource control supports the paging of retrieved data. (Inherited from SqlDataSourceView.)
Public propertyCanRetrieveTotalRowCountGets a value indicating whether the SqlDataSourceView object that is associated with the current SqlDataSource control supports retrieving the total number of data rows, in addition to the set of data. (Inherited from SqlDataSourceView.)
Public propertyCanSortGets a value indicating whether the SqlDataSourceView object that is associated with the current SqlDataSource control supports a sorted view on the retrieved data. (Inherited from SqlDataSourceView.)
Public propertyCanUpdateGets a value indicating whether the SqlDataSourceView object that is associated with the current SqlDataSource control supports the update operation. (Inherited from SqlDataSourceView.)
Public propertyConflictDetectionGets or sets the value indicating how the SqlDataSource control performs updates and deletes when data in a row in the underlying database changes during the time of the operation. (Inherited from SqlDataSourceView.)
Public propertyDeleteCommandGets or sets the SQL string that the SqlDataSourceView uses to delete data from the underlying database. (Inherited from SqlDataSourceView.)
Public propertyDeleteCommandTypeGets or sets a value indicating whether the text in the DeleteCommand property is a SQL statement or the name of a stored procedure. (Inherited from SqlDataSourceView.)
Public propertyDeleteParametersGets the parameters collection containing the parameters that are used by the DeleteCommand property. (Inherited from SqlDataSourceView.)
Protected propertyEventsGets a list of event-handler delegates for the data source view. (Inherited from DataSourceView.)
Public propertyFilterExpressionGets or sets a filtering expression that is applied when the Select method is called. (Inherited from SqlDataSourceView.)
Public propertyFilterParametersGets a collection of parameters that are associated with any parameter placeholders in the FilterExpression string. (Inherited from SqlDataSourceView.)
Public propertyInsertCommandGets or sets the SQL string that the SqlDataSourceView object uses to insert data into the underlying database. (Inherited from SqlDataSourceView.)
Public propertyInsertCommandTypeGets or sets a value indicating whether the text in the InsertCommand property is a SQL statement or the name of a stored procedure. (Inherited from SqlDataSourceView.)
Public propertyInsertParametersGets the parameters collection containing the parameters that are used by the InsertCommand property. (Inherited from SqlDataSourceView.)
Protected propertyIsTrackingViewStateGets a value indicating whether the SqlDataSourceView object is saving changes to its view state. (Inherited from SqlDataSourceView.)
Public propertyNameGets the name of the data source view. (Inherited from DataSourceView.)
Public propertyOldValuesParameterFormatStringGets or sets a format string to apply to the names of any parameters that are passed to the Delete or Update method. (Inherited from SqlDataSourceView.)
Protected propertyParameterPrefixGets the string that is used to prefix a parameter placeholder in a parameterized SQL query. (Inherited from SqlDataSourceView.)
Public propertySelectCommandGets or sets the SQL string that the SqlDataSourceView object uses to retrieve data from the underlying database. (Inherited from SqlDataSourceView.)
Public propertySelectCommandTypeGets or sets a value indicating whether the text in the SelectCommand property is a SQL query or the name of a stored procedure. (Inherited from SqlDataSourceView.)
Public propertySelectParametersGets the parameters collection containing the parameters that are used by the SelectCommand property. (Inherited from SqlDataSourceView.)
Public propertySortParameterNameGets or sets the name of a stored procedure parameter that is used to sort retrieved data when data retrieval is performed using a stored procedure. (Inherited from SqlDataSourceView.)
Public propertyUpdateCommandGets or sets the SQL string that the SqlDataSourceView object uses to update data in the underlying database. (Inherited from SqlDataSourceView.)
Public propertyUpdateCommandTypeGets or sets a value indicating whether the text in the UpdateCommand property is a SQL statement or the name of a stored procedure. (Inherited from SqlDataSourceView.)
Public propertyUpdateParametersGets the parameters collection containing the parameters that are used by the UpdateCommand property. (Inherited from SqlDataSourceView.)
Top

  NameDescription
Public methodCanExecuteDetermines whether the specified command can be executed. (Inherited from DataSourceView.)
Public methodDelete(IDictionary, IDictionary)Performs a delete operation using the DeleteCommand SQL string, any parameters that are specified in the DeleteParameters collection, and the values that are in the specified keys and oldValues collections. (Inherited from SqlDataSourceView.)
Public methodDelete(IDictionary, IDictionary, DataSourceViewOperationCallback)Performs an asynchronous delete operation on the list of data that the DataSourceView object represents. (Inherited from DataSourceView.)
Public methodEquals(Object)Determines whether the specified object is equal to the current object. (Inherited from Object.)
Protected methodExecuteCommand(String, IDictionary, IDictionary)Executes the specified command. (Inherited from DataSourceView.)
Public methodExecuteCommand(String, IDictionary, IDictionary, DataSourceViewOperationCallback)Executes the specified command. (Inherited from DataSourceView.)
Protected methodExecuteDeletePerforms a delete operation using the DeleteCommand SQL string, any parameters that are specified in the DeleteParameters collection, and the values that are in the specified keys and oldValues collections. (Inherited from SqlDataSourceView.)
Protected methodExecuteInsertPerforms an insert operation using the InsertCommand SQL string, any parameters that are specified in the InsertParameters collection, and the values that are in the specified values collection. (Inherited from SqlDataSourceView.)
Protected methodExecuteSelectRetrieves data from the underlying data storage using the SQL string in the SelectCommand property and any parameters in the SelectParameters collection. (Overrides SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments).)
Protected methodExecuteUpdatePerforms an update operation using the UpdateCommand SQL string, any parameters that are in the UpdateParameters collection, and the values that are in the specified keys, values, and oldValues collections. (Inherited from SqlDataSourceView.)
Protected methodFinalizeAllows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.)
Public methodGetHashCodeServes as the default hash function. (Inherited from Object.)
Public methodGetTypeGets the Type of the current instance. (Inherited from Object.)
Public methodInsert(IDictionary)Performs an insert operation using the InsertCommand SQL string, any parameters that are specified in the InsertParameters collection, and the values that are in the specified values collection. (Inherited from SqlDataSourceView.)
Public methodInsert(IDictionary, DataSourceViewOperationCallback)Performs an asynchronous insert operation on the list of data that the DataSourceView object represents. (Inherited from DataSourceView.)
Protected methodLoadViewStateRestores the previously saved view state for the data source view. (Inherited from SqlDataSourceView.)
Protected methodMemberwiseCloneCreates a shallow copy of the current Object. (Inherited from Object.)
Protected methodOnDataSourceViewChangedRaises the DataSourceViewChanged event. (Inherited from DataSourceView.)
Protected methodOnDeletedRaises the Deleted event after the SqlDataSource control has completed a delete operation. (Inherited from SqlDataSourceView.)
Protected methodOnDeletingRaises the Deleting event before the SqlDataSource control attempts a delete operation. (Inherited from SqlDataSourceView.)
Protected methodOnFilteringRaises the Filtering event before the SqlDataSource control filters the results of a select operation. (Inherited from SqlDataSourceView.)
Protected methodOnInsertedRaises the Inserted event after the SqlDataSource control has completed an insert operation. (Inherited from SqlDataSourceView.)
Protected methodOnInsertingRaises the Inserting event before the SqlDataSource control attempts an insert operation. (Inherited from SqlDataSourceView.)
Protected methodOnSelectedRaises the Selected event after the SqlDataSource control has completed a data retrieval operation. (Inherited from SqlDataSourceView.)
Protected methodOnSelectingRaises the Selecting event before the SqlDataSource control attempts a data retrieval operation. (Inherited from SqlDataSourceView.)
Protected methodOnUpdatedRaises the Updated event after the SqlDataSource control has completed an update operation. (Inherited from SqlDataSourceView.)
Protected methodOnUpdatingRaises the Updating event before the SqlDataSource control attempts an update operation. (Inherited from SqlDataSourceView.)
Protected methodRaiseUnsupportedCapabilityErrorCompares the capabilities that are requested for an ExecuteSelect operation against those that the view supports and is called by the RaiseUnsupportedCapabilitiesError method. (Inherited from SqlDataSourceView.)
Protected methodSaveViewStateSaves the changes to the view state for the SqlDataSourceView control since the time that the page was posted back to the server. (Inherited from SqlDataSourceView.)
Public methodSelect(DataSourceSelectArguments)Retrieves data from the underlying database using the SelectCommand SQL string and any parameters that are in the SelectParameters collection. (Inherited from SqlDataSourceView.)
Public methodSelect(DataSourceSelectArguments, DataSourceViewSelectCallback)Gets a list of data asynchronously from the underlying data storage. (Inherited from DataSourceView.)
Public methodToStringReturns a string that represents the current object. (Inherited from Object.)
Protected methodTrackViewStateCauses the SqlDataSourceView object to track changes to its view state so that the changes can be stored in the StateBag object for the control and persisted across requests for the same page. (Inherited from SqlDataSourceView.)
Public methodUpdate(IDictionary, IDictionary, IDictionary)Performs an update operation using the UpdateCommand SQL string, any parameters that are in the UpdateParameters collection, and the values that are in the specified keys, values, and oldValues collections. (Inherited from SqlDataSourceView.)
Public methodUpdate(IDictionary, IDictionary, IDictionary, DataSourceViewOperationCallback)Performs an asynchronous update operation on the list of data that the DataSourceView object represents. (Inherited from DataSourceView.)
Top

  NameDescription
Public eventDataSourceViewChangedOccurs when the data source view has changed. (Inherited from DataSourceView.)
Public eventDeletedOccurs when a delete operation has completed. (Inherited from SqlDataSourceView.)
Public eventDeletingOccurs before a delete operation. (Inherited from SqlDataSourceView.)
Public eventFilteringOccurs before a filter operation. (Inherited from SqlDataSourceView.)
Public eventInsertedOccurs when an insert operation has completed. (Inherited from SqlDataSourceView.)
Public eventInsertingOccurs before an insert operation. (Inherited from SqlDataSourceView.)
Public eventSelectedOccurs when a data retrieval operation has completed. (Inherited from SqlDataSourceView.)
Public eventSelectingOccurs before a data retrieval operation. (Inherited from SqlDataSourceView.)
Public eventUpdatedOccurs when an update operation has completed. (Inherited from SqlDataSourceView.)
Public eventUpdatingOccurs before an update operation. (Inherited from SqlDataSourceView.)
Top

  NameDescription
Explicit interface implemetationPrivate propertyIStateManager.IsTrackingViewStateFor a description of this member, see IsTrackingViewState. (Inherited from SqlDataSourceView.)
Explicit interface implemetationPrivate methodIStateManager.LoadViewStateInfrastructure. For a description of this member, see IStateManager.LoadViewState(Object). (Inherited from SqlDataSourceView.)
Explicit interface implemetationPrivate methodIStateManager.SaveViewStateInfrastructure. For a description of this member, see IStateManager.SaveViewState(). (Inherited from SqlDataSourceView.)
Explicit interface implemetationPrivate methodIStateManager.TrackViewStateInfrastructure. For a description of this member, see TrackViewState. (Inherited from SqlDataSourceView.)
Top

The AccessDataSourceView class is intended primarily to be used by data-bound controls and not as a programmable object in page code.

The AccessDataSourceView class is provided because Microsoft Access is a file-based database system and has several unique characteristics that set it apart from other SQL-based relational database products that the SqlDataSource control and SqlDataSourceView classes are used with.

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0

Windows 8.1, Windows Server 2012 R2, Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Show:
© 2014 Microsoft