SqlDataSourceView Properties
Assembly: System.Web (in System.Web.dll)
| Name | Description | |
|---|---|---|
![]() | 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. |
![]() | CanDelete | Gets a value indicating whether the SqlDataSourceView object that is associated with the current SqlDataSource control supports the delete operation.(Overrides DataSourceView::CanDelete.) |
![]() | CanInsert | Gets a value indicating whether the SqlDataSourceView object that is associated with the current SqlDataSource control supports the insert operation.(Overrides DataSourceView::CanInsert.) |
![]() | 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.) |
![]() | 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.) |
![]() | 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.) |
![]() | CanUpdate | Gets a value indicating whether the SqlDataSourceView object that is associated with the current SqlDataSource control supports the update operation.(Overrides DataSourceView::CanUpdate.) |
![]() | 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. |
![]() | DeleteCommand | Gets or sets the SQL string that the SqlDataSourceView uses to delete data from the underlying database. |
![]() | 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. |
![]() | DeleteParameters | Gets the parameters collection containing the parameters that are used by the DeleteCommand property. |
![]() | Events | Gets a list of event-handler delegates for the data source view.(Inherited from DataSourceView.) |
![]() | FilterExpression | Gets or sets a filtering expression that is applied when the Select method is called. |
![]() | FilterParameters | Gets a collection of parameters that are associated with any parameter placeholders in the FilterExpression string. |
![]() | InsertCommand | Gets or sets the SQL string that the SqlDataSourceView object uses to insert data into the underlying database. |
![]() | 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. |
![]() | InsertParameters | Gets the parameters collection containing the parameters that are used by the InsertCommand property. |
![]() | IsTrackingViewState | Gets a value indicating whether the SqlDataSourceView object is saving changes to its view state. |
![]() | Name | Gets the name of the data source view.(Inherited from DataSourceView.) |
![]() | OldValuesParameterFormatString | |
![]() | ParameterPrefix | Gets the string that is used to prefix a parameter placeholder in a parameterized SQL query. |
![]() | SelectCommand | Gets or sets the SQL string that the SqlDataSourceView object uses to retrieve data from the underlying database. |
![]() | 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. |
![]() | SelectParameters | Gets the parameters collection containing the parameters that are used by the SelectCommand 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. |
![]() | UpdateCommand | Gets or sets the SQL string that the SqlDataSourceView object uses to update data in the underlying database. |
![]() | 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. |
![]() | UpdateParameters | Gets the parameters collection containing the parameters that are used by the UpdateCommand property. |
| Name | Description | |
|---|---|---|
![]() ![]() | IStateManager::IsTrackingViewState | For a description of this member, see IsTrackingViewState. |



