SqlDataSourceView Properties

 

Namespace:   System.Web.UI.WebControls
Assembly:  System.Web (in System.Web.dll)

NameDescription
System_CAPS_pubpropertyCancelSelectOnNullParameter

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.

System_CAPS_pubpropertyCanDelete

Gets a value indicating whether the SqlDataSourceView object that is associated with the current SqlDataSource control supports the delete operation.(Overrides DataSourceView::CanDelete.)

System_CAPS_pubpropertyCanInsert

Gets a value indicating whether the SqlDataSourceView object that is associated with the current SqlDataSource control supports the insert operation.(Overrides DataSourceView::CanInsert.)

System_CAPS_pubpropertyCanPage

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.)

System_CAPS_pubpropertyCanRetrieveTotalRowCount

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.)

System_CAPS_pubpropertyCanSort

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.)

System_CAPS_pubpropertyCanUpdate

Gets a value indicating whether the SqlDataSourceView object that is associated with the current SqlDataSource control supports the update operation.(Overrides DataSourceView::CanUpdate.)

System_CAPS_pubpropertyConflictDetection

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.

System_CAPS_pubpropertyDeleteCommand

Gets or sets the SQL string that the SqlDataSourceView uses to delete data from the underlying database.

System_CAPS_pubpropertyDeleteCommandType

Gets or sets a value indicating whether the text in the DeleteCommand property is a SQL statement or the name of a stored procedure.

System_CAPS_pubpropertyDeleteParameters

Gets the parameters collection containing the parameters that are used by the DeleteCommand property.

System_CAPS_protpropertyEvents

Gets a list of event-handler delegates for the data source view.(Inherited from DataSourceView.)

System_CAPS_pubpropertyFilterExpression

Gets or sets a filtering expression that is applied when the Select method is called.

System_CAPS_pubpropertyFilterParameters

Gets a collection of parameters that are associated with any parameter placeholders in the FilterExpression string.

System_CAPS_pubpropertyInsertCommand

Gets or sets the SQL string that the SqlDataSourceView object uses to insert data into the underlying database.

System_CAPS_pubpropertyInsertCommandType

Gets or sets a value indicating whether the text in the InsertCommand property is a SQL statement or the name of a stored procedure.

System_CAPS_pubpropertyInsertParameters

Gets the parameters collection containing the parameters that are used by the InsertCommand property.

System_CAPS_protpropertyIsTrackingViewState

Gets a value indicating whether the SqlDataSourceView object is saving changes to its view state.

System_CAPS_pubpropertyName

Gets the name of the data source view.(Inherited from DataSourceView.)

System_CAPS_pubpropertyOldValuesParameterFormatString

Gets or sets a format string to apply to the names of any parameters that are passed to the Delete or Update method.

System_CAPS_protpropertyParameterPrefix

Gets the string that is used to prefix a parameter placeholder in a parameterized SQL query.

System_CAPS_pubpropertySelectCommand

Gets or sets the SQL string that the SqlDataSourceView object uses to retrieve data from the underlying database.

System_CAPS_pubpropertySelectCommandType

Gets or sets a value indicating whether the text in the SelectCommand property is a SQL query or the name of a stored procedure.

System_CAPS_pubpropertySelectParameters

Gets the parameters collection containing the parameters that are used by the SelectCommand property.

System_CAPS_pubpropertySortParameterName

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.

System_CAPS_pubpropertyUpdateCommand

Gets or sets the SQL string that the SqlDataSourceView object uses to update data in the underlying database.

System_CAPS_pubpropertyUpdateCommandType

Gets or sets a value indicating whether the text in the UpdateCommand property is a SQL statement or the name of a stored procedure.

System_CAPS_pubpropertyUpdateParameters

Gets the parameters collection containing the parameters that are used by the UpdateCommand property.

Return to top
Show: