AccessDataSourceView AccessDataSourceView AccessDataSourceView AccessDataSourceView Class

Definition

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.

public ref class AccessDataSourceView : System::Web::UI::WebControls::SqlDataSourceView
public class AccessDataSourceView : System.Web.UI.WebControls.SqlDataSourceView
type AccessDataSourceView = class
    inherit SqlDataSourceView
Public Class AccessDataSourceView
Inherits SqlDataSourceView
Inheritance

Remarks

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.

Constructors

AccessDataSourceView(AccessDataSource, String, HttpContext) AccessDataSourceView(AccessDataSource, String, HttpContext) AccessDataSourceView(AccessDataSource, String, HttpContext) AccessDataSourceView(AccessDataSource, String, HttpContext)

Initializes a new instance of the AccessDataSourceView class setting the specified AccessDataSource control as the owner of the current view.

Methods

CanExecute(String) CanExecute(String) CanExecute(String) CanExecute(String)

Determines whether the specified command can be executed.

(Inherited from DataSourceView)
Delete(IDictionary, IDictionary) Delete(IDictionary, IDictionary) Delete(IDictionary, IDictionary) Delete(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)
Delete(IDictionary, IDictionary, DataSourceViewOperationCallback) Delete(IDictionary, IDictionary, DataSourceViewOperationCallback) Delete(IDictionary, IDictionary, DataSourceViewOperationCallback) Delete(IDictionary, IDictionary, DataSourceViewOperationCallback)

Performs an asynchronous delete operation on the list of data that the DataSourceView object represents.

(Inherited from DataSourceView)
Equals(Object) Equals(Object) Equals(Object) Equals(Object)

Determines whether the specified object is equal to the current object.

(Inherited from Object)
ExecuteCommand(String, IDictionary, IDictionary) ExecuteCommand(String, IDictionary, IDictionary) ExecuteCommand(String, IDictionary, IDictionary) ExecuteCommand(String, IDictionary, IDictionary)

Executes the specified command.

(Inherited from DataSourceView)
ExecuteCommand(String, IDictionary, IDictionary, DataSourceViewOperationCallback) ExecuteCommand(String, IDictionary, IDictionary, DataSourceViewOperationCallback) ExecuteCommand(String, IDictionary, IDictionary, DataSourceViewOperationCallback) ExecuteCommand(String, IDictionary, IDictionary, DataSourceViewOperationCallback)

Executes the specified command.

(Inherited from DataSourceView)
ExecuteDelete(IDictionary, IDictionary) ExecuteDelete(IDictionary, IDictionary) ExecuteDelete(IDictionary, IDictionary) ExecuteDelete(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)
ExecuteInsert(IDictionary) ExecuteInsert(IDictionary) ExecuteInsert(IDictionary) ExecuteInsert(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)
ExecuteSelect(DataSourceSelectArguments) ExecuteSelect(DataSourceSelectArguments) ExecuteSelect(DataSourceSelectArguments) ExecuteSelect(DataSourceSelectArguments)

Retrieves data from the underlying data storage using the SQL string in the SelectCommand property and any parameters in the SelectParameters collection.

ExecuteUpdate(IDictionary, IDictionary, IDictionary) ExecuteUpdate(IDictionary, IDictionary, IDictionary) ExecuteUpdate(IDictionary, IDictionary, IDictionary) ExecuteUpdate(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)
GetHashCode() GetHashCode() GetHashCode() GetHashCode()

Serves as the default hash function.

(Inherited from Object)
GetType() GetType() GetType() GetType()

Gets the Type of the current instance.

(Inherited from Object)
Insert(IDictionary) Insert(IDictionary) Insert(IDictionary) Insert(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)
Insert(IDictionary, DataSourceViewOperationCallback) Insert(IDictionary, DataSourceViewOperationCallback) Insert(IDictionary, DataSourceViewOperationCallback) Insert(IDictionary, DataSourceViewOperationCallback)

Performs an asynchronous insert operation on the list of data that the DataSourceView object represents.

(Inherited from DataSourceView)
LoadViewState(Object) LoadViewState(Object) LoadViewState(Object) LoadViewState(Object)

Restores the previously saved view state for the data source view.

