trying to make small datagrid view

[didgydont]

hello all
dont realy know how to explain this but im trying to make a summary that when the user clicks on it goes to a complete view i had it working but when i added transid 12 it for some reason wrote it at the start of the mdb file now it only show transaction 12

'read data
        Rec.Open("SELECT * FROM records", Conn, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic)
        Dim trasid As Integer = 0
        While Not Rec.EOF
            If Rec.Fields("TransID").Value > trasid Then
                DataGridView2.Rows.Add(Rec.Fields("TransID").Value, Rec.Fields("Sold").Value)
                trasid = Rec.Fields("TransID").Value
            End If
            Rec.MoveNext()
        End While
        Rec.Close()

 

[didgydont]

this fixed it sorry

'read data
        Rec.Open("SELECT * FROM records order by TransID", Conn, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic)
        Dim trasid As Integer = 0
        While Not Rec.EOF
            If Rec.Fields("TransID").Value > trasid Then
                DataGridView2.Rows.Add(Rec.Fields("TransID").Value, Rec.Fields("Sold").Value)
                trasid = Rec.Fields("TransID").Value
            End If
            Rec.MoveNext()
        End While
        Rec.Close()