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 104:                GridView1.DataBind()
Line 105:            Else
Line 106:                comp_name.Text = IIf(IsDBNull(worktable.Rows(0)("COMPNA")), "", worktable.Rows(0)("COMPNA"))
Line 107:                GridView1.DataSource = worktable
Line 108:                GridView1.DataBind()

Source File: C:\HostingSpaces\isconline\mtid.in\wwwroot\Dashboard_info.aspx.vb    Line: 106

Stack Trace:


[IndexOutOfRangeException: There is no row at position 0.]
   System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex) +2441565
   System.Data.DataRowCollection.get_Item(Int32 index) +19
   Dashboard_info.fill(String search) in C:\HostingSpaces\isconline\mtid.in\wwwroot\Dashboard_info.aspx.vb:106
   Dashboard_info.Page_Load(Object sender, EventArgs e) in C:\HostingSpaces\isconline\mtid.in\wwwroot\Dashboard_info.aspx.vb:20
   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.4081.0