Server Error in '/' Application.

Data is Null. This method or property cannot be called on Null values.

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.Data.SqlTypes.SqlNullValueException: Data is Null. This method or property cannot be called on Null values.

Source Error: 


Line 52: 		reader = MyCommand.ExecuteReader()
Line 53: 		If reader.Read() Then
Line 54: 			sumPrice += (reader.GetDecimal(0) * CInt(newQty(i)))
Line 55: 		End If
Line 56: 		reader.Close()

Source File: C:\Inetpub\downeaster\wwwroot\includes\bug.ascx    Line: 54

Stack Trace: 


[SqlNullValueException: Data is Null. This method or property cannot be called on Null values.]
   System.Data.SqlTypes.SqlMoney.get_Value() +43
   System.Data.SqlClient.SqlDataReader.GetDecimal(Int32 i) +103
   ASP.Bug.GetSumPrice(ArrayList newCode, ArrayList newQty) in C:\Inetpub\downeaster\wwwroot\includes\bug.ascx:54
   ASP.Bug.set_productString(String Value) in C:\Inetpub\downeaster\wwwroot\includes\bug.ascx:34
   ASP.holidayguide_aspx.__BuildControlbug21() in C:\Inetpub\downeaster\wwwroot\specialcontent\holidayguide.aspx:226
   ASP.holidayguide_aspx.__BuildControl__control27() in C:\Inetpub\downeaster\wwwroot\specialcontent\holidayguide.aspx:222
   ASP.holidayguide_aspx.__BuildControl__control26(HtmlTableCellCollection __ctrl) in C:\Inetpub\downeaster\wwwroot\specialcontent\holidayguide.aspx:221
   ASP.holidayguide_aspx.__BuildControl__control25() in C:\Inetpub\downeaster\wwwroot\specialcontent\holidayguide.aspx:221
   ASP.holidayguide_aspx.__BuildControl__control21(HtmlTableRowCollection __ctrl) in C:\Inetpub\downeaster\wwwroot\specialcontent\holidayguide.aspx:216
   ASP.holidayguide_aspx.__BuildControldisplay1() in C:\Inetpub\downeaster\wwwroot\specialcontent\holidayguide.aspx:216
   ASP.holidayguide_aspx.__BuildControl__control2() in C:\Inetpub\downeaster\wwwroot\specialcontent\holidayguide.aspx:141
   ASP.holidayguide_aspx.__BuildControlTree(Control __ctrl) in C:\Inetpub\downeaster\wwwroot\specialcontent\holidayguide.aspx:1
   ASP.holidayguide_aspx.FrameworkInitialize()
   System.Web.UI.Page.ProcessRequest() +85
   System.Web.UI.Page.ProcessRequest(HttpContext context) +18
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() +179
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +87

Version Information: Microsoft .NET Framework Version:1.1.4322.2407; ASP.NET Version:1.1.4322.2407