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 156:                strSQL = "Select ClinicNum, tClinicType.ClinicTypeName, tClinicType.pkClinicType,ClinicFacilityCity FROM tClinic INNER JOIN tClinicType ON tClinic.fkClinicType=tClinicType.pkClinicType WHERE pkClinic =  " & intpkClinic
Line 157:                dtblClinic = db_tools.sqlSelect_dtbl(strSQL)
Line 158:                strClinicName = dtblClinic.Rows(0).Item("ClinicTypeName")
Line 159:                strClinicNum = dtblClinic.Rows(0).Item("ClinicNum")
Line 160:                strClinicCity = dtblClinic.Rows(0).Item("ClinicFacilityCity")

Source File: C:\inetpub\wwwroot\stsr\www\MemberRegister.aspx.vb    Line: 158

Stack Trace:


[IndexOutOfRangeException: There is no row at position 0.]
   System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex) +2136515
   System.Data.DataRowCollection.get_Item(Int32 index) +21
   MemberRegister01.initForm() in C:\inetpub\wwwroot\stsr\www\MemberRegister.aspx.vb:158
   MemberRegister01.Page_Load(Object sender, EventArgs e) in C:\inetpub\wwwroot\stsr\www\MemberRegister.aspx.vb:106
   System.Web.UI.Control.OnLoad(EventArgs e) +95
   System.Web.UI.Control.LoadRecursive() +59
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +678


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