I had my module working fine. It stored its settings in the TabModuleSettings table. I decided I'd rather store it in my module table for various reasons. So I got rid of my settings control and went with an edit control instead. The module was created using the StarterKit, and so I just modified all of the lines for data access. Here is my override for the "AddModule" method:
public override void AddOpenBook(int ModuleId, int PropID, string Policy, int UserID)
{
SqlHelper.ExecuteNonQuery(ConnectionString, GetFullyQualifiedName("AddOpenBook"), ModuleId, PropID, Policy, UserID);
}
This is also the line that is giving me the following error:
DotNetNuke.Services.Exceptions.ModuleLoadException: Parameter count does not match Parameter Value count. ---> System.ArgumentException: Parameter count does not match Parameter Value count. at Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues(SqlParameter[] commandParameters, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at Yellowstone.Modules.OpenBook.SqlDataProvider.AddOpenBook(Int32 ModuleId, Int32 PropID, String Policy, Int32 UserID) in c:\InetDNN408\App_Code\OpenBook\SqlDataProvider.cs:line 163 at Yellowstone.Modules.OpenBook.OpenBookController.AddOpenBook(OpenBookInfo objOpenBook) in c:\InetDNN408\App_Code\OpenBook\OpenBookController.cs:line 71 at Yellowstone.Modules.OpenBook.ViewOpenBook.Page_Load(Object sender, EventArgs e) in c:\InetDNN408\DesktopModules\OpenBook\ViewOpenBook.ascx.cs:line 135 --- End of inner exception stack trace
I'm not sure what to do. I uninstalled and reinstalled the module, deleted all of the stored procedures and the table and reinitialized it from my SqlDataProvider script. I still get this. If I remove the item (Policy) that I added things work ok again. Obiouvsly something is pissed about the number of argument I'm passing in, but I don't know what or where. Any help would be appreciated.