Last post Oct 18, 2005 09:23 PM by mcsenow
Oct 17, 2005 02:31 AM|jward1976|LINK
Oct 18, 2005 09:23 PM|mcsenow|LINK
When coverting standalone asp.net apps to DNN module, I used to get the same error "Parameter count does not match Parameter Value count". Often time the module would work fine on the development machine but when deploying
to staging or production, the error would crop up. This drove me nut.
This seemed to happen when the standardlone asp.net application uses the sub AsiignParameterValues sub in the SQLHelper..vb to automatically extract store procedure parameters and match them with the collection of parameter values. It is very difficult to
troubleshoot. I ended up converting all the sql related .NET code to DNN standard (Controller -> DataProvider -> SQLDataProvider). It was tedious but once the conversion was done, the error never went away for good.