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; }
<asp:LinqDataSource EnableInsert="True|False" />

Property Value

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

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>

Windows 7, Windows Vista, Windows XP SP2, Windows Server 2008 R2, Windows Server 2008, Windows Server 2003

The .NET Framework and .NET Compact Framework do not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

.NET Framework

Supported in: 3.5

Community Additions

ADD
Show:
© 2015 Microsoft