There is no row at position 0. (Deployed on IIS)

Joem Orcullo

10y3.7k.NET

Hi guys can you help me on this one, I'm only having this error when my site is deployed on IIS

Source Error:

An unhandled exception was generated during the execution of the  current web request. Information regarding the origin and location of the  exception can be identified using the exception stack trace below.

Stack Trace:

[IndexOutOfRangeException: There is no row at position 0.]    
System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex) +1556386    
System.Data.DataRowCollection.get_Item(Int32 index) +20    
HRMS.Index.Page_Load(Object sender, EventArgs e) in 
C:\Users\orculloj\Desktop\New folder (2)\HRMS\HRMS\Index.aspx.vb:83    
System.Web.UI.Control.OnLoad(EventArgs e) +92    
System.Web.UI.Control.LoadRecursive() +54    
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, 
Boolean includeStagesAfterAsyncPoint) +772

HERE IS MY PAGE_LOAD CODE:

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim DomainUser As String = System.Web.HttpContext.Current.User.Identity.Name.Replace("\", "/")
'Dim DomainUser As String = System.Security.Principal.WindowsIdentity.GetCurrent.Name.Replace("\", "/")
Dim sUser() As String = Split(DomainUser, "/")
Dim sUserId As String = ""
'Dim sDomain As String = sUser(0)
If DomainUser <> "" Then
sUserId = sUser(1)
End If
pubUser = sUserId
'pubUser = "ricerrae"
userID.Text = pubUser
'UpdateUserStatusTemp()
GetEmpInfo()
LastLeave()
PopulateHolidays(Val(lblMonth.Text))
If Not Page.IsPostBack Then
If dtEmp.Rows.Count > 0 Then
employeeID = dtEmp.Rows(0)("EmpID")
employeeName = dtEmp.Rows(0)("EmpName")
employeeSupervisor = dtEmp.Rows(0)("MngrName")
employeeDepartment = dtEmp.Rows(0)("LOBDesc")
employeeLocation = dtEmp.Rows(0)("Location")
employeeDoj = CDate(dtEmp.Rows(0)("DateJoined")).ToString("MMMM dd, yyyy")
employeeApprover = dtEmp.Rows(0)("MngrName")
empID.Text = employeeID
empName.Text = employeeName
supervisor.Text = employeeSupervisor
dept.Text = employeeDepartment
doj.Text = employeeDoj
approver.Text = employeeApprover
End If
PopulateHolidays(Today.Month)
If dtHoliday_reg.Rows.Count > 0 Then
lblMonth.Text = Today.Month
lblLeaveBal.Text = IIf(IsDBNull(dtEmp.Rows(0)("LeaveBal")), "00", dtEmp.Rows(0)("leaveBal"))
End If
If dtChkLeave.Rows.Count > 0 Then
lblLastLeave.Text = dtChkLeave.Rows(0)("LastLeave")
End If
End If
End Sub

PS: as you would notice, my code is in vb and i know this is a c# forum, so ill just convert my code or your answer. THANKS

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Joem Orcullo10y ago
@Pradeep Sahoo and @Ravi Patel hi guys thanks for your answer, but im only having this when i launched it on IIS, when im running this locally im not having this error and i also checked the db the columns that i need all have a data.
Ravi Patel10y ago
Hi ,
it seems issue in line no 48 . you are trying to assign value to label without checking the dtEmp.Rows.Count, so you have to check your dtEmp have data or not then if dtEmp have data then you can assign it .
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

Dim DomainUser As String = System.Web.HttpContext.Current.User.Identity.Name.Replace("\", "/")
'Dim DomainUser As String = System.Security.Principal.WindowsIdentity.GetCurrent.Name.Replace("\", "/")

Dim sUser() As String = Split(DomainUser, "/")
Dim sUserId As String = ""
'Dim sDomain As String = sUser(0)
If DomainUser <> "" Then
sUserId = sUser(1)
End If

pubUser = sUserId

'pubUser = "ricerrae"

userID.Text = pubUser

'UpdateUserStatusTemp()

GetEmpInfo()
LastLeave()
PopulateHolidays(Val(lblMonth.Text))

If Not Page.IsPostBack Then
If dtEmp.Rows.Count > 0 Then
employeeID = dtEmp.Rows(0)("EmpID")
employeeName = dtEmp.Rows(0)("EmpName")
employeeSupervisor = dtEmp.Rows(0)("MngrName")
employeeDepartment = dtEmp.Rows(0)("LOBDesc")
employeeLocation = dtEmp.Rows(0)("Location")
employeeDoj = CDate(dtEmp.Rows(0)("DateJoined")).ToString("MMMM dd, yyyy")
employeeApprover = dtEmp.Rows(0)("MngrName")

empID.Text = employeeID
empName.Text = employeeName
supervisor.Text = employeeSupervisor
dept.Text = employeeDepartment
doj.Text = employeeDoj
approver.Text = employeeApprover
End If

PopulateHolidays(Today.Month)

If dtHoliday_reg.Rows.Count > 0 Then
lblMonth.Text = Today.Month
// here you have to check If dtEmp.Rows.Count > 0
lblLeaveBal.Text = IIf(IsDBNull(dtEmp.Rows(0)("LeaveBal")), "00", dtEmp.Rows(0)("leaveBal"))

End If

If dtChkLeave.Rows.Count > 0 Then
lblLastLeave.Text = dtChkLeave.Rows(0)("LastLeave")
End If

End If
End Sub
Pradeep Sahoo10y ago
It looks like there is no data in the table ,if you debug the code it will show that the dtEmp is null or the column is null or the value of the column is null .Handle proper null check , count check before assigning the value from the datatable in the below lines .
employeeID = dtEmp.Rows(0)("EmpID")
employeeName = dtEmp.Rows(0)("EmpName")
employeeSupervisor = dtEmp.Rows(0)("MngrName")
employeeDepartment = dtEmp.Rows(0)("LOBDesc")
employeeLocation = dtEmp.Rows(0)("Location")
employeeDoj = CDate(dtEmp.Rows(0)("DateJoined")).ToString("MMMM dd, yyyy")
employeeApprover = dtEmp.Rows(0)("MngrName")