Radgrid批量编辑“SP指定的参数太多”时出错 [英] Getting error when Radgrid Batch Editing "SP has too many argument specified"

问题描述

我是批处理编辑的新手，请帮我找到这个错误。当我在Radgrid批量编辑中执行插入时，它显示异常函数或过程SP_FIN_COA_ACCOUNT_INSERT指定了太多参数



SP



@CATALOG_ID INT，

@ACCOUNT_TYPE_ID INT，

@CODE INT，

@DESIGNATION_NATIVE nvarchar（150），

@DESIGNATION_OTHER nvarchar（150），

@PAYBLE INT，

@ACTIVE位，

@CREATED_USER_ID int，

@UPDATED_USER_ID int



ASPX文件

< telerik：RadGrid ID =   RadGrid1 GridLines =  无 runat =  服务器 AllowAutomaticDeletes =   True 
 AllowAutomaticInserts =   True PageSize =   10 >  
< MasterTableView CommandItemDisplay =   TopAndBottom DataKeyNames =   COA_ACCOUNT_ID 
 DataSourceID =   SqlDataSource1 Horizo​​ntalAlign =   NotSet EditMode =  批处理 AutoGenerateColumns =   False >  
< BatchEditingSettings EditType =  行 /> 
< SortExpressions> 
< telerik：GridSortExpression FieldName =   ACCOUNT_CODE SortOrder =  升序 /> 
 < /   SortExpressions  >  
< Columns> 
< telerik：GridBoundColumn DataField =   ACCOUNT_CODE HeaderStyle-Width =   210px HeaderText =   ACCOUNT CODE SortExpression =   ACCOUNT_CODE 
 UniqueName =   CODE >  
< ColumnValidationSettings EnableRequiredFieldValidation =   true >  
< RequiredFieldValidator ForeColor =   Red Text =   *此字段必填显示=  动态 >  
 < /   RequiredFieldValidator  >  
 < /   ColumnValidationSettings  >  
 < /   telerik：GridBoundColumn  >  
< telerik：GridBoundColumn DataField =   ACCOUNT_DESCRIPTION HeaderStyle-Width =   210px HeaderText =  帐户说明 SortExpression =   ACCOUNT_DESCRIPTION 
 UniqueName =   DESIGNATION_NATIVE >  
< ColumnValidationSettings EnableRequiredFieldValidation =   true >  
< RequiredFieldValidator ForeColor =   Red Text =   *此字段是必需的显示=  动态 >  
 < /   RequiredFieldValidator  >  
 < /   ColumnValidationSettings  >  
 < /   telerik：GridBoundColumn  >  
< telerik：GridTemplateColumn HeaderText =   ACCOUNT TYPE DefaultInsertValue = < span class =code-string>  R HeaderStyle-Width =  < span class =code-string> 150px UniqueName =   ACCOUNT_TYPE_ID DataField = < span class =code-string>  ACCOUNT_TYPE >  
 <&的ItemTemplate GT; 
<％#Eval（  ACCOUNT_TYPE）％>  
 < /   ItemTemplate  >  
< EditItemTemplate> 
< telerik：RadDropDownList runat =   server ID =   RadddlAcctType DataValueField =   COA_ACCOUNT_TYPE_ID 
 DataTextField =   ACCOUNT_TYPE_NAME DataSourceID =   SqlDataSource2 >  
 < /   telerik：RadDropDownList  >  
 < /   EditItemTemplate  >  
 < /   telerik：GridTemplateColumn   >  
< telerik：GridTemplateColumn HeaderText =   ACCOUNT PAYABLE DefaultInsertValue =   Dr./Cr。 HeaderStyle-Width =    150px UniqueName =   PAYBLE  DataField =   ACCOUNT_PAYABLE >  
< ItemTemplate> 
<％#Eval（  ACCOUNT_PAYABLE）％>  
 < /   ItemTemplate  >  
