Server Error in '/' Application.

ExecuteReader requires an open and available Connection. The connection's current state is connecting.

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: ExecuteReader requires an open and available Connection. The connection's current state is connecting.

Source Error:


Line 58:         SqlCmd.Connection = SqlCon;
Line 59:         Da = new SqlDataAdapter(SqlCmd);
Line 60:         Da.Fill(DT);
Line 61:         return DT;
Line 62:     }

Source File: c:\inetpub\vhosts\packersmoversbangalore.in\httpdocs\App_Code\DataManager.cs    Line: 60

Stack Trace:


[InvalidOperationException: ExecuteReader requires an open and available Connection. The connection's current state is connecting.]
   System.Data.SqlClient.SqlConnection.GetOpenConnection(String method) +3334356
   System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command) +100
   System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async) +314
   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) +156
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +84
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +207
   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(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +465
   System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +147
   DataManager.GetDataTable(String StrQry) in c:\inetpub\vhosts\packersmoversbangalore.in\httpdocs\App_Code\DataManager.cs:60
   profile.comdetails() in c:\inetpub\vhosts\packersmoversbangalore.in\httpdocs\profile.aspx.cs:56
   profile.Page_Load(Object sender, EventArgs e) in c:\inetpub\vhosts\packersmoversbangalore.in\httpdocs\profile.aspx.cs:21
   System.Web.UI.Control.OnLoad(EventArgs e) +108
   System.Web.UI.Control.LoadRecursive() +90
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1533


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4494.0