(Inherited from SqlDataSourceView)
MemberwiseClone() MemberwiseClone() MemberwiseClone() MemberwiseClone()

Creates a shallow copy of the current Object.

(Inherited from Object)
OnDataSourceViewChanged(EventArgs) OnDataSourceViewChanged(EventArgs) OnDataSourceViewChanged(EventArgs) OnDataSourceViewChanged(EventArgs)

Raises the DataSourceViewChanged event.

(Inherited from DataSourceView)
OnDeleted(SqlDataSourceStatusEventArgs) OnDeleted(SqlDataSourceStatusEventArgs) OnDeleted(SqlDataSourceStatusEventArgs) OnDeleted(SqlDataSourceStatusEventArgs)

Raises the Deleted event after the SqlDataSource control has completed a delete operation.

(Inherited from SqlDataSourceView)
OnDeleting(SqlDataSourceCommandEventArgs) OnDeleting(SqlDataSourceCommandEventArgs) OnDeleting(SqlDataSourceCommandEventArgs) OnDeleting(SqlDataSourceCommandEventArgs)

Raises the Deleting event before the SqlDataSource control attempts a delete operation.

(Inherited from SqlDataSourceView)
OnFiltering(SqlDataSourceFilteringEventArgs) OnFiltering(SqlDataSourceFilteringEventArgs) OnFiltering(SqlDataSourceFilteringEventArgs) OnFiltering(SqlDataSourceFilteringEventArgs)

Raises the Filtering event before the SqlDataSource control filters the results of a select operation.

(Inherited from SqlDataSourceView)
OnInserted(SqlDataSourceStatusEventArgs) OnInserted(SqlDataSourceStatusEventArgs) OnInserted(SqlDataSourceStatusEventArgs) OnInserted(SqlDataSourceStatusEventArgs)

Raises the Inserted event after the SqlDataSource control has completed an insert operation.

(Inherited from SqlDataSourceView)
OnInserting(SqlDataSourceCommandEventArgs) OnInserting(SqlDataSourceCommandEventArgs) OnInserting(SqlDataSourceCommandEventArgs) OnInserting(SqlDataSourceCommandEventArgs)

Raises the Inserting event before the SqlDataSource control attempts an insert operation.

(Inherited from SqlDataSourceView)
OnSelected(SqlDataSourceStatusEventArgs) OnSelected(SqlDataSourceStatusEventArgs) OnSelected(SqlDataSourceStatusEventArgs) OnSelected(SqlDataSourceStatusEventArgs)

Raises the Selected event after the SqlDataSource control has completed a data retrieval operation.

(Inherited from SqlDataSourceView)
OnSelecting(SqlDataSourceSelectingEventArgs) OnSelecting(SqlDataSourceSelectingEventArgs) OnSelecting(SqlDataSourceSelectingEventArgs) OnSelecting(SqlDataSourceSelectingEventArgs)

Raises the Selecting event before the SqlDataSource control attempts a data retrieval operation.

(Inherited from SqlDataSourceView)
OnUpdated(SqlDataSourceStatusEventArgs) OnUpdated(SqlDataSourceStatusEventArgs) OnUpdated(SqlDataSourceStatusEventArgs) OnUpdated(SqlDataSourceStatusEventArgs)

Raises the Updated event after the SqlDataSource control has completed an update operation.

(Inherited from SqlDataSourceView)
OnUpdating(SqlDataSourceCommandEventArgs) OnUpdating(SqlDataSourceCommandEventArgs) OnUpdating(SqlDataSourceCommandEventArgs) OnUpdating(SqlDataSourceCommandEventArgs)

Raises the Updating event before the SqlDataSource control attempts an update operation.

(Inherited from SqlDataSourceView)
RaiseUnsupportedCapabilityError(DataSourceCapabilities) RaiseUnsupportedCapabilityError(DataSourceCapabilities) RaiseUnsupportedCapabilityError(DataSourceCapabilities) RaiseUnsupportedCapabilityError(DataSourceCapabilities)

Compares the capabilities that are requested for an ExecuteSelect(DataSourceSelectArguments) operation against those that the view supports and is called by the RaiseUnsupportedCapabilitiesError(DataSourceView) method.

