Server Error in '/' Application.

There is no row at position 0.

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.IndexOutOfRangeException: There is no row at position 0.

Source Error:


Line 38:             blogArticle.Load(sdr);
Line 39:             sdr.Close(); sqlCon.Close();
Line 40:             int views = int.Parse(blogArticle.Rows[0]["HitCount"].ToString());
Line 41:             newCount = views + 1;
Line 42:             SqlCommand updateViews = new SqlCommand("UPDATE Blog SET HitCount=@HitCount WHERE ID=@ID", sqlCon);

Source File: d:\Inetpub\vhosts\idealmsp.com\appomattoxhistorical.org\blog\article\Default.aspx.cs    Line: 40

Stack Trace:


[IndexOutOfRangeException: There is no row at position 0.]
   System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex) +119
   System.Data.DataRowCollection.get_Item(Int32 index) +20
   blog_article_Default.Page_Load(Object sender, EventArgs e) in d:\Inetpub\vhosts\idealmsp.com\appomattoxhistorical.org\blog\article\Default.aspx.cs:40
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +85
   System.Web.UI.Control.OnLoad(EventArgs e) +79
   System.Web.UI.Control.LoadRecursive() +130
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2853


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