I'm making a program and i need to navigate forward and backward trough records. I was used to work with the original ADODB commands like RS.movenext,... Now i need to do this in VB.NET but have no idea how to do this. I'm programming in VB.NET and i want to use an SQL query to get the records. After that the user can browse the records by using a back and next button. Can somebody give me a simple, clear and documentated VB.NET example how to do this.
Thanks in advance
My code so far:
Dim cmd As New System.Data.SqlClient.SqlCommand("Select FuifID,Fuifnaam,Fuifstart,Actief FROM tblFuif WHERE actief=1", SQLConn)
Dim reader As System.Data.SqlClient.SqlDataReader = cmd.ExecuteReader()
Catch ex As Exception
MsgBox("Error while fetching tblPersoon: " & ex.Message, MsgBoxStyle.Critical)