Server Error in '/' Application.

Procedure or function 'shop_GetProductsByCategoryId_Count' expects parameter '@CategoryID', which was not supplied.

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.Data.SqlClient.SqlException: Procedure or function 'shop_GetProductsByCategoryId_Count' expects parameter '@CategoryID', which was not supplied.



Source Error:



Line 167:        Dim myCommand As SqlCommand = New SqlCommand(sQuery, myConnection)

Line 168:        myConnection.Open()

Line 169:        Dim dr As SqlDataReader = myCommand.ExecuteReader

Line 170:        dr.Read()

Line 171:        GetCategoryCount = dr.GetValue(0)





Source File: E:\shop.buyitsellit.com\Default.aspx.vb    Line: 169



Stack Trace:



[SqlException (0x80131904): Procedure or function 'shop_GetProductsByCategoryId_Count' expects parameter '@CategoryID', which was not supplied.]

   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +925466

   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800118

   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186

   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932

   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +31

   System.Data.SqlClient.SqlDataReader.get_MetaData() +62

   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297

   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1005

   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132

   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32

   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +122

   System.Data.SqlClient.SqlCommand.ExecuteReader() +84

   newshop_Default.GetCategoryCount() in E:\shop.buyitsellit.com\Default.aspx.vb:169

   newshop_Default.SqlDataSource1_Selecting(Object sender, SqlDataSourceSelectingEventArgs e) in E:\shop.buyitsellit.com\Default.aspx.vb:24

   System.Web.UI.WebControls.SqlDataSourceView.OnSelecting(SqlDataSourceSelectingEventArgs e) +114

   System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +857

   System.Web.UI.WebControls.Repeater.GetData() +50

   System.Web.UI.WebControls.Repeater.CreateControlHierarchy(Boolean useDataSource) +232

   System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e) +53

   System.Web.UI.WebControls.Repeater.DataBind() +72

   newshop_Default.NextPageLink_Click(Object sender, EventArgs e) in E:\shop.buyitsellit.com\Default.aspx.vb:144

   System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e) +90

   System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +76

   System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7

   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11

   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +177

   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746





Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433