< EditItemTemplate> 
< telerik：RadDropDownList runat =   server ID =   RadddlAcctPayable >  
< Items> 
< telerik：DropDownListItem Text =  借方值=   0 /> 
< telerik：DropDownListItem Text =   Credit Value =   1 /> 
< telerik：DropDownListItem Text =   Dr./Cr。值=   2 Selected =   true /> 
 < /  商品 >  
 < /   telerik：RadDropDownList   >  
 < /   EditItemTemplate  >  
 < /   telerik：GridTemplateColumn  >  
< telerik：GridCheckBoxColumn DataField =   ACTIVE  HeaderStyle-Width =   80px HeaderText =  状态 SortExpression =   ACTIVE 
 UniqueName =   ACTIVE >  
 < /   telerik：GridCheckBoxColumn  >  
< telerik：GridButtonColumn ConfirmText =  删除此产品？ ConfirmDialogType =   RadWindow 
 ConfirmTitle =  删除 HeaderText =  删除标题Style-Width =   50px ButtonType =   ImageButton 
 CommandName =  删除 Text =  删除 UniqueName =    DeleteColumn >  
 < /   telerik：GridButtonColumn  >  
 < /  列 >  
 < /   MasterTableView  >  
< ClientSettings AllowKeyboardNavigation =   true  >  < /   ClientSettings  >  
 < /   telerik ：RadGrid  >  
 < /   div  >  
< asp：SqlDataSource ID =   SqlDataSource1 runat =   server ConnectionString =  <％$ ConnectionStrings：sacweb_db_devConnectionString ％> 
 SelectCommandType =   StoredProcedure SelectCommand =   SP_FIN_COA_ACCOUNT_READ DeleteCommandType =   StoredProcedure 
 DeleteCommand =   SP_FIN_COA_ACCOUNT_DELETE UpdateCommandType =   StoredProcedure UpdateCommand =   SP_FIN_COA_ACCOUNT_UPDATE 
 InsertCommandType =   StoredProcedure InsertCommand =   SP_FIN_COA_ACCOUNT_INSERT >  
 < DeleteParameters> 
< asp：参数名称=   ACCOUNT_ID类型=   Int32 /> 
 < /   DeleteParameters  >  
<％ - < SelectParameters> 
< asp：参数名称=   LANGUAGE Type =   Int32 /> 
 < /   SelectParameters  >   -  ％>  
< UpdateParameters> 
< asp：参数名称=   ACCOUNT_ID类型=   Int32 /> 
< asp：参数名称=   CATALOG_ID Type =   Int32 /> 
< asp：参数名称=   ACCOUNT_TYPE_ID Type =   Int32 /> 
< asp：参数名称=   CODE Type =   Int32 /> 
< asp：参数名称=   DESIGNATION_NATIVE Type =   String /> 
< asp：参数名称=   DESIGNATION_OTHER Type =   String /> 
< asp：参数名称=   PAYBLE Type =   Int32 /> 
< asp：参数名称=   ACTIVE Type =  布尔 /> 
< asp：参数名称=   UPDATED_USER_ID Type =   Int32 /> 
 < /   UpdateParameters  >  
< InsertParameters> 
< asp：参数名称=   CATALOG_ID Type =   Int32 DefaultValue =   1 /> 
< asp：参数名称=   ACCOUNT_TYPE_ID Type =   Int32 /> 
< asp：参数名称=   CODE Type =   Int32 /> 
< asp：参数名称=   DESIGNATION_NATIVE Type =   String /> 
< asp：参数名称=   DESIGNATION_OTHER Type =  字符串 DefaultValue =  的Pt /> 
< asp：参数名称=   PAYBLE Type =   Int32 /> 
< asp：参数名称=   ACTIVE Type =  布尔 /> 
< asp：参数名称=   CREATED_USER_ID Type =   Int32 DefaultValue =   1 /> 
< asp：参数名称=   UPDATED_USER_ID Type =   Int32 DefaultValue =   1 /> 
 < /   InsertParameters  >  
 < /   asp：SqlDataSource   >  

解决方案

