Contents Index Topic Contents

Add Code to Move through the Displayed Recordset

You can use the Move methods with the Recordset in the RDS.DataControl object to navigate through the data records displayed in the data-bound controls on a Web page. For example, suppose you display a Recordset in a grid by binding to an RDS.DataControl object. You can then include First, Last, Next, and Previous buttons that users can click to move to the first, last, next, or previous record in the displayed Recordset. You do this by calling the MoveFirst, MoveLast, MoveNext, and MovePrevious methods of the RDS.DataControl object in the OnClick procedures for the First, Last, Next, and Previous buttons, respectively.

Search for the words "Tutorial: Move Through the Displayed Recordset." Copy the following script and paste it under the comment.

SUB First_OnClick
	ADC.Recordset.MoveFirst
END SUB

SUB Next_OnClick
	If ADC.Recordset.EOF Then	'can not move beyond bottom record
		ADC.Recordset.MoveFirst 
		Exit Sub
	End If	

	ADC.Recordset.MoveNext
END SUB

SUB Prev_OnClick
	If ADC.Recordset.BOF Then	'can not move beyond top ‘record
		ADC.Recorset.MoveFirst	'Get out of BOF buffer
		ADC.Recordset.MoveLast
		Exit Sub
	End If
	ADC.Recordset.MovePrevious
END SUB

SUB Last_OnClick
	ADC.Recordset.MoveLast
END SUB
</Script>

---

 Top of Page
© 1997 Microsoft Corporation. All rights reserved. Terms of Use.