过程或功能'；spDelRegistration'；期望参数'@RegistrationId'；

本文关键字：参数 #39@RegistrationId 期望 spDelRegistration 过程 功能 | 更新日期: 2023-09-27 18:22:37

如何引用GridView id并将其设置为等于我的参数id？

我正在进行删除，当我点击删除时，我会收到以下错误：

过程或函数"spDelRegistratint"需要参数"@RegistrationId"，但未提供。

  <asp:GridView ID="GridView1" runat="server" AllowPaging="True" 
            AllowSorting="True" AutoGenerateColumns="False" DataSourceID="SqlDataSource1">
            <Columns>
                <asp:CommandField ShowDeleteButton="True" />
                <asp:BoundField DataField="RegistrantId" HeaderText="RegistrantId" 
                    InsertVisible="False" ReadOnly="True" SortExpression="RegistrantId" />
                <asp:BoundField DataField="EventId" HeaderText="EventId" 
                    SortExpression="EventId" />
                <asp:BoundField DataField="FormId" HeaderText="FormId" 
                    SortExpression="FormId" />
                <asp:BoundField DataField="RequesterId" HeaderText="RequesterId" 
                    SortExpression="RequesterId" />
                <asp:BoundField DataField="PaymentId" HeaderText="PaymentId" 
                    SortExpression="PaymentId" />
                <asp:BoundField DataField="CustomFieldId" HeaderText="CustomFieldId" 
                    SortExpression="CustomFieldId" />
                <asp:BoundField DataField="DistrictId" HeaderText="DistrictId" 
                    SortExpression="DistrictId" />
                <asp:BoundField DataField="LocalNumberId" HeaderText="LocalNumberId" 
                    SortExpression="LocalNumberId" />
                <asp:BoundField DataField="TitleId" HeaderText="TitleId" 
                    SortExpression="TitleId" />
                <asp:BoundField DataField="IndustryId" HeaderText="IndustryId" 
                    SortExpression="IndustryId" />
                <asp:BoundField DataField="DateCreated" HeaderText="DateCreated" 
                    SortExpression="DateCreated" />
                <asp:BoundField DataField="DateLastModified" HeaderText="DateLastModified" 
                    SortExpression="DateLastModified" />
                <asp:BoundField DataField="CreatedBy" HeaderText="CreatedBy" 
                    SortExpression="CreatedBy" />
                <asp:BoundField DataField="ModifiedBy" HeaderText="ModifiedBy" 
                    SortExpression="ModifiedBy" />
                <asp:CheckBoxField DataField="Status" HeaderText="Status" 
                    SortExpression="Status" />
                <asp:BoundField DataField="FirstName" HeaderText="FirstName" 
                    SortExpression="FirstName" />
                <asp:BoundField DataField="LastName" HeaderText="LastName" 
                    SortExpression="LastName" />
                <asp:BoundField DataField="AddressLine1" HeaderText="AddressLine1" 
                    SortExpression="AddressLine1" />
                <asp:BoundField DataField="AddressLine2" HeaderText="AddressLine2" 
                    SortExpression="AddressLine2" />
                <asp:BoundField DataField="City" HeaderText="City" SortExpression="City" />
                <asp:BoundField DataField="State" HeaderText="State" SortExpression="State" />
                <asp:BoundField DataField="Zip" HeaderText="Zip" SortExpression="Zip" />
                <asp:BoundField DataField="Country" HeaderText="Country" 
                    SortExpression="Country" />
                <asp:BoundField DataField="Phone" HeaderText="Phone" SortExpression="Phone" />
                <asp:BoundField DataField="PhoneExt" HeaderText="PhoneExt" 
                    SortExpression="PhoneExt" />
                <asp:BoundField DataField="Email" HeaderText="Email" SortExpression="Email" />
                <asp:BoundField DataField="Employer" HeaderText="Employer" 
                    SortExpression="Employer" />
                <asp:BoundField DataField="MemberId" HeaderText="MemberId" 
                    SortExpression="MemberId" />
                <asp:BoundField DataField="Comments" HeaderText="Comments" 
                    SortExpression="Comments" />
                <asp:BoundField DataField="LocalUnionEmail" HeaderText="LocalUnionEmail" 
                    SortExpression="LocalUnionEmail" />
                <asp:BoundField DataField="CompletedByFirstName" 
                    HeaderText="CompletedByFirstName" SortExpression="CompletedByFirstName" />
                <asp:BoundField DataField="CompletedByLastName" 
                    HeaderText="CompletedByLastName" SortExpression="CompletedByLastName" />
                <asp:BoundField DataField="CompletedByPhone" HeaderText="CompletedByPhone" 
                    SortExpression="CompletedByPhone" />
                <asp:BoundField DataField="Position" HeaderText="Position" 
                    SortExpression="Position" />
                <asp:BoundField DataField="ShirtSize" HeaderText="ShirtSize" 
                    SortExpression="ShirtSize" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:Events2 %>" 
            DeleteCommand="spDelRegistrant" DeleteCommandType="StoredProcedure" 
            SelectCommand="spGetAllRegistrants" SelectCommandType="StoredProcedure">
        </asp:SqlDataSource>

过程或功能'；spDelRegistration'；期望参数'@RegistrationId'；

错误消息不言自明，存储过程spDelRegistrant需要一个代码未提供的参数@RegistrantId。因此，在您的SQL数据源控件中包括如下的delete参数：-

<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:Events2 %>" 
            DeleteCommand="spDelRegistrant" DeleteCommandType="StoredProcedure" 
            SelectCommand="spGetAllRegistrants" SelectCommandType="StoredProcedure">
   <DeleteParameters>
       <asp:Parameter Name="RegistrantId" Type="Int32" />
   </DeleteParameters>
</asp:SqlDataSource>

接下来，您必须在网格视图中设置DataKeyNames属性，以指定应该使用的RegistrationId：-

<asp:GridView ID="GridView1" runat="server" AllowPaging="True" DataKeyNames="RegistrantId"
相关文章：