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")