LinqDataSource.EnableInsert Property

Definition

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

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

Property Value

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

Implements

Examples

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>
<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 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.

Applies to

See also