AccessDataSourceView Members

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.

The following tables list the members exposed by the AccessDataSourceView type.

  Name Description
Public method AccessDataSourceView Initializes a new instance of the AccessDataSourceView class setting the specified AccessDataSource control as the owner of the current view.
Top

(see also Protected Properties )
  Name Description
Public property 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 a null reference (Nothing in Visual Basic).(Inherited from SqlDataSourceView.)
Public property CanDelete  Gets a value indicating whether the SqlDataSourceView object that is associated with the current SqlDataSource control supports the delete operation.(Inherited from SqlDataSourceView.)
Public property CanInsert  Gets a value indicating whether the SqlDataSourceView object that is associated with the current SqlDataSource control supports the insert operation.(Inherited from SqlDataSourceView.)
Public property 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.)
Public property 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.)
Public property 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.)
Public property CanUpdate  Gets a value indicating whether the SqlDataSourceView object that is associated with the current SqlDataSource control supports the update operation.(Inherited from SqlDataSourceView.)
Public property 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.)
Public property DeleteCommand  Gets or sets the SQL string that the SqlDataSourceView uses to delete data from the underlying database.(Inherited from SqlDataSourceView.)
Public property 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.)
Public property DeleteParameters  Gets the parameters collection containing the parameters that are used by the DeleteCommand property.(Inherited from SqlDataSourceView.)
Public property FilterExpression  Gets or sets a filtering expression that is applied when the Select method is called.(Inherited from SqlDataSourceView.)
Public property FilterParameters  Gets a collection of parameters that are associated with any parameter placeholders in the FilterExpression string.(Inherited from SqlDataSourceView.)
Public property InsertCommand  Gets or sets the SQL string that the SqlDataSourceView object uses to insert data into the underlying database.(Inherited from SqlDataSourceView.)
Public property 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.)
Public property InsertParameters  Gets the parameters collection containing the parameters that are used by the InsertCommand property.(Inherited from SqlDataSourceView.)
Public property Name  Gets the name of the data source view.(Inherited from DataSourceView.)
Public property 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.)
Public property SelectCommand  Gets or sets the SQL string that the SqlDataSourceView object uses to retrieve data from the underlying database.(Inherited from SqlDataSourceView.)
Public property 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.)
Public property SelectParameters  Gets the parameters collection containing the parameters that are used by the SelectCommand property.(Inherited from SqlDataSourceView.)
Public property 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.)
Public property UpdateCommand  Gets or sets the SQL string that the SqlDataSourceView object uses to update data in the underlying database.(Inherited from SqlDataSourceView.)
Public property 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.)
Public property UpdateParameters  Gets the parameters collection containing the parameters that are used by the UpdateCommand property.(Inherited from SqlDataSourceView.)
Top

  Name Description
Protected property Events  Gets a list of event-handler delegates for the data source view.(Inherited from DataSourceView.)
Protected property IsTrackingViewState  Gets a value indicating whether the SqlDataSourceView object is saving changes to its view state.(Inherited from SqlDataSourceView.)
Protected property ParameterPrefix  Gets the string that is used to prefix a parameter placeholder in a parameterized SQL query.(Inherited from SqlDataSourceView.)
Top

(see also Protected Methods )
  Name Description
Public method Delete  Overloaded. Performs a delete operation using the DeleteCommand SQL string and any specified delete parameters. (Inherited from SqlDataSourceView.)
Public method Equals  Overloaded. Determines whether two Object instances are equal. (Inherited from Object.)
Public method GetHashCode  Serves as a hash function for a particular type. GetHashCode is suitable for use in hashing algorithms and data structures like a hash table. (Inherited from Object.)
Public method GetType  Gets the Type of the current instance. (Inherited from Object.)
Public method Insert  Overloaded. Performs an insert operation using the InsertCommand SQL string and any specified insert parameters. (Inherited from SqlDataSourceView.)
Public method Static ReferenceEquals  Determines whether the specified Object instances are the same instance. (Inherited from Object.)
Public method Select  Overloaded. Retrieves data from the underlying database using the SelectCommand SQL string and any parameters that are in the SelectParameters collection. (Inherited from SqlDataSourceView.)
Public method ToString  Returns a String that represents the current Object. (Inherited from Object.)
Public method Update  Overloaded. Performs an update operation using the UpdateCommand SQL string and any specified update parameters. (Inherited from SqlDataSourceView.)
Top

  Name Description
Protected method ExecuteDelete  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.)
Protected method ExecuteInsert  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.)
Protected method ExecuteSelect Overridden. Retrieves data from the underlying data storage using the SQL string in the SelectCommand property and any parameters in the SelectParameters collection.
Protected method ExecuteUpdate  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.)
Protected method Finalize  Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection. (Inherited from Object.)
Protected method LoadViewState  Restores the previously saved view state for the data source view. (Inherited from SqlDataSourceView.)
Protected method MemberwiseClone  Creates a shallow copy of the current Object. (Inherited from Object.)
Protected method OnDataSourceViewChanged  Raises the DataSourceViewChanged event. (Inherited from DataSourceView.)
Protected method OnDeleted  Raises the Deleted event after the SqlDataSource control has completed a delete operation. (Inherited from SqlDataSourceView.)
Protected method OnDeleting  Raises the Deleting event before the SqlDataSource control attempts a delete operation. (Inherited from SqlDataSourceView.)
Protected method OnFiltering  Raises the Filtering event before the SqlDataSource control filters the results of a select operation. (Inherited from SqlDataSourceView.)
Protected method OnInserted  Raises the Inserted event after the SqlDataSource control has completed an insert operation. (Inherited from SqlDataSourceView.)
Protected method OnInserting  Raises the Inserting event before the SqlDataSource control attempts an insert operation. (Inherited from SqlDataSourceView.)
Protected method OnSelected  Raises the Selected event after the SqlDataSource control has completed a data retrieval operation. (Inherited from SqlDataSourceView.)
Protected method OnSelecting  Raises the Selecting event before the SqlDataSource control attempts a data retrieval operation. (Inherited from SqlDataSourceView.)
Protected method OnUpdated  Raises the Updated event after the SqlDataSource control has completed an update operation. (Inherited from SqlDataSourceView.)
Protected method OnUpdating  Raises the Updating event before the SqlDataSource control attempts an update operation. (Inherited from SqlDataSourceView.)
Protected method RaiseUnsupportedCapabilityError  Compares 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 method 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.)
Protected method 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.)
Top

  Name Description
Public event DataSourceViewChanged  Occurs when the data source view has changed.(Inherited from DataSourceView.)
Public event Deleted  Occurs when a delete operation has completed.(Inherited from SqlDataSourceView.)
Public event Deleting  Occurs before a delete operation.(Inherited from SqlDataSourceView.)
Public event Filtering  Occurs before a filter operation.(Inherited from SqlDataSourceView.)
Public event Inserted  Occurs when an insert operation has completed.(Inherited from SqlDataSourceView.)
Public event Inserting  Occurs before an insert operation.(Inherited from SqlDataSourceView.)
Public event Selected  Occurs when a data retrieval operation has completed.(Inherited from SqlDataSourceView.)
Public event Selecting  Occurs before a data retrieval operation.(Inherited from SqlDataSourceView.)
Public event Updated  Occurs when an update operation has completed.(Inherited from SqlDataSourceView.)
Public event Updating  Occurs before an update operation.(Inherited from SqlDataSourceView.)
Top

Community Additions

ADD
Show: