Export (0) Print
Expand All

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)

member InsertCommandType : SqlDataSourceCommandType with get, set
<asp:SqlDataSource InsertCommandType="SqlDataSourceCommandType" />

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.

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

.NET Framework

Supported in: 4.5, 4, 3.5, 3.0, 2.0

Windows 8.1, Windows Server 2012 R2, Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Show:
© 2014 Microsoft