SqlDataSourceView Properties
.NET Framework 2.0
(see also
Protected Properties
)
Top
| 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 a null reference (Nothing in Visual Basic). |
| CanDelete | Gets a value indicating whether the SqlDataSourceView object that is associated with the current SqlDataSource control supports the delete operation. |
| CanInsert | Gets a value indicating whether the SqlDataSourceView object that is associated with the current SqlDataSource control supports the insert operation. |
| CanPage | Gets a value indicating whether the SqlDataSourceView object that is associated with the current SqlDataSource control supports the paging of retrieved data. |
| 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. |
| 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. |
| CanUpdate | Gets a value indicating whether the SqlDataSourceView object that is associated with the current SqlDataSource control supports the update operation. |
| 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. |
| 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. |
| 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. |
| 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 | |
|---|---|---|
| Events | Gets a list of event-handler delegates for the data source view. (Inherited from DataSourceView.) |
| IsTrackingViewState | Gets a value indicating whether the SqlDataSourceView object is saving changes to its view state. |
| ParameterPrefix | Gets the string that is used to prefix a parameter placeholder in a parameterized SQL query. |
| Name | Description | |
|---|---|---|
| System.Web.UI.IStateManager.IsTrackingViewState | For a description of this member, see IsTrackingViewState. |
Community Additions
ADD
Show: