Click here to Skip to main content
15,887,975 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
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
C#
<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>
Posted
Comments
ZurdoDev 19-May-15 13:38pm    
The error says that you are passing too many parameters to the stored procedure SP_FIN_COA_ACCOUNT_INSERT. Look at it in the db and make sure you get rid of any parameters that it does not have.
Dipak Mondal 20-May-15 7:20am    
Look at the SP parameter that I have placed top of my question, there are 9 parameter and I pass the 9 Insert Parameter but why this error come.
ZurdoDev 20-May-15 7:38am    
The error can only happen by what it says. Too many arguments are specified. You'll have to track it down since we can't see your computer. Do a Sql trace using Sql profiler and you'll see what is happening.
Dipak Mondal 20-May-15 9:02am    
You look my Aspx code Is there any problem with that.
ZurdoDev 20-May-15 9:10am    
Not that I can tell but that isn't the whole picture. You need to run a sql trace.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900