System.Web.UI.WebControls.SqlDataSourceView.DeleteCommand Property

Gets or sets the SQL string that the System.Web.UI.WebControls.SqlDataSourceView uses to delete data from the underlying database.

Syntax

public string DeleteCommand { set; get; }

Value

Documentation for this section has not yet been entered.

Remarks

Because different database products use different varieties of SQL, the syntax of the SQL string depends on the current ADO.NET provider being used, which is identified by the SqlDataSource.ProviderName property.

If the SQL string is a parameterized query or command, the placeholder of the parameter also depends on the ADO.NET provider being used. For example, if the provider is the System.Data.SqlClient, which is the default provider for the System.Web.UI.WebControls.SqlDataSource class, the placeholder of the parameter is '@parameterName'. However, if the provider is set to the System.Data.Odbc or System.Data.OleDb, the placeholder of the parameter is '?'. For more information on parameterized SQL queries and commands, see Using Parameters with the SqlDataSource Control.

The SqlDataSourceView.DeleteCommand can be an SQL string or the name of a stored procedure, if the underlying database supports stored procedures.

The value of the SqlDataSourceView.DeleteCommand property is stored in view state.

Requirements

Namespace: System.Web.UI.WebControls
Assembly: System.Web (in System.Web.dll)
Assembly Versions: 2.0.0.0
Since: .NET 2.0