Gets or sets a value indicating whether the text in the InsertCommand property is an SQL statement or the name of a stored procedure.
Assembly: System.Web (in System.Web.dll)
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 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.
Available since 2.0