Server Error in '/' Application.

Incorrect syntax near the keyword 'and'.
Incorrect syntax near the keyword 'and'.

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 the keyword 'and'.
Incorrect syntax near the keyword 'and'.

Source Error:


Line 118:
Line 119:
Line 120:        DataSet ds = GroupsItems.GetAllDataPagging(p, rows.ToString(), condition, orderby);
Line 121:        if (ds.Tables.Count > 0)
Line 122:        {

Source File: e:\Domain website\condottileather.vn\cms\display\Product\SubControls\SubProductOtherItems.ascx.cs    Line: 120

Stack Trace:


[OleDbException (0x80040e14): Incorrect syntax near the keyword 'and'.
Incorrect syntax near the keyword 'and'.]
   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_OverDataset(OleDbCommand cmd) +544
   TatThanhJsc.Database.GroupsItems.GetAllDataPagging(String pageNumbers, String returnRows, String whereClause, String orderBy) +501
   cms_display_Product_SubControls_SubProductOtherItems.GetList() in e:\Domain website\condottileather.vn\cms\display\Product\SubControls\SubProductOtherItems.ascx.cs:120
   cms_display_Product_SubControls_SubProductOtherItems.Page_Load(Object sender, EventArgs e) in e:\Domain website\condottileather.vn\cms\display\Product\SubControls\SubProductOtherItems.ascx.cs:79
   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.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