ConnectionStrings：sacweb_db_devConnectionString％>
SelectCommandType = StoredProcedure SelectCommand = SP_FIN_COA_ACCOUNT_READ DeleteCommandType = StoredProcedure
DeleteCommand = SP_FIN_COA_ACCOUNT_DELETE UpdateCommandType = STOR edProcedure UpdateCommand = SP_FIN_COA_ACCOUNT_UPDATE
InsertCommandType = StoredProcedure InsertCommand = SP_FIN_COA_ACCOUNT_INSERT >
< DeleteParameters>
< asp：参数名称= ACCOUNT_ID类型= Int32 />
< / DeleteParameters >
<％ - < SelectParameters>
< asp：参数名称= LANGUAGE Type = Int32 />
< / SelectParameters > - ％>
< UpdateParameters>
< asp：参数名称= ACCOUNT_ID类型= Int32 />
< asp：参数名称= CATALOG_ID Type = Int32 />
< asp：参数名称= ACCOUNT_TYPE_ID Type = Int32 />
< asp：参数名称= CODE Type = Int32 />
< asp：参数名称= DESIGNATION_NATIVE Type = String />
< asp：参数名称= DESIGNATION_OTHER Type = String />
< asp：参数名称= PAYBLE Type = Int32 />
< asp：参数名称= ACTIVE Type = 布尔 />
< asp：参数名称= UPDATED_USER_ID Type = Int32 />
< / UpdateParameters >
< InsertParameters>
< asp：参数名称= CATALOG_ID Type = Int32 DefaultValue = 1 />
< asp：参数名称= ACCOUNT_TYPE_ID Type = Int32 />
< asp：参数名称= CODE Type = Int32 />
< asp：参数名称= DESIGNATION_NATIVE Type = String />
< asp：参数名称= DESIGNATION_OTHER Type = 字符串 DefaultValue = 的Pt />
< asp：参数名称= PAYBLE Type = Int32 />
< asp：参数名称= ACTIVE Type = 布尔 />
< asp：参数名称= CREATED_USER_ID Type = Int32 DefaultValue = 1 />
< asp：参数名称= UPDATED_USER_ID Type = Int32 DefaultValue = 1 />
< / InsertParameters >
< / asp：SqlDataSource >

I'm new with Batch editing please help me to find this error. when I performing Insert in Radgrid Batch Editing it shows exception "function or procedure SP_FIN_COA_ACCOUNT_INSERT has too many argument specified"

SP

@CATALOG_ID INT,
@ACCOUNT_TYPE_ID INT,
@CODE INT,
@DESIGNATION_NATIVE nvarchar(150),
@DESIGNATION_OTHER nvarchar(150),
@PAYBLE INT,
@ACTIVE bit,
@CREATED_USER_ID int,
@UPDATED_USER_ID int

ASPX File

