Errore server nell'applicazione '/'.

Dichiarare la variabile scalare "@mpath".

Descrizione: Eccezione non gestita durante l'esecuzione della richiesta Web corrente. Per ulteriori informazioni sull'errore e sul suo punto di origine nel codice, vedere la traccia dello stack.

Dettagli eccezione: System.Data.SqlClient.SqlException: Dichiarare la variabile scalare "@mpath".

Errore nel codice sorgente:


Riga 213:        '**********************
Riga 214:        SqlArticolo.SelectParameters.Remove(SqlArticolo.SelectParameters("mpath"))
Riga 215:        SqlFiltroMarchi.SelectParameters.Remove(SqlFiltroMarchi.SelectParameters("mpath"))
Riga 216:        SqlArticolo.SelectParameters.Remove(SqlArticolo.SelectParameters("ricerca"))
Riga 217:

File di origine: C:\Inetpub\vhosts\marioadario.it\httpdocs\MasterPageArticoli.master.vb    Riga: 215

Traccia dello stack:


[SqlException (0x80131904): Dichiarare la variabile scalare "@mpath".]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +3335088
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +334
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4679
   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +89
   System.Data.SqlClient.SqlDataReader.get_MetaData() +101
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) +624
   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) +3392
   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) +725
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +84
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +312
   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, String srcTable) +123
   System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +2947
   System.Web.UI.WebControls.ListControl.OnDataBinding(EventArgs e) +389
   System.Web.UI.WebControls.ListControl.PerformSelect() +44
   System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +134
   System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewChanged(Object sender, EventArgs e) +25
   System.Web.UI.DataSourceView.OnDataSourceViewChanged(EventArgs e) +126
   System.Web.UI.WebControls.ParameterCollection.OnParametersChanged(EventArgs e) +47
   System.Web.UI.StateManagedCollection.System.Collections.IList.RemoveAt(Int32 index) +191
   MasterPageNews.CaricaSql(String MpathCategoria, String Genere, String Tipo, String Marchio) in C:\Inetpub\vhosts\marioadario.it\httpdocs\MasterPageArticoli.master.vb:215
   MasterPageNews.LstArticolo_PagePropertiesChanged(Object sender, EventArgs e) in C:\Inetpub\vhosts\marioadario.it\httpdocs\MasterPageArticoli.master.vb:156
   System.Web.UI.WebControls.ListView.OnPagePropertiesChanged(EventArgs e) +139
   System.Web.UI.WebControls.ListView.SetPageProperties(Int32 startRowIndex, Int32 maximumRows, Boolean databind) +159
   System.Web.UI.WebControls.ListView.System.Web.UI.WebControls.IPageableItemContainer.SetPageProperties(Int32 startRowIndex, Int32 maximumRows, Boolean databind) +22
   System.Web.UI.WebControls.DataPager.OnTotalRowCountAvailable(Object sender, PageEventArgs e) +90
   System.Web.UI.WebControls.ListView.OnTotalRowCountAvailable(PageEventArgs e) +139
   System.Web.UI.WebControls.ListView.CreateChildControls(IEnumerable dataSource, Boolean dataBinding) +1088
   System.Web.UI.WebControls.ListView.PerformDataBinding(IEnumerable data) +53
   System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data) +208
   System.Web.UI.WebControls.ListView.PerformSelect() +128
   System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +134
   System.Web.UI.WebControls.ListView.CreateChildControls() +80
   System.Web.UI.Control.EnsureChildControls() +107
   System.Web.UI.Control.PreRenderRecursiveInternal() +58
   System.Web.UI.Control.PreRenderRecursiveInternal() +227
   System.Web.UI.Control.PreRenderRecursiveInternal() +227
   System.Web.UI.Control.PreRenderRecursiveInternal() +227
   System.Web.UI.Control.PreRenderRecursiveInternal() +227
   System.Web.UI.Control.PreRenderRecursiveInternal() +227
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3671


Informazioni di versione: Versione di Microsoft .NET Framework:4.0.30319; Versione di ASP.NET:4.8.4682.0