ExecuteScalar requires an open and available Connection. The connection's current state is closed.

 

ExecuteScalar requires an open and available Connection. The connection's current state is closed.

Server Error in '/' Application.

ExecuteScalar requires an open and available Connection. The connection's current state is closed.

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

Source Error: 


Line 57:             {
Line 58: 
Line 59:                 dtAds = objDb.ReturnDataTableStoredProc(new Hashtable(), "selectAds");
Line 60:             }
Line 61:             finally

Source File: c:\HostingSpaces\kishanInterview\interviewmaterial.com\wwwroot\SAP-Module\What-is-the-integration-between-PM-and-QM-in-SAP.aspx    Line: 59

Stack Trace: 


[InvalidOperationException: ExecuteScalar requires an open and available Connection. The connection's current state is closed.]
   System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async) +684
   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.ExecuteScalar() +250
   DAL.dbClass.LogErrorsInDB(String sMsg) in C:\KK\Work\InterviewMaterial\InterviewMaterialProject\interviewmaterial\DAL\dbClass.cs:139
   DAL.dbClass.ReturnDataTableStoredProc(Hashtable hs, String StorProcName) in C:\KK\Work\InterviewMaterial\InterviewMaterialProject\interviewmaterial\DAL\dbClass.cs:555
   ASP.sap_module_what_is_the_integration_between_pm_and_qm_in_sap_aspx.showAds() in c:\HostingSpaces\kishanInterview\interviewmaterial.com\wwwroot\SAP-Module\What-is-the-integration-between-PM-and-QM-in-SAP.aspx:59
   ASP.sap_module_what_is_the_integration_between_pm_and_qm_in_sap_aspx.Page_Load(Object sender, EventArgs e) in c:\HostingSpaces\kishanInterview\interviewmaterial.com\wwwroot\SAP-Module\What-is-the-integration-between-PM-and-QM-in-SAP.aspx:50
   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.4805.0