Members

SqlDataSourceView(SqlDataSource, string, System.Web.HttpContext)

Initializes a new instance of the System.Web.UI.WebControls.SqlDataSourceView class setting the specified System.Web.UI.WebControls.SqlDataSource control as the owner of the current view.

	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.

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

	Delete(IDictionary, IDictionary) : int Performs a delete operation using the SqlDataSourceView.DeleteCommand SQL string, any parameters that are specified in the SqlDataSourceView.DeleteParameters collection, and the values that are in the specified keys and oldValues collections.
	Insert(IDictionary) : int Performs an insert operation using the SqlDataSourceView.InsertCommand SQL string, any parameters that are specified in the SqlDataSourceView.InsertParameters collection, and the values that are in the specified values collection.
	Select(System.Web.UI.DataSourceSelectArguments) : IEnumerable Retrieves data from the underlying database using the SqlDataSourceView.SelectCommand SQL string and any parameters that are in the SqlDataSourceView.SelectParameters collection.
	Update(IDictionary, IDictionary, IDictionary) : int Performs an update operation using the SqlDataSourceView.UpdateCommand SQL string, any parameters that are in the SqlDataSourceView.UpdateParameters collection, and the values that are in the specified keys, values, and oldValues collections.

override	ExecuteDelete(IDictionary, IDictionary) : int Performs a delete operation using the SqlDataSourceView.DeleteCommand SQL string, any parameters that are specified in the SqlDataSourceView.DeleteParameters collection, and the values that are in the specified keys and oldValues collections.
override	ExecuteInsert(IDictionary) : int Performs an insert operation using the SqlDataSourceView.InsertCommand SQL string, any parameters that are specified in the SqlDataSourceView.InsertParameters collection, and the values that are in the specified values collection.
override	ExecuteSelect(System.Web.UI.DataSourceSelectArguments) : IEnumerable Retrieves data from the underlying database using the SqlDataSourceView.SelectCommand SQL string and any parameters that are in the SqlDataSourceView.SelectParameters collection.
override	ExecuteUpdate(IDictionary, IDictionary, IDictionary) : int Performs an update operation using the SqlDataSourceView.UpdateCommand SQL string, any parameters that are in the SqlDataSourceView.UpdateParameters collection, and the values that are in the specified keys, values, and oldValues collections.
	LoadViewState(object) Restores the previously saved view state for the data source view.
	OnDeleted(SqlDataSourceStatusEventArgs) Raises the SqlDataSourceView.Deleted event after the System.Web.UI.WebControls.SqlDataSource control has completed a delete operation.
	OnDeleting(SqlDataSourceCommandEventArgs) Raises the SqlDataSourceView.Deleting event before the System.Web.UI.WebControls.SqlDataSource control attempts a delete operation.
	OnFiltering(SqlDataSourceFilteringEventArgs) Raises the SqlDataSourceView.Filtering event before the System.Web.UI.WebControls.SqlDataSource control filters the results of a select operation.
	OnInserted(SqlDataSourceStatusEventArgs) Raises the SqlDataSourceView.Inserted event after the System.Web.UI.WebControls.SqlDataSource control has completed an insert operation.
	OnInserting(SqlDataSourceCommandEventArgs) Raises the SqlDataSourceView.Inserting event before the System.Web.UI.WebControls.SqlDataSource control attempts an insert operation.
	OnSelected(SqlDataSourceStatusEventArgs) Raises the SqlDataSourceView.Selected event after the System.Web.UI.WebControls.SqlDataSource control has completed a data retrieval operation.
	OnSelecting(SqlDataSourceSelectingEventArgs) Raises the SqlDataSourceView.Selecting event before the System.Web.UI.WebControls.SqlDataSource control attempts a data retrieval operation.
	OnUpdated(SqlDataSourceStatusEventArgs) Raises the SqlDataSourceView.Updated event after the System.Web.UI.WebControls.SqlDataSource control has completed an update operation.
	OnUpdating(SqlDataSourceCommandEventArgs) Raises the SqlDataSourceView.Updating event before the System.Web.UI.WebControls.SqlDataSource control attempts an update operation.
	SaveViewState() : object Saves the changes to the view state for the System.Web.UI.WebControls.SqlDataSourceView control since the time that the page was posted back to the server.
	TrackViewState() Causes the System.Web.UI.WebControls.SqlDataSourceView object to track changes to its view state so that the changes can be stored in the System.Web.UI.StateBag object for the control and persisted across requests for the same page.

	Deleted	Occurs when a delete operation has completed.
	Deleting	Occurs before a delete operation.
	Filtering	Occurs before a filter operation.
	Inserted	Occurs when an insert operation has completed.
	Inserting	Occurs before an insert operation.
	Selected	Occurs when a data retrieval operation has completed.
	Selecting	Occurs before a data retrieval operation.
	Updated	Occurs when an update operation has completed.
	Updating	Occurs before an update operation.

[read-only]	System.Web.UI.IStateManager.IsTrackingViewState	bool. For a description of this member, see System.Web.UI.IStateManager.IsTrackingViewState.
	System.Web.UI.IStateManager.LoadViewState	For a description of this member, see System.Web.UI.IStateManager.LoadViewState(object).
	System.Web.UI.IStateManager.SaveViewState	For a description of this member, see System.Web.UI.IStateManager.SaveViewState.
	System.Web.UI.IStateManager.TrackViewState	For a description of this member, see System.Web.UI.IStateManager.TrackViewState.

Public Constructors

Public Properties

Protected Properties

Public Methods

Protected Methods

Public Events

Explicitly Implemented Interface Members