V aplikaci / došlo k chybě serveru.

Incorrect syntax near '='.

Popis: Při provádění aktuálního webového požadavku došlo k neošetřené výjimce. Další informace o chybě a o jejím původu v kódu naleznete v trasování zásobníku.

Podrobnosti o výjimce: System.Data.SqlClient.SqlException: Incorrect syntax near '='.

Zdrojová chyba:


Řádek 60:                         using (SqlDataSource conn = new SqlDataSource(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString, "select a.nadpis, b.cestaobrazku from clanky a(NOLOCK) LEFT JOIN obrazky b(NOLOCK) ON a.idobrazek = b.id WHERE a.id =" + word))
Řádek 61:                         {
Řádek 62:                             DataView Rubriky = (DataView)conn.Select(DataSourceSelectArguments.Empty);
Řádek 63: 
Řádek 64:                             foreach (DataRow rubrika in Rubriky.Table.Rows)

Zdrojový soubor: c:\inetpub\wwwroot\Ryengle\WebControls\OdkazyClanekTable.ascx.cs    Řádek: 62

Trasování zásobníku:


[SqlException (0x80131904): Incorrect syntax near '='.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +3321756
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +736
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4454
   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +90
   System.Data.SqlClient.SqlDataReader.get_MetaData() +99
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) +604
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) +3303
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +667
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +83
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +301
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +201
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +178
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +119
   System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +2868
   System.Web.UI.WebControls.SqlDataSource.Select(DataSourceSelectArguments arguments) +28
   OdkazyClanekTable.SetDataView(SqlDataSource Connection, List`1 Parameters, Page Parent) in c:\inetpub\wwwroot\Ryengle\WebControls\OdkazyClanekTable.ascx.cs:62
   OdkazyClanekTable..ctor(SqlDataSource Connection, List`1 Parameters, Page Parent) in c:\inetpub\wwwroot\Ryengle\WebControls\OdkazyClanekTable.ascx.cs:21
   clanek.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\Ryengle\clanek.aspx.cs:217
   System.Web.UI.Control.OnLoad(EventArgs e) +106
   System.Web.UI.Control.LoadRecursive() +68
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3785


Informace o verzi: Microsoft .NET Framework verze:4.0.30319; verze ASP.NET:4.7.4081.0