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 282:                .Add(New SqlParameter("@StateCode", SqlDbType.Int)).Value = CInt("0" & MainRs("StateCode"))
Line 283:            End With
Line 284:            Rs = ConCommand.ExecuteReader
Line 285:
Line 286:            If Rs.HasRows Then

Source File: D:\InetPub\beta.everycontractor.com\Ec_Home\ContractorDirectory\Profiles\PCL\WebProfile\ProjectReferences.aspx.vb    Line: 284

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) +4890072
   System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command) +23
   System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async) +144
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +87
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
   System.Data.SqlClient.SqlCommand.ExecuteReader() +89
   EC_home_ContractorDirectory_Profiles_PCL_WebProfile_ProjectReferences.ShowDefaultServiceArea() in D:\InetPub\beta.everycontractor.com\Ec_Home\ContractorDirectory\Profiles\PCL\WebProfile\ProjectReferences.aspx.vb:284
   EC_home_ContractorDirectory_Profiles_PCL_WebProfile_ProjectReferences.Page_Load(Object sender, EventArgs e) in D:\InetPub\beta.everycontractor.com\Ec_Home\ContractorDirectory\Profiles\PCL\WebProfile\ProjectReferences.aspx.vb:36
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627


Version Information: Microsoft .NET Framework Version:2.0.50727.8806; ASP.NET Version:2.0.50727.8762