Server Error in '/' Application.

There is already an open DataReader associated with this Command which must be closed first.

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.InvalidOperationException: There is already an open DataReader associated with this Command which must be closed first.

Source Error:


Line 135:        Dim reader As IDataReader = _provider.reader
Line 136:        Dim retVal As String = ""
Line 137:        reader = _provider.command("SELECT * FROM avcp_lotti_partecipanti_raggruppamento WHERE idavcp=" & idavcp & " AND idavcplotti=" & idavcplotti & " AND idavcplottipartecipanti=" & idavcplottipartecipanti, _cn).ExecuteReader
Line 138:        Do While (reader.Read())
Line 139:            retVal &= IIf(CStr(reader("codiceFiscale")).Length > 0, "<br>" & CStr(reader("codiceFiscale")), "<br>&nbsp;")

Source File: D:\home\ravennaholdingspa.it\trasparenza.ravennaholdingspa.it\appalto.aspx.vb    Line: 137

Stack Trace:


[InvalidOperationException: There is already an open DataReader associated with this Command which must be closed first.]
   System.Data.SqlClient.SqlInternalConnectionTds.ValidateConnectionForExecute(SqlCommand command) +1647630
   System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command) +91
   System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async) +274
   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) +119
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +65
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +170
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +43
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +14
   appalto.getListaPartecipantiRaggruppamentoCF(Int32 idavcp, Int32 idavcplotti, Int32 idavcplottipartecipanti) in D:\home\ravennaholdingspa.it\trasparenza.ravennaholdingspa.it\appalto.aspx.vb:137
   appalto.getListaPartecipanti(Int32 idavcp, Int32 idavcplotti) in D:\home\ravennaholdingspa.it\trasparenza.ravennaholdingspa.it\appalto.aspx.vb:119
   appalto.datiAppalto(DataRow drAvcp) in D:\home\ravennaholdingspa.it\trasparenza.ravennaholdingspa.it\appalto.aspx.vb:46
   appalto.Page_Load(Object sender, EventArgs e) in D:\home\ravennaholdingspa.it\trasparenza.ravennaholdingspa.it\appalto.aspx.vb:15
   System.EventHandler.Invoke(Object sender, EventArgs e) +0
   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.4700.0