(Inherited from SqlDataSourceView)
SaveViewState() SaveViewState() SaveViewState() SaveViewState()

Saves 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)
Select(DataSourceSelectArguments) Select(DataSourceSelectArguments) Select(DataSourceSelectArguments) Select(DataSourceSelectArguments)

Retrieves data from the underlying database using the SelectCommand SQL string and any parameters that are in the SelectParameters collection.

(Inherited from SqlDataSourceView)
Select(DataSourceSelectArguments, DataSourceViewSelectCallback) Select(DataSourceSelectArguments, DataSourceViewSelectCallback) Select(DataSourceSelectArguments, DataSourceViewSelectCallback) Select(DataSourceSelectArguments, DataSourceViewSelectCallback)

Gets a list of data asynchronously from the underlying data storage.

(Inherited from DataSourceView)
ToString() ToString() ToString() ToString()

Returns a string that represents the current object.

(Inherited from Object)
TrackViewState() TrackViewState() TrackViewState() TrackViewState()

Causes 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)
Update(IDictionary, IDictionary, IDictionary) Update(IDictionary, IDictionary, IDictionary) Update(IDictionary, IDictionary, IDictionary) Update(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)
Update(IDictionary, IDictionary, IDictionary, DataSourceViewOperationCallback) Update(IDictionary, IDictionary, IDictionary, DataSourceViewOperationCallback) Update(IDictionary, IDictionary, IDictionary, DataSourceViewOperationCallback) Update(IDictionary, IDictionary, IDictionary, DataSourceViewOperationCallback)

Performs an asynchronous update operation on the list of data that the DataSourceView object represents.

(Inherited from DataSourceView)

Events

DataSourceViewChanged DataSourceViewChanged DataSourceViewChanged DataSourceViewChanged

Occurs when the data source view has changed.

(Inherited from DataSourceView)
Deleted Deleted Deleted Deleted

Occurs when a delete operation has completed.

(Inherited from SqlDataSourceView)
Deleting Deleting Deleting Deleting

Occurs before a delete operation.

(Inherited from SqlDataSourceView)
Filtering Filtering Filtering Filtering

Occurs before a filter operation.

(Inherited from SqlDataSourceView)
Inserted Inserted Inserted Inserted

Occurs when an insert operation has completed.

(Inherited from SqlDataSourceView)
Inserting Inserting Inserting Inserting

Occurs before an insert operation.

(Inherited from SqlDataSourceView)
Selected Selected Selected Selected

Occurs when a data retrieval operation has completed.

(Inherited from SqlDataSourceView)
Selecting Selecting Selecting Selecting

Occurs before a data retrieval operation.

(Inherited from SqlDataSourceView)
Updated Updated Updated Updated

Occurs when an update operation has completed.

(Inherited from SqlDataSourceView)
Updating Updating Updating Updating

Occurs before an update operation.

(Inherited from SqlDataSourceView)

Properties

CancelSelectOnNullParameter CancelSelectOnNullParameter CancelSelectOnNullParameter CancelSelectOnNullParameter

Gets 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)
CanDelete CanDelete CanDelete CanDelete

Gets a value indicating whether the SqlDataSourceView object that is associated with the current SqlDataSource control supports the delete operation.

(Inherited from SqlDataSourceView)
CanInsert CanInsert CanInsert CanInsert

Gets a value indicating whether the SqlDataSourceView object that is associated with the current SqlDataSource control supports the insert operation.

(Inherited from SqlDataSourceView)
CanPage CanPage CanPage CanPage

Gets a value indicating whether the SqlDataSourceView object that is associated with the current SqlDataSource control supports the paging of retrieved data.

(Inherited from SqlDataSourceView)
CanRetrieveTotalRowCount CanRetrieveTotalRowCount CanRetrieveTotalRowCount CanRetrieveTotalRowCount

Gets 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)
CanSort CanSort CanSort CanSort

Gets 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)
CanUpdate CanUpdate CanUpdate CanUpdate

Gets a value indicating whether the SqlDataSourceView object that is associated with the current SqlDataSource control supports the update operation.

(Inherited from SqlDataSourceView)
ConflictDetection ConflictDetection ConflictDetection ConflictDetection

