System.IndexOutOfRangeException

[Genki]

New to the whole ASP.Net scene I am trying to do a simple database query with a INITCAP function but each time it comes up with the system.indexoutoffrangeexecption. Can some one please help me out with this?

 

Dim strSQL as string = "Select dbo.INITCAP(fname), dbo.INITCAP(lname), tellernum, username from employees where tellernum = 345;"

Dim cmd as new sqlcommand(strSQL, objConnection)

Dim reader1 as SQLdataReader

objConnection.open()

reader1 = cmd.executereader()

 

vuserid.text = reader1.item("username") & " " &

reader1.item(tellernum")

vname.text = reader1.item("fname") & " " & reader1.item("lname")

[Cassio]

Use this:

 

If reader1.Read() Then
    vuserid.text = reader1.item("username") & " " & 
    reader1.item(tellernum") 
   vname.text = reader1.item("fname") & " " & reader1.item("lname")
End If