Category: Windows

20 Jul 2016 21:26

Joined:	20/07/2016
Level:	Bronze
Points:	0

Points:	5

Procedure or function Insert has too many arguments specified

I try this code but not working properly (only first value add to database second value is not inserted) . Procedure or function Insert has too many arguments specified ,this is the displayed error

c#code

foreach (DataGridViewRow row in dgItems.Rows)
{
for (int i = 0; i < dgItems.Rows.Count; i++)
{
DataGridViewCellCollection c = dgItems.Rows[i].Cells;

//dtl.DOC_TYPE = type;
info1.DOC_NO = DOC_NO.Text;
info1.ITEM_CODE = c["cCode"].Value.ToString();
info1.ITEM_DESC_ENG = c["cName"].Value.ToString();
info1.UOM = c["cUnit"].Value.ToString();
info1.PRICE = Convert.ToDecimal(c["cPrice"].Value.ToString());
info1.QUANTITY = Convert.ToInt32(c["cQty"].Value.ToString());
info1.ITEM_DISCOUNT = Convert.ToDecimal(c["cDisc"].Value.ToString());
info1.DISC_TYPE = c["DiscTypes"].Value.ToString();
info1.DISC_VALUE = c["DiscValues"].Value.ToString();
info1.SERIALNO = c["SerialNos"].Value.ToString();
info1.BRANCH = lg.Branch;
dtl.Insertdtl_Meth(info1);
}

#767243

20 Jul 2016 23:53

Joined:	05/06/2009
Level:	Gold
Points:	10245

Points:	3

The error message "Procedure or function Insert has too many arguments specified ,this is the displayed error" clearly showing that there is some mismatch in procedure/function parameter count. The parameters you are sending to the procedure is not matching the procedure/function parameter.

1. First check the count of the parameters passing and compare with actual procedure parameters
2. Check you are passing correct type of Parameters.

By Nathan
Direction is important than speed

#767245

21 Jul 2016 00:19

Joined:	03/05/2013
Level:	Gold
Points:	15822

Points:	3

Hi,

To resolve this we need to see your SP parameter declaration too, as per error "Procedure or function Insert has too many arguments specified ,this is the displayed error" the parameters in procedure and code is miss match the count, so that the reason you got this error, request you to kindly recheck your parameters one more time and move further.

--------------------------------------------------------------------------------
Give respect to your work, Instead of trying to impress your boss.

N@veen
Blog : http://naveens-dotnet.blogspot.in/

#767250

21 Jul 2016 02:50

Joined:	13/06/2007
Level:	Gold
Points:	21327

Points:	3

The problem is probably in the Insertdtl_Meth method, Check the number of parameters your stored procedure Sp_Sale_Dtl_Insert requires and number of parameters being passed to it.
Chances are in the first iteration hasTax and hasBatch both are false or at least one is false and the number of parameters being passed matches what is required by the stored procedure.

Thanks
Koolprasd2003
Editor, DotNetSpider MVM
Microsoft MVP 2014 [ASP.NET/IIS]

#767304

26 Jul 2016 00:37

Joined:	12/02/2013
Level:	Gold
Points:	3098

Points:	3

Hi Shafeeq.

Its clearly showing there is mismatch in the parameters which are sent to the procedure.
Kindly find out the last added parameters in the procedure and while at the time of declaration assign null to those parameters in the procedure, by doing this even if you wont send that parameters it will assign null to that column.
You are sending 11 parameters that means receiving also should be 11.

Sridhar Thota.
Editor: DNS Forum.

Procedure or function Insert has too many arguments specified

Email subscription

About dotnetspider.com

Quick Links

General

Services