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

Source Error:


Line 68:             );
Line 69:         string orderby = "";
Line 70:         DataTable dt = GroupsItems.GetAllData(top, "*", condition, orderby);
Line 71: 
Line 72:         string str = "";

Source File: g:\pleskvhosts\57.webbaomat.vn\eravina.tatthanh.net\cms\display\Tour\Controls\TourDetail.ascx.cs    Line: 70

Stack Trace:


[OleDbException (0x80040e14): Incorrect syntax near ')'.]
   System.Data.OleDb.OleDbDataReader.ProcessResults(OleDbHResult hr) +1601224
   System.Data.OleDb.OleDbDataReader.NextResult() +456
   System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +319
   System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +143
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +214
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +180
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +126
   TatThanhJsc.Database.SQLDatabase.GetData(OleDbCommand cmd) +603
   TatThanhJsc.Database.GroupsItems.GetAllData(String top, String fields, String condition, String orderby) +616
   cms_display_Tour_Controls_TourDetail.loadOther() in g:\pleskvhosts\57.webbaomat.vn\eravina.tatthanh.net\cms\display\Tour\Controls\TourDetail.ascx.cs:70
   cms_display_Tour_Controls_TourDetail.Page_Load(Object sender, EventArgs e) in g:\pleskvhosts\57.webbaomat.vn\eravina.tatthanh.net\cms\display\Tour\Controls\TourDetail.ascx.cs:37
   System.Web.UI.Control.OnLoad(EventArgs e) +108
   System.Web.UI.Control.LoadRecursive() +90
   System.Web.UI.Control.LoadRecursive() +185
   System.Web.UI.Control.LoadRecursive() +185
   System.Web.UI.Control.LoadRecursive() +185
   System.Web.UI.Control.LoadRecursive() +185
   System.Web.UI.Control.LoadRecursive() +185
   System.Web.UI.Control.LoadRecursive() +185
   System.Web.UI.Control.LoadRecursive() +185
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1533


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