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 94: 	Function loadNames() As Integer
Line 95:         Dim dtResults As DataTable = Nexus.loadTable("Select architect_id, name, DATE_FORMAT(Rego_Date, '%Y') AS Rego_Date, Cert_No From architects Where architect_id = '" & Request.QueryString("architectid") & "' order by name;")
Line 96:         Dim drRow As DataRow = dtResults.Rows(0)
Line 97:                 
Line 98:         strNames = strNames & "<a href='architect-profile.aspx?id=" & Request.QueryString("id") & "&Council=" & strCouncil & "&businessname=" & Server.UrlEncode(strBusinessname) & "&architectid=" & drRow.Item("architect_id") & "&architect=" & Server.UrlEncode(drRow.Item("name")) & "'>" & drRow.Item("name") & "</a><br><img src='images/transparent.gif' width='10' height='3'><br>"

Source File: C:\websites\architects.net.au\www\architect-profile.aspx    Line: 96

Stack Trace:


[IndexOutOfRangeException: There is no row at position 0.]
   System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex) +2567213
   System.Data.RBTree`1.get_Item(Int32 index) +16
   System.Data.DataRowCollection.get_Item(Int32 index) +16
   ASP.architect_profile_aspx.loadNames() in C:\websites\architects.net.au\www\architect-profile.aspx:96
   ASP.architect_profile_aspx.Page_Load(Object Sender, EventArgs E) in C:\websites\architects.net.au\www\architect-profile.aspx:51
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +25
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +42
   System.Web.UI.Control.OnLoad(EventArgs e) +132
   System.Web.UI.Control.LoadRecursive() +66
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2428


Version Information: Microsoft .NET Framework Version:2.0.50727.8974; ASP.NET Version:2.0.50727.8974