locked
The stored procedure 'sptblRegistry_Select' doesn't exist. RRS feed

  • Question

  • User-582781048 posted

    please help me find out how to fix this error:

    Server Error in '/' Application.


    The stored procedure 'sptblRegistry_Select' doesn't exist.

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

    Exception Details: System.InvalidOperationException: The stored procedure 'sptblRegistry_Select' doesn't exist.

    Source Error: 

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


    Stack Trace: 

    [InvalidOperationException: The stored procedure 'sptblRegistry_Select' doesn't exist.]
       System.Data.SqlClient.SqlCommand.DeriveParameters() +1963165
       System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) +121
       DataAccess.clsParameterCache.DiscoverSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) +111
       DataAccess.clsParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) +135
       DataAccess.clsDataAccess.ExecuteReader(String connectionString, String spName, Object[] parameterValues) +46
       DataAccess.clsRegistry.FillReader(String pWhere) +73
       Utilities.Registry.clsRegistry.GetValue(String strParent, String strKey) +82
       Data.clsRegistration.GetClassId() +64
       Data.clsRegistration.GetNextUserValidationDateTime() +36
       Data.clsRegistration.IsValidSite(String strHostName, String& strResault) +23
       SWAN._Default.Page_Load(Object sender, EventArgs e) +139
       System.Web.UI.Control.OnLoad(EventArgs e) +99
       System.Web.UI.Control.LoadRecursive() +50
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627
    



    Version Information: Microsoft .NET Framework Version:2.0.50727.3643; ASP.NET Version:2.0.50727.3634

    Thursday, July 11, 2013 12:23 AM

Answers

  • User-166373564 posted

    Hi,

    hamidialison

    The stored procedure 'sptblRegistry_Select' doesn't exist.

    First you should check whether your stored procedure is really existed, and then you should check whether you call your stored procedure properly,

    At the same time many methods are available for you to call stored procedures in asp.net, such as calling stored procedures in ADO.NET, etc.

    # Calling Stored procedures in ADO.NET

    # how to call stored procedure in asp.net

    hope it helps,

    Regards

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, July 17, 2013 9:47 PM
  • User-801004448 posted

    Use Management studio to check stored procedure

    Database > Programmability > Stored procedure

    Check if 'sptblRegistry_Select' exists. If it does not exist, recreate from database script.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, July 19, 2013 1:03 AM

All replies

  • User197322208 posted

    The stored procedure 'sptblRegistry_Select' doesn't exist.

    And it does exist?

    Thursday, July 11, 2013 3:35 AM
  • User-166373564 posted

    Hi,

    hamidialison

    The stored procedure 'sptblRegistry_Select' doesn't exist.

    First you should check whether your stored procedure is really existed, and then you should check whether you call your stored procedure properly,

    At the same time many methods are available for you to call stored procedures in asp.net, such as calling stored procedures in ADO.NET, etc.

    # Calling Stored procedures in ADO.NET

    # how to call stored procedure in asp.net

    hope it helps,

    Regards

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, July 17, 2013 9:47 PM
  • User-801004448 posted

    Use Management studio to check stored procedure

    Database > Programmability > Stored procedure

    Check if 'sptblRegistry_Select' exists. If it does not exist, recreate from database script.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, July 19, 2013 1:03 AM