Parameter counter does not match. Parameter Counter

Question

We get a server error message: "The number of parameters does not match the parameter value." Can anyone understand what this could mean?

Our site on ASP.NET websites, working with DotNetNuke as a CMS.

I tried to download an older version of the web.config file, but it does not seem to have changed since the error. This was not in any of our last module downloads, because I reloaded the old files in the morning, which we changed.

Can any changes in the database cause this or result from an error in the code?

Thank.

Answer 1

SQL- , .

- :

command.CommandText = "EXEC test @a";
command.Parameters.Add("@a", "a");
command.Parameters.Add("@b", "b");

. . ? ?

Answer 2

, , , .

, , Microsoft Enterprise Library, .

, , , "" .

ADO.NET cmd.Parameters.AddWithValues("@parameterName", value)

. "" .

Answer 3

I had the same problem, and I found that it was picking fields from a temporary cache that was supported by MySQLHelper.