Server Error in '/' Application.

Syntax error (missing operator) in query expression 'idcliente= and stato<>'InConsegna''.

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: Syntax error (missing operator) in query expression 'idcliente= and stato<>'InConsegna''.

Source Error:


Line 23:         dtAdapter.SelectCommand = objCmd
Line 24: 
Line 25:         dtAdapter.Fill(ds)
Line 26:         dt = ds.Tables(0)
Line 27: 

Source File: D:\inetpub\webs\silverflameit\Ordini.aspx.vb    Line: 25

Stack Trace:


[OleDbException (0x80040e14): Syntax error (missing operator) in query expression 'idcliente= and stato<>'InConsegna''.]
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) +1217017
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +256
   System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +216
   System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +60
   System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +164
   System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +115
   System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +10
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +140
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +138
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +89
   Ordini.CreateDsToDt(String strSQL) in D:\inetpub\webs\silverflameit\Ordini.aspx.vb:25
   Ordini.ordini() in D:\inetpub\webs\silverflameit\Ordini.aspx.vb:39
   Ordini.Page_Load(Object sender, EventArgs e) in D:\inetpub\webs\silverflameit\Ordini.aspx.vb:128
   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.4690.0