Server Error in '/' Application.

The stored procedure 'Product_SearchProduct' 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 'Product_SearchProduct' doesn't exist.

Source Error:


Line 37: 						     };
Line 38: 
Line 39:             return DALHelper.ExecuteDataset(strConnection, "Product_SearchProduct", ArrSqlParam);
Line 40: 		}
Line 41: 

Source File: \\hp3-winc3-smb2.hostingp3.local\domainsy\845\3904845\user\htdocs\App_Code\Product_.cs    Line: 39

Stack Trace:


[InvalidOperationException: The stored procedure 'Product_SearchProduct' doesn't exist.]
   System.Data.SqlClient.SqlCommand.DeriveParameters() +2558343
   System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) +122
   AppBlock.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter) +275
   AppBlock.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) +392
   AppBlock.SqlHelperParameterCache.GetSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter) +182
   AppBlock.SqlHelperParameterCache.GetSpParameterSet(SqlConnection connection, String spName) +49
   AppBlock.SqlHelper.ExecuteDataset(SqlConnection connection, String spName, Object[] parameterValues) +213
   DAL.DALHelper.ExecuteDataset(String connectionString, String spName, Object[] parameterValues) +129
   HCW.BAL.Product.SearchProductData(String strConnection, Nullable`1 productID, String productName, String categoryName, String pictureName, String prodDetail1, String prodDetail2, String prodDetail3, String prodDetail4, String prodDetail5, Nullable`1 addedOn, Nullable`1 addedBy, Nullable`1 delFlag, Nullable`1 pageIndex, Nullable`1 pageSize, String sortExpression) in \\hp3-winc3-smb2.hostingp3.local\domainsy\845\3904845\user\htdocs\App_Code\Product_.cs:39
   BeforeAndAfterCarBodyRepairHounslow.Page_Load(Object sender, EventArgs e) in \\hp3-winc3-smb2.hostingp3.local\domainsy\845\3904845\user\htdocs\BeforeAndAfterCarBodyRepairHounslow.aspx.cs:37
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +52
   System.Web.UI.Control.OnLoad(EventArgs e) +97
   System.Web.UI.Control.LoadRecursive() +61
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +693


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4700.0