asp.net - 为什么我的 SqlDataSource 的 UpdateCommand 不起作用？

Question

<asp:SqlDataSource ID="HopefulDataSource" runat="server" 
    ConnectionString="<%$ ConnectionStrings:MyConnectionString %>" 
    SelectCommand= "SELECT id, regGroupID, amountReceived, other FROM table" 
    UpdateCommand="UPDATE table
                        SET [amountReceived] = @amountReceived
                        WHERE [regGroupID] = @regGroupID">
    <SelectParameters>
        <asp:ControlParameter ControlID="ddlCourses" Name="ddlSelectedCourse" PropertyName="SelectedValue" Type="String" />
    </SelectParameters>

    <UpdateParameters>
        <asp:Parameter Name="regGroupID"        Type="Int32" />
        <asp:Parameter Name="amountReceived"    Type="Decimal" />

        other parameters

        <asp:Parameter Name="id"                Type="Int32" />
    </UpdateParameters>
</asp:SqlDataSource>

当我将“WHERE [regGroupID] = @regGroupID”更改为任一

WHERE [id] = @id

或者

哪里 [regGroupID] = 2

Answer 1

您需要将“regGroupID”添加到 DataKeyNames您收藏的 GridView宣言。像这样的东西:

<asp:GridView ID="yourGridViewId" DataKeyNames="regGroupID" ... >
    ...
</asp:GridView>

见 DataKeyNames documentation :

You must set the DataKeyNames property in order for the automatic update and delete features of the GridView control to work. The values of these key fields are passed to the data source control in order to specify the row to update or delete.

注意:我已经有一段时间没有使用它了，因此您可能需要同时包含主键和其他键字段。像这样:

DataKeyNames="id,regGroupID"