Telerik Grid + Telerik ORM Updating

[Sander]

Hi Folks,

I am new to Telerik ORM.

I have a telerik grid with openaccessdatasource with delete and update enabled, the grid shows the current data but when i try to edit/update them it does not work, the changes are not made.

what am i doeing wrong, this is my code:

<%@ Page Title="" Language="C#" MasterPageFile="~/Operator.Master" AutoEventWireup="true"
    CodeBehind="Channels.aspx.cs" Inherits="IMS_Telerik.Operators.Prepare.TelevisionRadio.Channels" %>

<%@ Register Assembly="Telerik.OpenAccess.Web" Namespace="Telerik.OpenAccess" TagPrefix="telerik" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">


    <table cellpadding="0" cellspacing="0" style="border: none;" width="100%">
        <tr>
            <td style="border: none;" valign="top" width="300px">
                <table width="300px" cellpadding="0" cellspacing="0" style="padding: 5px;
  border: solid 1px #e8eef4; margin-right:15px;">
                    <tr>
                        <td valign="top" style="margin-right: 15px">
                            <telerik:RadPanelBar ID="RadPanelBar1" runat="server" Skin="Black" Width="100%">
                                <Items>
                                    <telerik:RadPanelItem runat="server" Expanded="True" Text="Actions">
                                        <Items>
                                            <telerik:RadPanelItem runat="server" Height="30px"
                                                ImageUrl="~/Images/Icons/Menu/rtvchannel.png" Selected="True" Text="Channels">
                                            </telerik:RadPanelItem>
                                            <telerik:RadPanelItem runat="server" Height="30px"
                                                ImageUrl="~/Images/Icons/Menu/rtvchannel-add.png"
                                                NavigateUrl="~/Operators/Prepare/TelevisionRadio/AddChannels.aspx"
                                                Text="Add Channel">
                                            </telerik:RadPanelItem>
                                        </Items>
                                    </telerik:RadPanelItem>
                                </Items>
                            </telerik:RadPanelBar>
                        </td>
                    </tr>
                </table>
            </td>
            <td style="border: none;" valign="top">
                <table width="100%" cellpadding="0" cellspacing="0" style="padding: 5px;
  border: solid 1px #e8eef4;">
                    <tr>
                        <td valign="top">
                            <telerik:RadGrid ID="RadGrid1" runat="server" CellSpacing="0"
                                DataSourceID="OpenAccessDataSource1" GridLines="None" Skin="Black"
                                AllowFilteringByColumn="True" AllowPaging="True" AllowSorting="True"
                                AutoGenerateDeleteColumn="True" AutoGenerateEditColumn="True"
                                ShowGroupPanel="True">
                                <ClientSettings AllowColumnsReorder="True" AllowDragToGroup="True"
                                    ReorderColumnsOnClient="True">
                                    <Selecting AllowRowSelect="True" />
                                    <Scrolling AllowScroll="True" UseStaticHeaders="True" />
                                </ClientSettings>
<MasterTableView AutoGenerateColumns="False" DataSourceID="OpenAccessDataSource1">
<CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings>

<RowIndicatorColumn FilterControlAltText="Filter RowIndicator column">
<HeaderStyle Width="20px"></HeaderStyle>
</RowIndicatorColumn>

<ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column">
<HeaderStyle Width="20px"></HeaderStyle>
</ExpandCollapseColumn>

    <Columns>
        <telerik:GridBoundColumn DataField="Channel_id" DataType="System.UInt32"
            FilterControlAltText="Filter Channel_id column" HeaderText="Channel_id"
            SortExpression="Channel_id" UniqueName="Channel_id">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="Channel_epg_id"
            FilterControlAltText="Filter Channel_epg_id column" HeaderText="Channel_epg_id"
            SortExpression="Channel_epg_id" UniqueName="Channel_epg_id" Visible="false">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="Channel_name"
            FilterControlAltText="Filter Channel_name column" HeaderText="Channel_name"
            SortExpression="Channel_name" UniqueName="Channel_name">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="Channel_image"
            FilterControlAltText="Filter Channel_image column" HeaderText="Channel_image"
            SortExpression="Channel_image" UniqueName="Channel_image">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="Channel_image_icon"
            FilterControlAltText="Filter Channel_image_icon column"
            HeaderText="Channel_image_icon" SortExpression="Channel_image_icon"
            UniqueName="Channel_image_icon" Visible="false">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="Channel_level"
            FilterControlAltText="Filter Channel_level column" HeaderText="Channel_level"
            SortExpression="Channel_level" UniqueName="Channel_level" Visible="false">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="Channel_category"
            FilterControlAltText="Filter Channel_category column"
            HeaderText="Channel_category" SortExpression="Channel_category"
            UniqueName="Channel_category" Visible="false">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="Channel_group"
            FilterControlAltText="Filter Channel_group column" HeaderText="Channel_group"
            SortExpression="Channel_group" UniqueName="Channel_group">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="Channel_epg"
            FilterControlAltText="Filter Channel_epg column" HeaderText="Channel_epg"
            SortExpression="Channel_epg" UniqueName="Channel_epg" Visible="false">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="Channel_type"
            FilterControlAltText="Filter Channel_type column" HeaderText="Channel_type"
            SortExpression="Channel_type" UniqueName="Channel_type" Visible="false">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="Channel_archive"
            FilterControlAltText="Filter Channel_archive column"
            HeaderText="Channel_archive" SortExpression="Channel_archive"
            UniqueName="Channel_archive" Visible="false">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="Channel_direct"
            FilterControlAltText="Filter Channel_direct column" HeaderText="Channel_direct"
            SortExpression="Channel_direct" UniqueName="Channel_direct" Visible="false">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="Channel_url"
            FilterControlAltText="Filter Channel_url column" HeaderText="Channel_url"
            SortExpression="Channel_url" UniqueName="Channel_url">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="Channel_block_url"
            FilterControlAltText="Filter Channel_block_url column"
            HeaderText="Channel_block_url" SortExpression="Channel_block_url"
            UniqueName="Channel_block_url" Visible="false">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="Channel_block_name"
            FilterControlAltText="Filter Channel_block_name column"
            HeaderText="Channel_block_name" SortExpression="Channel_block_name"
            UniqueName="Channel_block_name" Visible="false">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="Channel_block_timeshift"
            FilterControlAltText="Filter Channel_block_timeshift column"
            HeaderText="Channel_block_timeshift" SortExpression="Channel_block_timeshift"
            UniqueName="Channel_block_timeshift" Visible="false">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="Channel_auth"
            FilterControlAltText="Filter Channel_auth column" HeaderText="Channel_auth"
            SortExpression="Channel_auth" UniqueName="Channel_auth">
        </telerik:GridBoundColumn>
    </Columns>

<EditFormSettings>
<EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn>
</EditFormSettings>
</MasterTableView>

<FilterMenu EnableImageSprites="False"></FilterMenu>

<HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default"></HeaderContextMenu>
                            </telerik:RadGrid>


                            <telerik:OpenAccessDataSource ID="OpenAccessDataSource1" runat="server"
                                ObjectContextProvider="IMS_Telerik.EntitiesModel, IMS Telerik"
                                TypeName="IMS_Telerik.Channel" Where="" EnableDelete="true"
                                EnableUpdate="true">
                             <UpdateParameters>
                             <asp:Parameter Name="Channel_name" DbType="String" />
                             </UpdateParameters>
                            </telerik:OpenAccessDataSource>


                        </td>
                    </tr>
                </table>
            </td>
        </tr>
    </table>
</asp:Content>

Thanks for your help!

Regards Sander

[Pavel]

Hi Sander,

In order for automatic operations to work with RadGrid you need to enable AllowAutomaticInserts/Updates/Deletes properties. Check this help article for further details.

Best wishes,
Pavel
the Telerik team