LinqDataSource.EnableUpdate Property

Definition

Namespace:

System.Web.UI.WebControls

Assembly:

System.Web.Extensions.dll

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

public:
 property bool EnableUpdate { bool get(); void set(bool value); };

public bool EnableUpdate { get; set; }

member this.EnableUpdate : bool with get, set

Public Property EnableUpdate As Boolean

Property Value

Boolean

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

Implements

EnableUpdate

Examples

The following example shows a LinqDataSource control that has EnableUpdate set to true. A DetailsView control displays the data and creates a button that lets users update 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 EnableUpdate property to true when you want to enable users to update a data record by using the LinqDataSource control. When EnableUpdate is true, the LinqDataSource control uses LINQ to SQL to automatically create the command to update the data. You must include an interface that lets users update a record, such as a DetailsView control.

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