Edit

Share via


LinqDataSource.EnableDelete Property

Definition

Gets or sets a value that indicates whether data records can be deleted through the LinqDataSource control.

public:
 property bool EnableDelete { bool get(); void set(bool value); };
public bool EnableDelete { get; set; }
member this.EnableDelete : bool with get, set
Public Property EnableDelete As Boolean

Property Value

true if automatic delete operations are enabled; otherwise, false. The default value is false.

Implements

Examples

The following example shows a LinqDataSource control that has EnableDelete set to true. A DetailsView control displays the data and creates a button that lets users delete a data record.

<asp:LinqDataSource 
    ContextTypeName="ExampleDataContext" 
    TableName="Products" 
    EnableUpdate="true"
    EnableInsert="true"
    EnableDelete="true"
    ID="LinqDataSource1" 
    runat="server">
</asp:LinqDataSource>
<asp:DetailsView 
    DataKeyNames="ProductID"
    AutoGenerateEditButton="true"
    AutoGenerateDeleteButton="true"
    AutoGenerateInsertButton="true"
    AllowPaging="true"
    DataSourceID="LinqDataSource1"
    ID="GridView1" 
    runat="server">
</asp:DetailsView>
<asp:LinqDataSource 
    ContextTypeName="ExampleDataContext" 
    TableName="Products" 
    EnableUpdate="true"
    EnableInsert="true"
    EnableDelete="true"
    ID="LinqDataSource1" 
    runat="server">
</asp:LinqDataSource>
<asp:DetailsView 
    DataKeyNames="ProductID"
    AutoGenerateEditButton="true"
    AutoGenerateDeleteButton="true"
    AutoGenerateInsertButton="true"
    AllowPaging="true"
    DataSourceID="LinqDataSource1"
    ID="GridView1" 
    runat="server">
</asp:DetailsView>

Remarks

Set the EnableDelete property to true when you want to enable users to delete a data record through the LinqDataSource control. When EnableDelete is true, the LinqDataSource control uses LINQ to SQL to automatically create the command to delete the data. You must include an interface that lets users select a record to delete, such as a DetailsView control.

The LinqDataSource control does not support automatic delete operations when the Select property or the GroupBy property is set. In that case, the LinqDataSource control throws an exception if a delete operation is tried.

Applies to

See also