Programmatically Loop Through Sqldatasource - Which Event To Place It In...to Get The Right Order....

Hello,  I want to loop through the first 10 records that are showing in a gridview with several pages that is populated by a sqldatasource.  I can loop through the sqldatasource and get the list of values, but I'm doing something wrong because the 10 records it prints out are not the same 10 records the user sees in the gridview...They can click a search button which changes the sort, and they can click on the column headings to change the sort order.

Where's the best place to put the looping code?  I need the result to be the same as what the users sees. 

  1        Protected Sub GridView1_Sorted(ByVal sender As Object, ByVal e As System.EventArgs) Handles GridView1.Sorted
2            Dim i As Integer = -1
3            Dim sTest As String = ""
4            Dim vwExpensiveItems As Data.DataView = CType(SqlDataSource1.Select(DataSourceSelectArguments.Empty), Data.DataView)
5   
6            'Loop through each record
7            i = -1
8            For Each rowProduct As Data.DataRowView In vwExpensiveItems
9                i = i + 1
10               'Output the name and price
11               If i > 9 Then
12                   Exit For
13               End If
14               sTest = rowProduct("employeeid")
15               Response.Write("RowSorting " & i.ToString & " [" & sTest & "]<br>")
16           Next
17       End Sub
18