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 54:                 if (!objReader.IsDBNull(8)) objX.WriteElementString("category", objReader.GetString(8));
Line 55:                 objX.WriteElementString("pubDate", objReader.GetDateTime(3).ToString("F"));
Line 56:                 objX.WriteElementString("comments", "http://www.barrettmanor.com/julie/xyzzy.aspx?ID=" + objReader.GetInt32(2).ToString() + "("+ objReader.GetInt32(10).ToString()+")");
Line 57:                 
Line 58:                 objX.WriteEndElement();

Source File: h:\root\home\barrettm-001\www\barrettmanor\julie\fullrss.aspx.cs    Line: 56

Stack Trace:


[SqlNullValueException: Data is Null. This method or property cannot be called on Null values.]
   System.Data.SqlClient.SqlBuffer.get_Int32() +1809288
   System.Data.SqlClient.SqlDataReader.GetInt32(Int32 i) +64
   BarrettManor.RSS.Feed.Page_Load(Object sender, EventArgs e) in h:\root\home\barrettm-001\www\barrettmanor\julie\fullrss.aspx.cs:56
   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.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +693


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