This documentation is archived and is not being maintained.

SqlDataSourceView Properties

The SqlDataSourceView type exposes the following members.

  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
Show: