LinqDataSource.EnableInsert Property
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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.