OLEDBDataReader

[lindy2003]

I got the error say : "Addition Information: No data exists for row/column" when I loaded data from OledBdatareader to textbox.

 

Here is my code

 

Function GetCustomer() as boolean

Dim dr as oledb.oledbDatareader

dim mycommand as new Oledb.OledbCommand()

dim myConn as new oledb.OledbConnection()

dim strSql as string

strSql = "Select SerialNumber, LastName, FirstName From Customer"

myconn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = C:\Customer.mdb'"

myconn.open

mycommand = new oledb.oledbcommand(strsql, myconn)

try

dr = mycommand.executereader()

catch ex as oledb.oledbexception

return false

end try

while dr.read()

txtSerialNumber.text = dr("SerialNumber")

txtLast.text = dr("LastName")

txtFirst.text= dr("FirstName")

end while

dr.close

myconn.close

return true

End function

 

I debugged and It gave me the error at dr("LastName"). Please help me with this problem. Thanks

[Robby]

Are you trying to bind the textboxes to the data?

In your code you are looping the DR, so what happens if there are 100 rows in it, will you display only the last row in your textbox?

[lindy2003]

Actually it has only one row

[Robby]

Are there any Null values in the table?