This documentation is archived and is not being maintained.

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:
property SqlDataSourceCommandType InsertCommandType {
	SqlDataSourceCommandType get ();
	void set (SqlDataSourceCommandType value);
}
<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.

Windows 7, Windows Vista, Windows XP SP2, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP Starter Edition, Windows Server 2008 R2, Windows Server 2008, Windows Server 2003, Windows Server 2000 SP4, Windows Millennium Edition, Windows 98

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

.NET Framework

Supported in: 3.5, 3.0, 2.0
Show: