Server Error in '/' Application.

Invalid attempt to call Read when reader 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: Invalid attempt to call Read when reader is closed.

Source Error:


Line 278:
Line 279:        sqlComm.CommandText = "SELECT count(musicscorefileID) as musicscorefilesCount FROM musicscorefiles WHERE musicscoreid=" & MusicScoreID
Line 280:        musiccountpages = sqlComm.ExecuteScalar.ToString
Line 281:
Line 282:        Return musiccountpages

Source File: E:\AADATA\WEB\NT\App_Code\util.vb    Line: 280

Stack Trace:


[InvalidOperationException: Invalid attempt to call Read when reader is closed.]
   System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) +890
   System.Data.SqlClient.SqlCommand.CompleteExecuteScalar(SqlDataReader ds, Boolean returnSqlValue) +50
   System.Data.SqlClient.SqlCommand.ExecuteScalar() +208
   util.findMusicScoreFilesCount(String MusicScoreID) in E:\AADATA\WEB\NT\App_Code\util.vb:280
   ASP.playmaterial_aspx.__Renderform1(HtmlTextWriter __w, Control parameterContainer) in E:\AADATA\WEB\NT\playMaterial.aspx:801
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +115
   System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) +253
   System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) +87
   System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) +53
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +240
   System.Web.UI.Page.Render(HtmlTextWriter writer) +38
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4240


Version Information: Microsoft .NET Framework Version:2.0.50727.8974; ASP.NET Version:2.0.50727.8975