InsertCommandType Property

SqlDataSource.InsertCommandType Property


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

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

public SqlDataSourceCommandType InsertCommandType { get; set; }

Property Value

Type: System.Web.UI.WebControls.SqlDataSourceCommandType

One of the SqlDataSourceCommandType values. The default is the Text value.

The InsertCommandType property delegates to the InsertCommandType property of the SqlDataSourceView object that is associated with the SqlDataSource control.

The following code example demonstrates how to retrieve data from a Microsoft SQL Server database and display it in a GridView control. It also demonstrates how to use a DetailsView control to see details of a selected row in the GridView and as a form to insert new records.

The GridView control displays a set of data and the DetailsView displays the details for a particular row. If you click the automatically generated Insert button of the DetailsView control, the DetailsView shows a different user interface, which is used to insert a new record. The example uses a stored procedure to insert records and returns the primary key of the inserted row. The stored procedure name is set in the InsertCommand property and identified as a stored procedure by setting the InsertCommandType property to the StoredProcedure value.

After data is inserted into the database by the DetailsView control, the OnInserted event handler is called to handle the Inserted event, the value of the primary key of the inserted row is displayed, and the DataBind method of the GridView control is called explicitly to refresh the data.

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