Server Error in '/' Application.

Incorrect syntax near ')'.

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: Incorrect syntax near ')'.

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:


[SqlException (0x80131904): Incorrect syntax near ')'.]
   BusinessObject.BOItem.Search(Int32 BeginRow, Int32 EndRow, String SearchContent, Nullable`1 CategoryID, Nullable`1 BrandId, Nullable`1 Published, Nullable`1 HotItem, Nullable`1 IsNew, Nullable`1 IsBest, Nullable`1 IsSpecial, Nullable`1 OnSale, Nullable`1 LanguageShown, String OrderBy, String InCategory) in C:\Projects\VuNhatCamera\BusinessObject\BOItem.cs:278
   WebCore.webparts.Category.MainItemCategory.Page_Load(Object sender, EventArgs e) in C:\Projects\VuNhatCamera\WebCore\webparts\Category\MainItemCategory.ascx.cs:79
   System.Web.UI.Control.OnLoad(EventArgs e) +106
   System.Web.UI.Control.LoadRecursive() +68
   System.Web.UI.Control.LoadRecursive() +162
   System.Web.UI.Control.LoadRecursive() +162
   System.Web.UI.Control.LoadRecursive() +162
   System.Web.UI.Control.LoadRecursive() +162
   System.Web.UI.Control.LoadRecursive() +162
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3785


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