Linq datasource parameters not working with Radgrid

[Chamin]

Hi

I'm using rad grid and implemented parameters for insert,update and where.
But created parameters for update not updated the database. Insert and where parameters are working perfectly.

Please look at the code how I implemented in the project,

<asp:LinqDataSource ID="ldsDList" runat="server" <br>                        ContextTypeName="MDataContext" <br>                        EnableDelete="True" EnableInsert="True" EnableUpdate="True" EntityTypeName="" <br>                        TableName="DLists"><br>                        <InsertParameters><br>                            <asp:ControlParameter ControlID="HFUser" Name="EnteredBy" <br>                            PropertyName="Value" Type="Int32" /><br>                            <asp:Parameter Name="DateEntered" Type="DateTime" /><br>                        </InsertParameters><br>                        <UpdateParameters><br>                            <asp:ControlParameter ControlID="HFUser" Name="ModifiedBy" <br>                            PropertyName="Value" Type="Int32" DbType="Int32" /><br>                            <asp:Parameter Name="DateModified" Type="DateTime" /><br>                        </UpdateParameters><br>                    </asp:LinqDataSource>

Protected Sub ldsDList_ContextCreating(sender As Object, e As System.Web.UI.WebControls.LinqDataSourceContextEventArgs) Handles ldsDList.ContextCreating<br>        If e.Operation = DataSourceOperation.Insert Then<br>            Me.ldsDList.InsertParameters("DateEntered").DefaultValue = DateTime.Now.ToString()<br>        ElseIf e.Operation = DataSourceOperation.Update Then<br>            Me.ldsDList.UpdateParameters("DateModified").DefaultValue = DateTime.Now.ToString()<br>        End If<br>    End Sub

[Angel Petrov]

Hi Chamin,

You don't have to configure the UpdateParameters manually - it can cause errors easily. You should configure the updateParameters using wizards in Design-time:

1. Select the LinqDataSource control on aspx.
2. Click the "Update" property.
3. Click "Add parameters" to add your updateParameters

A more clear demonstration on how to use LinqDataSource is shown in our demo. Also I suggest that you take a look at the following forum post.

Kind regards,
Angel Petrov
the Telerik team