Export (0) Print
Expand All

LinqDataSource.EnableInsert Property

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

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

public bool EnableInsert { get; set; }

Property Value

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

Implements

IDynamicDataSource.EnableInsert

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

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

The following example shows a LinqDataSource control that has EnableInsert set to true. A DetailsView control displays the data and displays a button that switches the control to insert mode where users can create and save a new 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