Radgrid 编辑/更新不起作用

Question

我遇到了 Radgrid 的有线问题。我使用 Radgrid 来显示一些结果，用户可以在其中编辑/更新/删除它们。我正在使用单个 SQL Server 2000 表来获取结果...不知道为什么事件没有在 radgrid 中触发。但我能够使用 Gridview 控件成功完成此操作...

我使用 .NET Framework 4

Radgrid 代码

<telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="False" AutoGenerateDeleteColumn="True"
        AutoGenerateEditColumn="True" DataSourceID="SSDS" GridLines="None" Width="844px"
        DataMember="DefaultView">
        <MasterTableView DataSourceID="SSDS" DataKeyNames="id">
            <Columns>
                <telerik:GridBoundColumn DataField="id" HeaderText="id" ReadOnly="True" SortExpression="id"
                    UniqueName="id" Visible="false">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="name" HeaderText="name" SortExpression="name"
                    UniqueName="name">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="address" HeaderText="address" SortExpression="address"
                    UniqueName="address">
                </telerik:GridBoundColumn>
            </Columns>
        </MasterTableView>
    </telerik:RadGrid>
    <br />
    <br />
    <asp:SqlDataSource ID="SSDS" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionStringSQL %>"
        ProviderName="<%$ ConnectionStrings:ConnectionStringSQL.ProviderName %>" SelectCommand="SELECT [id], [name], [address] FROM [sitelinks]"
        UpdateCommand="UPDATE [sitelinks] set [name] = ? , [address] = ? where [id] = ?"
        DeleteCommand="delete from sitelinks where id = ?">
        <DeleteParameters>
            <asp:Parameter Name="id" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="name" />
            <asp:Parameter Name="address" />
            <asp:Parameter Name="id" />
        </UpdateParameters>
    </asp:SqlDataSource>

Gridview 控件代码（有效）

 <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SSDS"
    DataKeyNames="id">
    <Columns>
        <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
        <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" ReadOnly="True"
            SortExpression="id" Visible="false" />
        <asp:BoundField DataField="name" HeaderText="name" SortExpression="name" />
        <asp:BoundField DataField="address" HeaderText="address" SortExpression="address" />
    </Columns>
</asp:GridView>
<asp:SqlDataSource ID="SSDS" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionStringSQL %>"
    DeleteCommand="delete from sitelinks where id = ?" ProviderName="<%$ ConnectionStrings:ConnectionStringSQL.ProviderName %>"
    SelectCommand="select id,name,address from sitelinks" UpdateCommand="update sitelinks set name=?, address=? where id = ? ">
    <UpdateParameters>
        <asp:ControlParameter ControlID="GridView1" Name="name" />
        <asp:ControlParameter ControlID="GridView1" Name="address" />
        <asp:ControlParameter ControlID="GridView1" Name="id" />
    </UpdateParameters>
    <DeleteParameters>
        <asp:ControlParameter ControlID="GridView1" Name="id" />
    </DeleteParameters>
</asp:SqlDataSource>

谢谢

Answer 1

将 telerik 网格的 AllowAutomaticUpdates/AllowAutomaticDeletes 属性设置为 true 并查看 此示例。