SqlDataSourceView.InsertCommandType Property


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

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

member InsertCommandType : SqlDataSourceCommandType with get, set

Property Value

Type: System.Web.UI.WebControls.SqlDataSourceCommandType

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

Exception Condition

The selected value is not one of the SqlDataSourceCommandType values.

The value of the InsertCommandType property is stored in view state.

The following code example demonstrates how to retrieve data from Microsoft SQL Server, display it in a GridView control, and 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 control 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 is identified as a stored procedure by setting the InsertCommandType property to the StoredProcedure value.

Finally, after data is inserted by the DetailsView control into the database, 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.

No code example is currently available or this language may not be supported.

.NET Framework
Available since 2.0
Return to top