<telerik:RadGrid ID="RadGrid1" GridLines="None"  runat="server" AllowAutomaticDeletes="True"
                            AllowAutomaticInserts="True" PageSize="10" >
                            <MasterTableView CommandItemDisplay="TopAndBottom" DataKeyNames="COA_ACCOUNT_ID"
                                DataSourceID="SqlDataSource1" HorizontalAlign="NotSet" EditMode="Batch" AutoGenerateColumns="False">
                                <BatchEditingSettings EditType="Row" />
                                <SortExpressions>
                                    <telerik:GridSortExpression FieldName="ACCOUNT_CODE" SortOrder="Ascending" />
                                </SortExpressions>
                                <Columns>
                                    <telerik:GridBoundColumn DataField="ACCOUNT_CODE" HeaderStyle-Width="210px" HeaderText="ACCOUNT CODE" SortExpression="ACCOUNT_CODE"
                                        UniqueName="CODE">
                                        <ColumnValidationSettings EnableRequiredFieldValidation="true">
                                            <RequiredFieldValidator ForeColor="Red" Text="*This field is required" Display="Dynamic">
                                            </RequiredFieldValidator>
                                        </ColumnValidationSettings>
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn DataField="ACCOUNT_DESCRIPTION" HeaderStyle-Width="210px" HeaderText="ACCOUNT DESCRIPTION" SortExpression="ACCOUNT_DESCRIPTION"
                                        UniqueName="DESIGNATION_NATIVE">
                                        <ColumnValidationSettings EnableRequiredFieldValidation="true">
                                            <RequiredFieldValidator ForeColor="Red" Text="*This field is required" Display="Dynamic">
                                            </RequiredFieldValidator>
                                        </ColumnValidationSettings>
                                    </telerik:GridBoundColumn>
                                    <telerik:GridTemplateColumn HeaderText="ACCOUNT TYPE" DefaultInsertValue="R" HeaderStyle-Width="150px" UniqueName="ACCOUNT_TYPE_ID" DataField="ACCOUNT_TYPE">
                                        <ItemTemplate>
                                            <%# Eval("ACCOUNT_TYPE") %>
                                        </ItemTemplate>
                                        <EditItemTemplate>
                                            <telerik:RadDropDownList  runat="server" ID="RadddlAcctType" DataValueField="COA_ACCOUNT_TYPE_ID"
                                                DataTextField="ACCOUNT_TYPE_NAME" DataSourceID="SqlDataSource2">
                                            </telerik:RadDropDownList>
                                        </EditItemTemplate>
                                    </telerik:GridTemplateColumn>
                                    <telerik:GridTemplateColumn HeaderText="ACCOUNT PAYABLE" DefaultInsertValue="Dr./Cr." HeaderStyle-Width="150px" UniqueName="PAYBLE" DataField="ACCOUNT_PAYABLE">
                                        <ItemTemplate>
                                            <%# Eval("ACCOUNT_PAYABLE") %>
                                        </ItemTemplate>
                                        <EditItemTemplate>
                                            <telerik:RadDropDownList  runat="server" ID="RadddlAcctPayable">
                                                <Items>
                                                    <telerik:DropDownListItem Text="Debit" Value="0" />
                                                    <telerik:DropDownListItem Text="Credit" Value="1" />
                                                    <telerik:DropDownListItem Text="Dr./Cr." Value="2" Selected="true" />
                                                </Items>
                                            </telerik:RadDropDownList>
                                        </EditItemTemplate>
                                    </telerik:GridTemplateColumn>
                                    <telerik:GridCheckBoxColumn DataField="ACTIVE" HeaderStyle-Width="80px" HeaderText="Status" SortExpression="ACTIVE"
                                        UniqueName="ACTIVE">
                                    </telerik:GridCheckBoxColumn>
                                    <telerik:GridButtonColumn ConfirmText="Delete this product?" ConfirmDialogType="RadWindow"
                                        ConfirmTitle="Delete" HeaderText="Delete" HeaderStyle-Width="50px" ButtonType="ImageButton"
                                        CommandName="Delete" Text="Delete" UniqueName="DeleteColumn">
                                    </telerik:GridButtonColumn>
                                </Columns>
                            </MasterTableView>
                            <ClientSettings AllowKeyboardNavigation="true"></ClientSettings>
                        </telerik:RadGrid>
                    </div>
                    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:sacweb_db_devConnectionString%>"
                        SelectCommandType="StoredProcedure" SelectCommand="SP_FIN_COA_ACCOUNT_READ" DeleteCommandType="StoredProcedure"
                        DeleteCommand="SP_FIN_COA_ACCOUNT_DELETE" UpdateCommandType="StoredProcedure" UpdateCommand="SP_FIN_COA_ACCOUNT_UPDATE"
                        InsertCommandType="StoredProcedure" InsertCommand="SP_FIN_COA_ACCOUNT_INSERT">
                        <DeleteParameters>
                            <asp:Parameter Name="ACCOUNT_ID" Type="Int32" />
                        </DeleteParameters>
                        <%--<SelectParameters>
                            <asp:Parameter Name="LANGUAGE" Type="Int32" />
                        </SelectParameters>--%>
                        <UpdateParameters>
                            <asp:Parameter Name="ACCOUNT_ID" Type="Int32" />
                            <asp:Parameter Name="CATALOG_ID" Type="Int32" />
                            <asp:Parameter Name="ACCOUNT_TYPE_ID" Type="Int32" />
                            <asp:Parameter Name="CODE" Type="Int32" />
                            <asp:Parameter Name="DESIGNATION_NATIVE" Type="String" />
                            <asp:Parameter Name="DESIGNATION_OTHER" Type="String" />
                            <asp:Parameter Name="PAYBLE" Type="Int32" />
                            <asp:Parameter Name="ACTIVE" Type="Boolean" />
                            <asp:Parameter Name="UPDATED_USER_ID" Type="Int32" />
                        </UpdateParameters>
                        <InsertParameters>
                            <asp:Parameter Name="CATALOG_ID" Type="Int32" DefaultValue="1"/>
                            <asp:Parameter Name="ACCOUNT_TYPE_ID" Type="Int32" />
                            <asp:Parameter Name="CODE" Type="Int32" />
                            <asp:Parameter Name="DESIGNATION_NATIVE" Type="String" />
                            <asp:Parameter Name="DESIGNATION_OTHER" Type="String" DefaultValue="Pt"/>
                            <asp:Parameter Name="PAYBLE" Type="Int32" />
                            <asp:Parameter Name="ACTIVE" Type="Boolean" />
                            <asp:Parameter Name="CREATED_USER_ID" Type="Int32" DefaultValue="1"/>
                            <asp:Parameter Name="UPDATED_USER_ID" Type="Int32" DefaultValue="1"/>
                        </InsertParameters>
                    </asp:SqlDataSource>

