The properties of System.Web.UI.WebControls.SqlDataSourceView are listed below. For a list of all members, see the SqlDataSourceView Members list.
See Also: Inherited members from System.Web.UI.DataSourceView
Public Properties
| CancelSelectOnNullParameter | bool.
Gets or sets a value indicating whether a data retrieval operation is canceled when any parameter that is contained in the SqlDataSourceView.SelectParameters collection evaluates to null. | |
| [read-only] override | CanDelete | bool.
Gets a value indicating whether the System.Web.UI.WebControls.SqlDataSourceView object that is associated with the current System.Web.UI.WebControls.SqlDataSource control supports the delete operation. |
| [read-only] override | CanInsert | bool.
Gets a value indicating whether the System.Web.UI.WebControls.SqlDataSourceView object that is associated with the current System.Web.UI.WebControls.SqlDataSource control supports the insert operation. |
| [read-only] override | CanPage | bool.
Gets a value indicating whether the System.Web.UI.WebControls.SqlDataSourceView object that is associated with the current System.Web.UI.WebControls.SqlDataSource control supports the paging of retrieved data. |
| [read-only] override | CanRetrieveTotalRowCount | bool.
Gets a value indicating whether the System.Web.UI.WebControls.SqlDataSourceView object that is associated with the current System.Web.UI.WebControls.SqlDataSource control supports retrieving the total number of data rows, in addition to the set of data. |
| [read-only] override | CanSort | bool.
Gets a value indicating whether the System.Web.UI.WebControls.SqlDataSourceView object that is associated with the current System.Web.UI.WebControls.SqlDataSource control supports a sorted view on the retrieved data. |
| [read-only] override | CanUpdate | bool.
Gets a value indicating whether the System.Web.UI.WebControls.SqlDataSourceView object that is associated with the current System.Web.UI.WebControls.SqlDataSource control supports the update operation. |
| ConflictDetection | System.Web.UI.ConflictOptions.
Gets or sets the value indicating how the System.Web.UI.WebControls.SqlDataSource control performs updates and deletes when data in a row in the underlying database changes during the time of the operation. | |
| DeleteCommand | string.
Gets or sets the SQL string that the System.Web.UI.WebControls.SqlDataSourceView uses to delete data from the underlying database. | |
| DeleteCommandType | SqlDataSourceCommandType.
Gets or sets a value indicating whether the text in the SqlDataSourceView.DeleteCommand property is a SQL statement or the name of a stored procedure. | |
| [read-only] | DeleteParameters | ParameterCollection.
Gets the parameters collection containing the parameters that are used by the SqlDataSourceView.DeleteCommand property. |
| FilterExpression | string.
Gets or sets a filtering expression that is applied when the erload:System.Web.UI.WebControls.SqlDataSourceView.Select method is called. | |
| [read-only] | FilterParameters | ParameterCollection.
Gets a collection of parameters that are associated with any parameter placeholders in the SqlDataSourceView.FilterExpression string. |
| InsertCommand | string.
Gets or sets the SQL string that the System.Web.UI.WebControls.SqlDataSourceView object uses to insert data into the underlying database. | |
| InsertCommandType | SqlDataSourceCommandType.
Gets or sets a value indicating whether the text in the SqlDataSourceView.InsertCommand property is a SQL statement or the name of a stored procedure. | |
| [read-only] | InsertParameters | ParameterCollection.
Gets the parameters collection containing the parameters that are used by the SqlDataSourceView.InsertCommand property. |
| OldValuesParameterFormatString | string.
Gets or sets a format string to apply to the names of any parameters that are passed to the erload:System.Web.UI.WebControls.SqlDataSourceView.Delete or erload:System.Web.UI.WebControls.SqlDataSourceView.Update method. | |
| SelectCommand | string.
Gets or sets the SQL string that the System.Web.UI.WebControls.SqlDataSourceView object uses to retrieve data from the underlying database. | |
| SelectCommandType | SqlDataSourceCommandType.
Gets or sets a value indicating whether the text in the SqlDataSourceView.SelectCommand property is a SQL query or the name of a stored procedure. | |
| [read-only] | SelectParameters | ParameterCollection.
Gets the parameters collection containing the parameters that are used by the SqlDataSourceView.SelectCommand property. |
| SortParameterName | string.
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 | string.
Gets or sets the SQL string that the System.Web.UI.WebControls.SqlDataSourceView object uses to update data in the underlying database. | |
| UpdateCommandType | SqlDataSourceCommandType.
Gets or sets a value indicating whether the text in the SqlDataSourceView.UpdateCommand property is a SQL statement or the name of a stored procedure. | |
| [read-only] | UpdateParameters | ParameterCollection.
Gets the parameters collection containing the parameters that are used by the SqlDataSourceView.UpdateCommand property. |
Protected Properties
| [read-only] | IsTrackingViewState | bool.
Gets a value indicating whether the System.Web.UI.WebControls.SqlDataSourceView object is saving changes to its view state. |
| [read-only] | ParameterPrefix | string.
Gets the string that is used to prefix a parameter placeholder in a parameterized SQL query. |