i'm devloping a module which will have grid and data will be populated from database.i used stored proc
but it shows error. i'm very new to DNN. i checked my database and stored procedure is existing there.
Actually what happens is that i'm using VS2005, i dropped gridview and objdatasourse and configured for gridview. before that there was no error a simple module with other controls was working, but after configuring gridview to objdatasource error occours.
Error: spimodule is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Exception has been thrown by the target of an invocation. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: The stored procedure 'dbo.YourCompany_YourCompany_spimodule_GetAll' doesn't exist. at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at YourCompany.Modules.spimodule.SqlDataProvider.YourCompany_spimodule_GetAll(Int32 ModuleId) in C:\Inetpub\wwwroot\spi1\App_Code\spimodule\SqlDataProvider.vb:line 148 at YourCompany.Modules.spimodule.spimoduleController.spimodule_GetAll(Int32 ModuleId) in C:\Inetpub\wwwroot\spi1\App_Code\spimodule\spimoduleController.vb:line 59 --- End of inner exception stack trace --- at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object& instance) at System.Web.UI.WebControls.ObjectDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) at System.Web.UI.WebControls.DataBoundControl.PerformSelect() at System.Web.UI.WebControls.BaseDataBoundControl.DataBind() at System.Web.UI.WebControls.GridView.DataBind() at YourCompany.Modules.spimodule.Viewspimodule.Page_Load(Object sender, EventArgs e) in C:\Inetpub\wwwroot\spi1\DesktopModules\spimodule\Viewspimodule.ascx.vb:line 33 --- End of inner exception stack trace
i'm very new and not very clear abt DNN architecture, so unable to findout problem.
thanks in advance
|