ExecuteInsert Method

DataSourceView.ExecuteInsert Method (IDictionary)


Performs an insert operation on the list of data that the DataSourceView object represents.

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

protected virtual int ExecuteInsert(
	IDictionary values


Type: System.Collections.IDictionary

An IDictionary of name/value pairs used during an insert operation.

Return Value

Type: System.Int32

The number of items that were inserted into the underlying data storage.

Exception Condition

The ExecuteInsert operation is not supported by the DataSourceView.

Data-bound controls can determine whether the ExecuteInsert operation is supported by a data source control by retrieving the DataSourceView object using the GetView method, and checking the CanInsert property.

The values parameter is a set of name/value pairs that represents data columns or fields and corresponding values to insert.


The DataSourceView class's default implementation is to throw a NotSupportedException exception. If you extend the DataSourceView class, override the ExecuteInsert method if your class supports insertion into the underlying data storage.

The following code example demonstrates how a class that extends the DataSourceView class can override the CanInsert property and the ExecuteInsert method. This code example is part of a larger example provided for the DataSourceView class.

// The CsvDataSourceView does not currently
// permit insertion of a new record. You can
// modify or extend this sample to do so.
public override bool CanInsert {
    get {
        return false;
protected override int ExecuteInsert(IDictionary values)
    throw new NotSupportedException();

.NET Framework
Available since 2.0
Return to top
© 2015 Microsoft