This documentation is archived and is not being maintained.
SqlDataSourceView Properties
Visual Studio 2008
The SqlDataSourceView type exposes the following members.
| 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 nullptr. |
|
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 | Gets or sets a format string to apply to the names of any parameters that are passed to the Delete or Update method. |
|
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. |
Show: