Member Avatar for SolTec

Is there some simple code to move first, previous, next and last in a dataset without using the wizard and creating your own buttons?

Thanks in advance for any and all assistance, it it greatly appreciated.

  • 2 Contributors
  • 1 Reply
  • 70 Views
  • 14 Hours Discussion Span
  • Latest Post Latest Post by emurf
Member Avatar for emurf

Declare a dataset and integer globally and fill the dataset. In the click events of your previous and next buttons put a line that gets the record.

'first, do some validation to make sure that this isn't the last rec 
'then inc the rec count
intCount += 1

'get the record & put vals where you need them
textbox.Text = ds.Tables("tablename").Rows(intCount).Item("itemname").ToString & ""

The previous button will be the same but decrementing the counter variable -=

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.