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 122:
Line 123:        Else
Line 124:            If dscat.Tables(0).Rows(0).Item("biznet").ToString = "1" Then
Line 125:                ds = dat1.opends("select * from AnnParishView    where pid in (select m_pid from bizcircle where c_pid =" + pid.ToString + ") or  pid=" + pid.ToString + " order BY annid desc")
Line 126:

Source File: C:\myparishsites\www2021\community\search.aspx.vb    Line: 124

Stack Trace:


[IndexOutOfRangeException: There is no row at position 0.]
   System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex) +2519554
   System.Data.DataRowCollection.get_Item(Int32 index) +20
   Community_search.loadser() in C:\myparishsites\www2021\community\search.aspx.vb:124
   Community_search.Page_Load(Object sender, EventArgs e) in C:\myparishsites\www2021\community\search.aspx.vb:13
   System.Web.UI.Control.OnLoad(EventArgs e) +108
   System.Web.UI.Control.LoadRecursive() +90
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1533


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