Parameter count does not match Parameter Value count

  • Thread starter Thread starter Gabriel Lozano-Morán
  • Start date Start date
Your parameter array defines 2 parameters. But the string array you are
creating contains only one value.
I'm guessing that is it, not being familiar with SqlHelper.
 
Laszlo Csabi said:
Hi Folks,

Can someone explain me why I'm getting the following error?
Click to expand...

Try the following call to the overloaded FillDataset (notice the 2nd
parameter in the method):

SqlHelper.FillDataset(
conn,
CommandType.StoredProcedure,
"MySp",
ds,
new string[] { "TableName" },
new SqlParameter[] {
new SqlParameter("@Param1", Value),
new SqlParameter("@Param2", Value2)
}
);

Another test would be (Value and Value2 are actual values, not SqlParameter
objects):

SqlHelper.FillDataset(
conn,
"MySp",
ds,
new string[] { "TableName" },
new object[] { Value, Value2 }
);


The difference is you specify that it is a stored procedure you want to use
to fill the dataset with.

:)

Hope this helps!

Mythran
 
Hi,

It looks like your are passing two declared parameters into helper class,
but just one string value. In this case if you try to load parameters
inside of helper class, then you most likely get this error.
 
Hi Folks,

Can someone explain me why I'm getting the following error?



The error message I got is : "Parameter count does not match Parameter Value
count."



Here is the Stored Procedure:

ALTER PROCEDURE dbo.tblAccount_SELECT_BY_PROMOTIONAL

@FKCustomerID int,

@Assigned bit

AS

SELECT * FROM tblAccount WHERE Assigned = @Assigned AND IsPromotional=1 AND
PromotionalOwner = @FKCustomerID AND DELETED=0



Here is the Code where I call from:

try

{

ENTITY.dsAccount dsAccount = new
YNOTCALLME.COMMUNICATION.ENTITY.dsAccount();

SqlParameter [] arParams = new SqlParameter [2];

arParams[0] = new SqlParameter("@FKCustomerID",PKCustomerID);

arParams[1] = new SqlParameter("@Assigned",Assigned);

SqlHelper.FillDataset (DBConnection,
"tblAccount_SELECT_BY_PROMOTIONAL",dsAccount,new string[]
{"Account"},arParams);

return dsAccount;

}

catch (SqlException ex)

{

YNOTCALLME.FRAMEWORK.ERRORMANAGER.Error.Save (ex);

return null;

}



Thanks



laszlo
 
Val Mazur (MVP) said:
Hi,

It looks like your are passing two declared parameters into helper class,
but just one string value. In this case if you try to load parameters
inside of helper class, then you most likely get this error.
--
Val Mazur
Microsoft MVP

http://xport.mvps.org
Click to expand...

The string array he is passing is not the parameter values. The string
array contain the name(s) of the table(s) to fill with the results. The
last parameter passed in is the SqlParameter. I know only because I use the
SqlHelper object as well in my code :) Pretty handy little booger once you
get to know it :)

Mythran
 
Back
Top