Gets 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)
DeleteCommand DeleteCommand DeleteCommand DeleteCommand

Gets or sets the SQL string that the SqlDataSourceView uses to delete data from the underlying database.

(Inherited from SqlDataSourceView)
DeleteCommandType DeleteCommandType DeleteCommandType DeleteCommandType

Gets 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)
DeleteParameters DeleteParameters DeleteParameters DeleteParameters

Gets the parameters collection containing the parameters that are used by the DeleteCommand property.

(Inherited from SqlDataSourceView)
Events Events Events Events

Gets a list of event-handler delegates for the data source view.

(Inherited from DataSourceView)
FilterExpression FilterExpression FilterExpression FilterExpression

Gets or sets a filtering expression that is applied when the Select method is called.

(Inherited from SqlDataSourceView)
FilterParameters FilterParameters FilterParameters FilterParameters

Gets a collection of parameters that are associated with any parameter placeholders in the FilterExpression string.

(Inherited from SqlDataSourceView)
InsertCommand InsertCommand InsertCommand InsertCommand

Gets or sets the SQL string that the SqlDataSourceView object uses to insert data into the underlying database.

(Inherited from SqlDataSourceView)
InsertCommandType InsertCommandType InsertCommandType InsertCommandType

Gets 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)
InsertParameters InsertParameters InsertParameters InsertParameters

Gets the parameters collection containing the parameters that are used by the InsertCommand property.

(Inherited from SqlDataSourceView)
IStateManager.IsTrackingViewState IStateManager.IsTrackingViewState IStateManager.IsTrackingViewState IStateManager.IsTrackingViewState

For a description of this member, see IsTrackingViewState.

(Inherited from SqlDataSourceView)
IsTrackingViewState IsTrackingViewState IsTrackingViewState IsTrackingViewState

Gets a value indicating whether the SqlDataSourceView object is saving changes to its view state.

(Inherited from SqlDataSourceView)
Name Name Name Name

Gets the name of the data source view.

(Inherited from DataSourceView)
OldValuesParameterFormatString OldValuesParameterFormatString OldValuesParameterFormatString OldValuesParameterFormatString

Gets 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)
ParameterPrefix ParameterPrefix ParameterPrefix ParameterPrefix

Gets the string that is used to prefix a parameter placeholder in a parameterized SQL query.

(Inherited from SqlDataSourceView)
SelectCommand SelectCommand SelectCommand SelectCommand

Gets or sets the SQL string that the SqlDataSourceView object uses to retrieve data from the underlying database.

(Inherited from SqlDataSourceView)
SelectCommandType SelectCommandType SelectCommandType SelectCommandType

Gets 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)
SelectParameters SelectParameters SelectParameters SelectParameters

Gets the parameters collection containing the parameters that are used by the SelectCommand property.

(Inherited from SqlDataSourceView)
SortParameterName SortParameterName SortParameterName SortParameterName

Gets 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)
UpdateCommand UpdateCommand UpdateCommand UpdateCommand

Gets or sets the SQL string that the SqlDataSourceView object uses to update data in the underlying database.

(Inherited from SqlDataSourceView)
UpdateCommandType UpdateCommandType UpdateCommandType UpdateCommandType

Gets 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)
UpdateParameters UpdateParameters UpdateParameters UpdateParameters

Gets the parameters collection containing the parameters that are used by the UpdateCommand property.

(Inherited from SqlDataSourceView)

Explicit Interface Implementations

IStateManager.LoadViewState(Object) IStateManager.LoadViewState(Object) IStateManager.LoadViewState(Object) IStateManager.LoadViewState(Object)

For a description of this member, see LoadViewState(Object).

(Inherited from SqlDataSourceView)
IStateManager.SaveViewState() IStateManager.SaveViewState() IStateManager.SaveViewState() IStateManager.SaveViewState()

For a description of this member, see SaveViewState().

(Inherited from SqlDataSourceView)
IStateManager.TrackViewState() IStateManager.TrackViewState() IStateManager.TrackViewState() IStateManager.TrackViewState()

For a description of this member, see TrackViewState().

(Inherited from SqlDataSourceView)

Applies to

See also