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.

 

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 66:         try
Line 67:         {
Line 68:             dtAds = objDb.ReturnDataTableStoredProc(new Hashtable(), "selectAds");
Line 69:         }
Line 70:         finally

Source File: c:\hostingspaces\kishanInterview\interviewmaterial.com\wwwroot\InnerMasterQuestion.master.cs    Line: 68

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) +2540609
   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.ExecuteScalar() +189
   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:554
   InnerMasterQuestion.showAds() in c:\hostingspaces\kishanInterview\interviewmaterial.com\wwwroot\InnerMasterQuestion.master.cs:68
   InnerMasterQuestion.Page_Load(Object sender, EventArgs e) in c:\hostingspaces\kishanInterview\interviewmaterial.com\wwwroot\InnerMasterQuestion.master.cs:48
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +52
   System.Web.UI.Control.OnLoad(EventArgs e) +97
   System.Web.UI.Control.LoadRecursive() +61
   System.Web.UI.Control.LoadRecursive() +134
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +693

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