解决方案

ConnectionStrings:sacweb_db_devConnectionString%>" SelectCommandType="StoredProcedure" SelectCommand="SP_FIN_COA_ACCOUNT_READ" DeleteCommandType="StoredProcedure" DeleteCommand="SP_FIN_COA_ACCOUNT_DELETE" UpdateCommandType="StoredProcedure" UpdateCommand="SP_FIN_COA_ACCOUNT_UPDATE" InsertCommandType="StoredProcedure" InsertCommand="SP_FIN_COA_ACCOUNT_INSERT"> <DeleteParameters> <asp:Parameter Name="ACCOUNT_ID" Type="Int32" /> </DeleteParameters> <%--<SelectParameters> <asp:Parameter Name="LANGUAGE" Type="Int32" /> </SelectParameters>--%> <UpdateParameters> <asp:Parameter Name="ACCOUNT_ID" Type="Int32" /> <asp:Parameter Name="CATALOG_ID" Type="Int32" /> <asp:Parameter Name="ACCOUNT_TYPE_ID" Type="Int32" /> <asp:Parameter Name="CODE" Type="Int32" /> <asp:Parameter Name="DESIGNATION_NATIVE" Type="String" /> <asp:Parameter Name="DESIGNATION_OTHER" Type="String" /> <asp:Parameter Name="PAYBLE" Type="Int32" /> <asp:Parameter Name="ACTIVE" Type="Boolean" /> <asp:Parameter Name="UPDATED_USER_ID" Type="Int32" /> </UpdateParameters> <InsertParameters> <asp:Parameter Name="CATALOG_ID" Type="Int32" DefaultValue="1"/> <asp:Parameter Name="ACCOUNT_TYPE_ID" Type="Int32" /> <asp:Parameter Name="CODE" Type="Int32" /> <asp:Parameter Name="DESIGNATION_NATIVE" Type="String" /> <asp:Parameter Name="DESIGNATION_OTHER" Type="String" DefaultValue="Pt"/> <asp:Parameter Name="PAYBLE" Type="Int32" /> <asp:Parameter Name="ACTIVE" Type="Boolean" /> <asp:Parameter Name="CREATED_USER_ID" Type="Int32" DefaultValue="1"/> <asp:Parameter Name="UPDATED_USER_ID" Type="Int32" DefaultValue="1"/> </InsertParameters> </asp:SqlDataSource>

这篇关于Radgrid批量编辑“SP指定的参数太多”时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！