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 500:            my_dataadapter.Fill(my_dataset, "tbl_tours")
Line 501:
Line 502:            zone_name = fix_null(my_dataset.Tables("tbl_tours").Rows(0).Item("zone_name"))
Line 503:            my_connection.Close()
Line 504:            my_connection.Dispose()

Source File: h:\root\home\deoinbox-001\www\nexttour\tours\tours.aspx    Line: 502

Stack Trace:


[IndexOutOfRangeException: There is no row at position 0.]
   System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex) +2140712
   System.Data.DataRowCollection.get_Item(Int32 index) +22
   ASP.tours_tours_aspx.load_tours() in h:\root\home\deoinbox-001\www\nexttour\tours\tours.aspx:502
   ASP.tours_tours_aspx.Page_Load(Object sender, EventArgs e) in h:\root\home\deoinbox-001\www\nexttour\tours\tours.aspx:37
   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