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 347:
Line 348:        DataTable dtNew = (DataTable)dt;
Line 349:        intLocation = Convert.ToInt32(dtNew.Rows[0]["Location"].ToString());
Line 350:
Line 351:        if (intLocation == 1)

Source File: c:\inetpub\wwwroot\prep2prep.com\httpdocs\sports\boysfootball\photos.aspx.cs    Line: 349

Stack Trace:


[IndexOutOfRangeException: There is no row at position 0.]
   System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex) +2440141
   System.Data.DataRowCollection.get_Item(Int32 index) +19
   _sports_boysfootball_photos.GetGame() in c:\inetpub\wwwroot\prep2prep.com\httpdocs\sports\boysfootball\photos.aspx.cs:349
   _sports_boysfootball_photos.InitializeVariables() in c:\inetpub\wwwroot\prep2prep.com\httpdocs\sports\boysfootball\photos.aspx.cs:127
   _sports_boysfootball_photos.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\prep2prep.com\httpdocs\sports\boysfootball\photos.aspx.cs:108
   System.Web.UI.Control.OnLoad(EventArgs e) +106
   System.Web.UI.Control.LoadRecursive() +68
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3785


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