This documentation is archived and is not being maintained.

SqlDataSourceView Members

Supports the SqlDataSource control and provides an interface for data-bound controls to perform SQL data operations against relational databases.

The SqlDataSourceView type exposes the following members.

  NameDescription
Public method SqlDataSourceView Initializes a new instance of the SqlDataSourceView class setting the specified SqlDataSource control as the owner of the current view.
Top

  NameDescription
Public method Delete Overloaded. Performs a delete operation using the DeleteCommand SQL string and any specified delete parameters.
Public method Equals Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
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. (Overrides DataSourceView::ExecuteDelete(IDictionary, IDictionary).)
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. (Overrides DataSourceView::ExecuteInsert(IDictionary).)
Protected method ExecuteSelect Retrieves data from the underlying database using the SelectCommand SQL string and any parameters that are in the SelectParameters collection. (Overrides DataSourceView::ExecuteSelect(DataSourceSelectArguments).)
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. (Overrides DataSourceView::ExecuteUpdate(IDictionary, IDictionary, IDictionary).)
Protected method Finalize Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.)
Public method GetHashCode Serves as a hash function for a particular type. (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.
Protected method LoadViewState Restores the previously saved view state for the data source view.
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.
Protected method OnDeleting Raises the Deleting event before the SqlDataSource control attempts a delete operation.
Protected method OnFiltering Raises the Filtering event before the SqlDataSource control filters the results of a select operation.
Protected method OnInserted Raises the Inserted event after the SqlDataSource control has completed an insert operation.
Protected method OnInserting Raises the Inserting event before the SqlDataSource control attempts an insert operation.
Protected method OnSelected Raises the Selected event after the SqlDataSource control has completed a data retrieval operation.
Protected method OnSelecting Raises the Selecting event before the SqlDataSource control attempts a data retrieval operation.
Protected method OnUpdated Raises the Updated event after the SqlDataSource control has completed an update operation.
Protected method OnUpdating Raises the Updating event before the SqlDataSource control attempts an update operation.
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. (Overrides DataSourceView::RaiseUnsupportedCapabilityError(DataSourceCapabilities).)
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.
Public method Select Overloaded. Retrieves data from the underlying database using the SelectCommand SQL string and any parameters that are in the SelectParameters collection.
Public method ToString Returns a string that represents the current object. (Inherited from Object.)
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.
Public method Update Overloaded. Performs an update operation using the UpdateCommand SQL string and any specified update parameters.
Top

  NameDescription
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 nullptr.
Public property CanDelete Gets a value indicating whether the SqlDataSourceView object that is associated with the current SqlDataSource control supports the delete operation. (Overrides DataSourceView::CanDelete.)
Public property CanInsert Gets a value indicating whether the SqlDataSourceView object that is associated with the current SqlDataSource control supports the insert operation. (Overrides DataSourceView::CanInsert.)
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. (Overrides DataSourceView::CanPage.)
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. (Overrides DataSourceView::CanRetrieveTotalRowCount.)
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. (Overrides DataSourceView::CanSort.)
Public property CanUpdate Gets a value indicating whether the SqlDataSourceView object that is associated with the current SqlDataSource control supports the update operation. (Overrides DataSourceView::CanUpdate.)
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.
Public property DeleteCommand Gets or sets the SQL string that the SqlDataSourceView uses to delete data from the underlying database.
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.
Public property DeleteParameters Gets the parameters collection containing the parameters that are used by the DeleteCommand property.
Protected property Events Gets a list of event-handler delegates for the data source view. (Inherited from DataSourceView.)
Public property FilterExpression Gets or sets a filtering expression that is applied when the Select method is called.
Public property FilterParameters Gets a collection of parameters that are associated with any parameter placeholders in the FilterExpression string.
Public property InsertCommand Gets or sets the SQL string that the SqlDataSourceView object uses to insert data into the underlying database.
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.
Public property InsertParameters Gets the parameters collection containing the parameters that are used by the InsertCommand property.
Protected property IsTrackingViewState Gets a value indicating whether the SqlDataSourceView object is saving changes to its view state.
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.
Protected property ParameterPrefix Gets the string that is used to prefix a parameter placeholder in a parameterized SQL query.
Public property SelectCommand Gets or sets the SQL string that the SqlDataSourceView object uses to retrieve data from the underlying database.
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.
Public property SelectParameters Gets the parameters collection containing the parameters that are used by the SelectCommand property.
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.
Public property UpdateCommand Gets or sets the SQL string that the SqlDataSourceView object uses to update data in the underlying database.
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.
Public property UpdateParameters Gets the parameters collection containing the parameters that are used by the UpdateCommand property.
Top

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

  NameDescription
Explicit interface implemetation Private property IStateManager::IsTrackingViewState For a description of this member, see IsTrackingViewState.
Explicit interface implemetation Private method IStateManager::LoadViewState Infrastructure. For a description of this member, see IStateManager::LoadViewState(Object).
Explicit interface implemetation Private method IStateManager::SaveViewState Infrastructure. For a description of this member, see IStateManager::SaveViewState().
Explicit interface implemetation Private method IStateManager::TrackViewState Infrastructure. For a description of this member, see TrackViewState.
Top
Show: