Export (0) Print
Expand All

LinqDataSource.EnableUpdate Property

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

Namespace:  System.Web.UI.WebControls
Assembly:  System.Web.Extensions (in System.Web.Extensions.dll)

'Declaration
Public Property EnableUpdate As Boolean

Property Value

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

Implements

IDynamicDataSource.EnableUpdate

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.

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>

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5
Show:
© 2015 Microsoft