System.Web.UI.WebControls.SqlDataSourceView: Method Members

The methods 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 Methods

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.

Protected Methods

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.