Error Message

Parameter count does not match parameter value count

Cause and Solution


This error will occur when you make any changes in the stored procedure i.e. like adding new parameter to the procedure .The reason is in the SQL catalog the old sp will be there , even if you drop the Sp it will show the same error , the solution is


1. First drop the sp
2. Then if its is web application reset the application
3. Then open the application now it will show the sp not found error now you run the Sp this problem will be solved