im working on views that can help me navigate through records in a table. i have managed to execute an sql string to select the table i.e "select * from Users"
i however want to build a "Previous" and "Next" command on the view but im mixed up on the navigation
this is what i have:
Private Sub viewusers_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load conn.Open() userstring = "select * from Users" usercmd = New SqlCommand(userstring, conn) usercmd.ExecuteReader() End Sub
Now all i need is code for going forward or backwards to a record. Some help please.